You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.
After some days， you want to change the status of the database backup and you issued the following command：
RMAN>CHANGE BACKUPSET 231 NOKEEP；
What is the implication of this command？（）
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy.
您可能感兴趣的试卷
你可能感兴趣的试题
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created？（）
A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
C. It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this：
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242；
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Examine the section of the Health Check report given below：
DBMS_HM.GET_RUN_REPORT（’HM_RUN_1061’）
Run Name ： HM_RUN_1061 Run Id ： 1061 Check Name ： Data Block Integrity Check Mode ： REACTIVE Status ： COMPLETED Start Time ： 2007-05-12 22：11：02.032292 -07：00 End
Time ：
2007-05-12 22：11：20.835135 -07：00 Error Encountered ： 0 Source Incident Id ： 7418 Number of Incidents Created ：0
Which two statements are true regarding the Health Check report？（）
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.
When you attempt to start the database， you receive the following errors：（）
A. ALTER DATABASE DROP LOGFILE GROUP 1
B. ALTER DATABASE CLEAR LOGFILE GROUP 1
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
D. ALTER DATABASE DROP LOGFILE MEMBER ’D：\REDO01.LOG’
While deploying a new application module，the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences？（）
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
最新试题
Which two client requests are captured during database replay Capture？（）
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch？（）
In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）
You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file.2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（）
Which three statements are true about persistent configuration？（）
Which two statements are true about a job chain？（）
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL> ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE 5. Open the database： SQL> ALTER DATABASE OPEN； Choose the correct sequence.（）