A. To create and execute an RMAN stored script, you must use a recovery catalog.
B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
您可能感兴趣的试卷
你可能感兴趣的试题
A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs.
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
You executed the following command in the Recovery Manager (RMAN):
RMAN> REPORT NEED BACKUP days 3;
What is the output of this command?()
A. A list of files that require a backup within 3 days
B. A list of files requiring more than 3 days of archivelogs to apply
C. A list of files that RMAN recommends be backed up only once in every three days,based on low volatility
D. A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
B. If the lost redo log group is CURRENT, you must clear the log file.
C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
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:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?()
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
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.
What configuration would you effect to achieve your objective?()
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C. Use compression when performing tape backups
D. Configure multiple SBT channels
When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this?()
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan,and not performance regression,are detected.
You execute the following Recovery Manager (RMAN) commands in he following order:
BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST;
Which two tasks are performed by these commands?()
A. Repair the corrupted blocks. If any. In the backup created
B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C. Back up the database after checking whether array of the files have corrupted blocks
D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C. The database instance starts, but Automatic Memory Management is disabled
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
A.ASMB
B.PMON
C.RBAL
D.SMON
最新试题
Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2; In which situation would you use this method of disk group creation?()
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()
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?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?()
Which three functions are performed by the SQL Tuning Advisor?()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()