Oracle Database 11g Certified Master Upgrade 認定 11gocmu 試験問題:

1. If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

A) The alter database archivelog command will succeed.
B) The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
C) The alter database archivelog command will fail.
D) The alter database archivelog command will ask if you want to make the database consistent first.
E) There is no alter database archivelog command. The correct command is alter database alterlogging.

2. Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?

A) The datafile in hot backup mode will be corrupted and you will have to recover it.
B) The database will open with the file in hot backup mode. You can restart the backup at any time.
C) Oracle will automatically take the datafile out of hot backup mode and then open the database.
D) Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.
E) Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mode. You will need to correct this error before you can open the database.

3. You want to set the following Initialization parameters for your database Instance
LOG_ARCHIVE_DEBT_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DBST_2 = 'LOCATION=/disk2/arch' LOC_ARCHIVB DBST_3 = 'LOCATION=/disk3/arch' LOG_ARCHIVE DBST_ = 'LOCATION=/disk3/arch'
Identify the statement that correctly describes this setting.

A) The optional destinations may not use the flash recovery area.
B) This setting is not allowed because the first destination is not set as MANDATORY.
C) The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
D) The MANDATORY location must be a flash recovery area.

4. You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?

A) Archived redo logs
B) None of the above, all these files are backed up.
C) Online redo logs
D) Database Datafiles
E) Database Control Files
F) The database SPFILE

5. The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

A) touser
B) attach
C) owner
D) remap_schema

質問と回答：