单项选择题
The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information?()
A. Fixed views
B. The alert log file
C. The parameter file
D. The server parameter file
E. Dynamic performance views
相关考题
-
单项选择题
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
A. Flashback logs are not deleted.
B. Flashback logs are deleted automatically.
C. Flashback logs are deleted only if you are using Recovery Manager (RMAN)
D. Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
E. Flashback logs are deleted only if you are using Automatic Storage Management (ASM) -
单项选择题
YouobservethattheseniordatabaseadministratoralwaysusesthefollowingcommandwhenconnectingtoRecoveryManager(RMAN),andthenstartsexecutingcommandstobackupthedatabasefiles:%rmantarget/Whatwouldbetheeffectofthiscommand?()
A. RMAN would use the current operating system location to place the backup.
B. RMAN would use the control file of the target database to maintain the backup.
C. RMAN would use the recovery catalog of the target database to maintain the backup.
D. RMAN would use the control file of the target database to maintain the backup metadata.
E. RMAN would use the recovery catalog of the target database to maintain the backup metadata. -
单项选择题
Case 1: 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files, open the database using the RESETLOGS option. 6. Back up the database. Case 2: 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3: 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()
A. Only case 1
B. Only case 2
C. Only case 3
D. Case 1 and 2
E. Case 2 and 3
F. Case 1 and 3
G. All cases, case 1, case 2, case 3
