Automatic statistics collection is stopped for the CUSTOMERS table.
Statistics for the CUSTOMERS table are locked and cannot be overwritten.
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.
第1题:
Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?()
A.
B.
C.
D.
第2题:
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()
第3题:
Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statementdescribes the effect of the above command()
第4题:
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.()
第5题:
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?()
第6题:
Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()
第7题:
use the ROLLBACK command with SCN 663571
perform Flashback Transaction Query with SCN 663571
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
第8题:
Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
第9题:
show users
show connected
show subscribers
show ip subscribers
第10题:
Automatic statistics collection is stopped for the CUSTOMERS table.
Statistics for the CUSTOMERS table are locked and cannot be overwritten.
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.
第11题:
It updates the existing SQL profiles with current statistics.
It makes the statistics information available to GATHER_STATS_JOB
It initiates the statistics collection process by running GATHER_STATS_JOB
It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
第12题:
The statistics are stored in the pending statistics table in the data dictionary.
The statistics are treated as the current statistics by the optimizer for all sessions.
The statistics are treated as the current statistics by the optimizer for the current sessions only.
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
第13题:
A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.
B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.
C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.
D.Subsequently,statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
第14题:
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()
第15题:
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
第16题:
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?()
第17题:
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
第18题:
3,2,1,4
2,3,4,1
4,1,3,2
3,2,4,1
第19题:
Restore the backup control file and open the database with RESETLOGS option.
Perform point-in-time recovery because flashback cannot be performed again on this table
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
第20题:
Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
第21题:
Automatic statistics collection is stopped for the CUSTOMERS table.
Statistics for the CUSTOMERS table are locked and cannot be overwritten.
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics
第22题:
It updates the existing SQL profiles with current statistics
It makes the statistics information available to GATHER_STATS_JOB
It initiates the statistics collection process by running GATHER_STATS_JOB
It logs a warning message in the alert log so that the DBA can perform statistics collection manually
第23题:
Use ROLLBACK command with SCN 663571.
Perform Flashback Transaction Query with SCN 663571.
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
第24题:
The statistics are stored in the pending statistics table in the data dictionary.
The statistics are treated as the current statistics by the optimizer for all sessions.
The statistics are treated as the current statistics by the optimizer for the current sessions only.
The statistics are temporary and used by the optimizer for all sessions until this session terminates.