网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You executed the following commands: Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）
A
The statistics are stored in the pending statistics table in the data dictionary.
B
The statistics are treated as the current statistics by the optimizer for all sessions.
C
The statistics are treated as the current statistics by the optimizer for the current sessions only.
D
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You executed the following commands: Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）A The statistics are stored in the pending statistics table in the data dictionary.B The statistics are treated as the current statistics by the optimizer for all sessions.C The statistics are treated as the current statistics by the optimizer for the current sessions only.D The statistics are temporary and used by the optimizer for all sessions until this session terminates.” 相关考题
考题
You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()
A. The statistics are stored in the pending statistics table in the data dictionary.B. The statistics are treated as the current statistics by the optimizer for all sessions.C. The statistics are treated as the current statistics by the optimizer for the current sessions only.D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
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
考题
You need to design the retrieval of advertising statistics without compromising security. What should you do?（）A、Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.B、Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.C、Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.D、Design a stored procedure to return the statistics on a call from the advertisers application.E、Design a user-defined function to return the statistics on a call from the advertisers application.
考题
Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）A、Automatic statistics collection is stopped for the CUSTOMERS table.B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
考题
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A、 Set DYNAMIC_SAMPLING to level 4B、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the INCREMENTAL value to TRUE for the partition tableD、 Increase the value of STALE_PERCENT for the partition table
考题
You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）A、 Every SQL statement in the STS is considered only once for execution.B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.C、 The execution plan and execution statistics are computed for each SQL statement in the STS. D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.
考题
You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A、 The statistics are stored in the pending statistics table in the data dictionary.B、 The statistics are treated as the current statistics by the optimizer for all sessions.C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
You created the ORDERS table in your database by using the following code： SQL CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL COMMIT； Next， you issued the following statement to change the time zone for the database： SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（） A、 The statement will fail.B、 The statement will be executed successfully， and the new time zone will be set for the database.C、 The statement will be executed successfully， but the new time zone will be set for the current session.D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
考题
Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
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.
考题
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
考题
Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A、Automatic statistics collection is stopped for the CUSTOMERS table.B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
考题
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL *Loader.D、New data conforms to the constraint， but existing data is not checked.E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
考题
You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 = You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）A、Update all statistics on Table1 in DB1.B、Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.C、Set the priority boost server option to 1.D、Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO
考题
单选题You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 = You need to provide maximum query performance. Table1 must remain available to users. What should you do？（）A
Update all statistics on Table1 in DB1.B
Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.C
Set the priority boost server option to 1.D
Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO
考题
单选题You need to design the retrieval of advertising statistics without compromising security. What should you do?（）A
Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.B
Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.C
Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.D
Design a stored procedure to return the statistics on a call from the advertisers application.E
Design a user-defined function to return the statistics on a call from the advertisers application.
考题
单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A
The data in the segment will be compacted but the high water mark will not be adjusted B
The EMPLOYEES table will be changed to read-only mode during the shrink operation C
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overD
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation E
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
考题
多选题Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）A
Automatic statistics collection is stopped for the CUSTOMERS table.B
Statistics for the CUSTOMERS table are locked and cannot be overwritten.C
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D
Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
考题
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A
Automatic statistics collection is stopped for the CUSTOMERS table.B
Statistics for the CUSTOMERS table are locked and cannot be overwritten.C
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D
Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
考题
单选题You created the ORDERS table in your database by using the following code： SQL CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL COMMIT； Next， you issued the following statement to change the time zone for the database： SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（）A
The statement will fail.B
The statement will be executed successfully， and the new time zone will be set for the database.C
The statement will be executed successfully， but the new time zone will be set for the current session.D
The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
考题
单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A
The EMPLOYEES table will be changed to read-only mode during the shrink operation.B
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
考题
单选题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.
考题
单选题You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A
Set DYNAMIC_SAMPLING to level 4B
Set the STATISTICS_LEVEL parameter to BASICC
Set the INCREMENTAL value to TRUE for the partition tableD
Increase the value of STALE_PERCENT for the partition table
考题
单选题You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A
The statistics are stored in the pending statistics table in the data dictionary.B
The statistics are treated as the current statistics by the optimizer for all sessions.C
The statistics are treated as the current statistics by the optimizer for the current sessions only.D
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
多选题You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）AEvery SQL statement in the STS is considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.
热门标签
最新试卷