In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;
第1题：
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（）Mysql＞ SELECT * INTO OUTFILE ‘/tmp/t1.sql‘ from t1;mysql＞ TRUNCATE t1;
A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B.Mysql＞ INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘
C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
D.Mysql＞ LOAD DATA INFILE ‘/tmp/t1.sql‘ INTO TABLE t1
E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
第2题：
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
第3题：
A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.
第4题：
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）
第5题：
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
第6题：
A. The database must have multiplexed redo logs for the flashback to succeed.
B. The database must be MOUNTED for the flashback to succeed.
C. The database must use block change tracking for the flashback to succeed.
D. The database must be opened in restricted mode for the flashback to succeed.
E. The database must be opened with the RESETLOGS option after the flashback is complete.
F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
第7题：
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）
第8题：
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）
A. 1,6,5,4,7
B. 6,5,4
C. 6,2,3,7
D. 1,6,3
E. The database cannot be recovered
第9题：
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
第10题：
If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）