every Friday. The job has successfully completed. Which three pieces of information would you check to
confirm that the statistics have been collected (Choose three.)
A) average row size
B) last analyzed date
C) size of table in bytes
D) size of table in database blocks
E) number of free blocks in the free list
F) number of extents present in the table
答案：ABD
http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/stats.htm#PFGRF94712
16.5.1 Verifying Optimizer Statistics
http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/sql_overview.htm#PFGRF94815
39. Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:
LSNRCTL> STOP
What would happen to the sessions that are presently connected to the database instance
A) The sessions are able to perform only queries.
B) The sessions are not affected and continue to function normally.
C) The active transactions are rolled back and the sessions get terminated.
D) The sessions are not allowed to perform any operations till the listener is started.
答案：B
40. After being hired as a database administrator, you find that there is only one database that is functional
and that is being accessed by the applications. You want to create a replica of the database, to be used for
testing purposes. What is the best method to create the replica
A) create a database by using CREATE DATABASE .. command and manually copy the data
B) use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the
database structure
C) use DBCA to create a template from the existing database to contain the database structure and then manually
copy the data using Oracle Data Pump
D) use DBCA to create a template from the existing database to contain the database structure with data files and then
use the same template to create the database in the new location
答案：D
41. You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database
A) The database performance would be enhanced.
B) The redo log files would be get filled more frequently.
C) The overall database performance would be degraded.
D) The mean time to recover (MTTR) would be increased.
答案：C
10.5.3 Tuning FAST_START_MTTR_TARGET and Using MTTR Advisor
http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/instance_tune.htm#PFGRF13015
42. You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2:00 p.m.
A) Perform point-in-time recovery to 2:00 p.m.
B) Use Flashback Table feature to revert the changes.
C) Restore the entire database from the recent backup and open it.
D) Issue the rollback statement with system change number (SCN).
答案：B
43. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true
A) The backup is similar to image copy.
B) The backup contains all used data blocks.
C) The backup contains only unused data blocks.
D) The backup contains all data blocks changed since the last incremental level 1 backup.
答案：B