A. Only data blocks of the SYSTEM tablespace will be checked.
B. Only data blocks of the SYSAUX tablespace will be checked.
C. A checksum will occur only on the checkpoint.
D. A checksum will occur every time a block is modified.
您可能感兴趣的试卷
你可能感兴趣的试题
A. V$BACKUP_CORRUPTION
B. V$COPY_CORRUPTION
C. V$DATABASE_BLOCK_CORRUPTION
D. RC_BACKUP_CORRUPTION
A. VERSIONS_STARTSCN
B. VERSIONS_STARTTIME
C. VERSIONS_XID
D. VERSIONS_OPERATION
A. The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are already in the Recycle Bin are dropped.
B. The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
C. The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
D. The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped.
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table:
SQL> FLASHBACK TABLE ORDERS TO SCN 771513;
What is the prerequisite to perform Flashback Table?()
A. You must configure OMF in your database.
B. You must enable block change tracking feature in your database.
C. You must enable ROW MOVEMENT feature on the ORDERS table.
D. You must use the Flashback Version Query before using the Flashback Table feature.
A. Flashback Drop
B. Flashback Database
C. Flashback Table
D. Flashback Version Query
You issued the following command:
SQL> DROP TABLE MYTABLE;
SQL> SHOW RECYCLEBIN The following output is returned:
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
------------- ------------------------------ --------------- --------------------
MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE
2005-01-13:20:11:31 You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
A. DROP TABLE MYTABLE PURGE;
B. PURGE RECYCLEBIN;
C. PURGE TABLE MYTABLE;
D. PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;
A. RESETLOGS
B. TO TIMESTAMP
C. TO BEFORE DROP
D. RENAME TO
E. TO SCN
You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace. The following dependent objects have been defined on the dropped table:
Due to limited space, some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement: SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP;
What will be the implication of executing this statement?()
A. Only the WAREHOUSE_DETAILS table is recovered, and none of the dependent objects are recovered.
B. The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints, primary key constraint, and the referential integrity constraints.
C. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.
A. by using Oracle Enterprise Manager
B. by issuing the FLASHBACK TABLE statement at the RMAN prompt
C. by issuing the FLASHBACK TABLE statement at the SQL prompt
D. by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
最新试题
You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this?()
Your database operates in ARCHIVELOG mode. Usermanaged consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord* ERROR at line 1: ORA00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()
In which case would you use the Flashback Database feature to perform a recovery?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes?()
On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use?()
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()