2,1,3,4,5,6
2,4,5,3
4,7,3
2,4,7,3
2,7,3
第1题:
You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()
第2题:
A user sends you an email with the following error message: create table idtable(id number) * ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/oradata/orcl/users01.dbf ORA-27041: 01116: error in opening database file 4 ORA-unable to open file Linux Error: 2: No such file or directory Additional information: 3 You can choose from the following steps: a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case?()
第3题:
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
第4题:
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command: RMAN>BACKUP DATABASE; At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command?()
第5题:
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?() a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.
第6题:
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()
第7题:
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()
第8题:
At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()
第9题:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
第10题:
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()