单选题Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns siz

题目
单选题
Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）
A

The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 

B

The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.

C

The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 

D

The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

相似考题

1.Note the following parameters settings in your database:What would happen?()A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB. It will be successful only if the memory is available from the auto tuned componentsC. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

2.What is true about joining tables through an equijoin? ()A. You can join a maximum of two tables through an equijoin.B. You can join a maximum of two columns through an equijoin.C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

3.Consider the following:Which statement best describes the meaning of the value for the key_len column?()A.It shows the total size of the index rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row

4.Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()A. It collects statistics into the pending area in the data dictionaryB. It creates a virtual hidden column in the CUSTOMERS_OBE tableC. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENTD. It creates a histogram to hold skewed information about the data in the columns

更多“单选题Consider the following statement：   SQL EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2 ownname = ‘OE’， -  3 estimate_percent = DBMS_STATS.AUTO_SAMPLE_SIZE， -  4 method opt = ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’”相关问题

  • 第1题：

    The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?()

    A. Column definitions cannot be altered to add DEFAULT values.

    B. A change to the DEFAULT value affects only subsequent insertions to the table.

    C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

    D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.


    参考答案：B

  • 第2题：

    Considerthefollowingstatement：SQL>EXECUTEDBMS_STATS.GATHER_SHEMA_STATS（-2>ownname=>‘OE’，-3>estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE，-4>methodopt=>‘forallcolumnssizeAUTO’）；Whatistheeffectof‘forallcolumnssizeAUTO’oftheMETHOD_OPToption？（）

    A.TheOracleservercreatesanewhistogrambasedonexistinghistogramdefinitionsforalltable,column,andindexstatisticsfortheOEschema.

    B.TheOracleservercreatesahistogrambasedondatadistributionregardlessofhowtheapplicationusesthecolumn/sforalltable,column,andindexstatisticsfortheOEschema.

    C.TheOracleservercreatesahistogrambasedondataandapplicationusageofthecolumn/sforalltable,column,andindexstatisticsfortheOEschema.

    D.TheOracleservercreatesahistogrambasedonapplicationusage,regardlessofdatadistribution,foralltable,column,andindexstatisticsfortheOEschema.


    参考答案：C

  • 第3题：

    The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）

    • A、Column definitions cannot be altered to add DEFAULT values.
    • B、A change to the DEFAULT value affects only subsequent insertions to the table.
    • C、Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
    • D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

    正确答案:B

  • 第4题：

    The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）

    • A、All of the desired results
    • B、Two of the desired results
    • C、One of the desired results
    • D、An error statement

    正确答案:C

  • 第5题：

    You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

    • A、 10M
    • B、 400M
    • C、 600M
    • D、 800M

    正确答案:D

  • 第6题：

    Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）

    • A、The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 
    • B、The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
    • C、The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 
    • D、The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

    正确答案:C

  • 第7题：

    单选题
    Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
    A

    It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

    B

    It will be successful only if the memory is available from the auto tuned components

    C

    It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

    D

    It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    The SPFILE for the PROD database specifies the following initialization parameter values：   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay， you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M：   SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH；   What is the result of this statement？（）
    A

     The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.

    B

     The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.

    C

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.

    D

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    What is true about joining tables through an equijoin?（）
    A

    You can join a maximum of two tables through an equijoin.

    B

    You can join a maximum of two columns through an equijoin.

    C

    You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.

    D

    To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.

    E

    You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    Which statement is true regarding the INTERSECT operator?（）
    A

    It ignores NULL values 

    B

    Reversing the order of the intersected tables alters the result 

    C

    The names of columns in all SELECT statements must be identical 

    D

    The number of columns and data types must be identical for all SELECT statements in the query 


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    Consider the following statement：   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （-  2> ownname => ‘OE’， -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， -  4> method opt => ‘for all columns size AUTO’）；   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）
    A

    The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 

    B

    The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.

    C

    The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 

    D

    The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Consider the following: Which statement best describes the meaning of the value for the key_len column?（）
    A

    It shows the total size of the index row

    B

    It shows how many columns in the index are examined

    C

    It shows the number of characters indexed in the key

    D

    It shows how many bytes will be used from each index row


    正确答案： A
    解析： 暂无解析

  • 第13题：

    The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?（）

    A. All of the desired results

    B. Two of the desired results

    C. One of the desired results

    D. An error statement


    参考答案：C

  • 第14题：

    Which statement is true regarding the INTERSECT operator?（）

    • A、It ignores NULL values 
    • B、Reversing the order of the intersected tables alters the result 
    • C、The names of columns in all SELECT statements must be identical 
    • D、The number of columns and data types must be identical for all SELECT statements in the query 

    正确答案:D

  • 第15题：

    What is true about joining tables through an equijoin?（）

    • A、You can join a maximum of two tables through an equijoin.
    • B、You can join a maximum of two columns through an equijoin.
    • C、You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
    • D、To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
    • E、You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

    正确答案:E

  • 第16题：

    What does the TRUNCATE statement do?（）

    • A、Removes the table
    • B、Removes all rows from a table
    • C、Shortens the table to 10 rows
    • D、Removes all columns from a table
    • E、Removes foreign keys from a table

    正确答案:B

  • 第17题：

    You create an Oracle 10g database and configure the SPFILE as follows：   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；   Which entity does this statement affect？（） 

    • A、 only the auto-tuned memory components
    • B、 only the memory components that are not auto-tuned
    • C、 both the auto-tuned memory components and the non-auto-tuned memory components
    • D、 neither the auto-tuned memory components nor the non-auto-tuned memory components

    正确答案:A

  • 第18题：

    Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）

    • A、It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
    • B、It will be successful only if the memory is available from the auto tuned components
    • C、It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
    • D、It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

    正确答案:D

  • 第19题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    Consider this syntax：   MERGE INTO t1  USING t2 ON （join predicate）…..   What does the MERGE syntax do？（）
    A

    It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. 

    B

    It creates a natural join of tables T1 and T2 for all columns that have the same name. 

    C

    It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. 

    D

    For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You create an Oracle 10g database and configure the SPFILE as follows：   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；   Which entity does this statement affect？（）
    A

     only the auto-tuned memory components

    B

     only the memory components that are not auto-tuned

    C

     both the auto-tuned memory components and the non-auto-tuned memory components

    D

     neither the auto-tuned memory components nor the non-auto-tuned memory components


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    What does the TRUNCATE statement do?（）
    A

    Removes the table

    B

    Removes all rows from a table

    C

    Shortens the table to 10 rows

    D

    Removes all columns from a table

    E

    Removes foreign keys from a table


    正确答案： E
    解析： 暂无解析

  • 第23题：

    多选题
    Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


    正确答案： C,F
    解析： 暂无解析

  • 第24题：

    单选题
    You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）
    A

     10M

    B

     400M

    C

     600M

    D

     800M


    正确答案： A
    解析： 暂无解析

相关内容