单项选择题

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()

A. Restore the backup control file and open the database with RESETLOGS option.
B. Perform point-in-time recovery because flashback cannot be performed again on this table
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which two statements are true about the Automatic Diagnostic Repository (ADR)?()

A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances

2.多项选择题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()

A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager

3.多项选择题Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

4.多项选择题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

7.多项选择题Which two commands never trigger an implicit rebalancing within the disk group?()

A. ALTER DISKGROUP misc MOUNT;
B. ALTER DISKGROUP misc DROP DISK misc2;
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

8.多项选择题Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period

9.单项选择题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()

A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

10.单项选择题The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()

A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

最新试题

Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()

题型:单项选择题

Which two statements are true about a job chain?()

题型:多项选择题

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()

题型:多项选择题

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()

题型:多项选择题

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

题型:单项选择题

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()

题型:单项选择题

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()

题型:多项选择题

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()

题型:单项选择题

Examine the following RMAN script:Which statement describes the purpose of the script?()

题型:单项选择题

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?()

题型:单项选择题