A. when a table is dropped and stored in the Recycle Bin
B.when a table is dropped and purged from the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when you are required to view all the versions of a row of an existing table between a specific time period
您可能感兴趣的试卷
你可能感兴趣的试题
A. all the datafiles in the database
B. the datafiles associated with the SYSTEM tablespace
C. the datafiles associated with the DATA1 tablespace
D. all the datafiles in the database except those associated with the DATA1 tablespace
A. MOUNT mode
B. RESTRICTED mode
C. OPEN mode
D. NOMOUNT mode
A. when all the control files are lost
B. when all the members of a redo log group are lost
C. when a table is dropped and purged from the Recycle Bin
D. when a temporary file of the default temporary tablespace is lost
A. when a tablespace is dropped and you have only RMAN-based backup of the database
B. when a table is dropped and stored in the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when a tablespace is dropped and you have only a user-managed full backup of the database
A. Start the database in the MOUNT stage.
B. Back up the control file to trace.
C. Set the DBID
D. Issue the RECOVER DATABASE command.
In which scenario will you issue the following command?()
SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING
BACKUP CONTROLFILE;
A. when all the control files are missing and only a binary backup of the current control file exists
B. when a multiplexed copy of the current control file is missing
C.when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D. when the SPFILE is missing
A. when a table is dropped and stored in the Recycle Bin
B. when all the control files are deleted
C. when a member of a multiplexed redo log group is dropped
D. when you are required to recover a table to its previous state
You are working as a DBA in a company. The datafiles in the database are as follows:
On Monday, you tried to start up the database but failed because all the control files were missing. You recreated the control file using the script you have created by issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. What is the prerequisite for recreating the control file?()
A. All the datafiles should be listed in the CREATE CONTROLFILE statement.
B. The DATA2.dbf and DATA3.dbf datafiles should be listed in the CREATE CONTROLFILE statement.
C. The SYSTEM01.dbf datafile should be listed in the CREATE CONTROLFILE statement.
D. The SYSAUX01.dbf datafile should be listed in the CREATE CONTROLFILE statement.
A. The queries that are currently executing will abort and an error message will be returned to the user.
B. The queries that are currently executing will execute normally but future queries will not executed.
C. Data Manipulation Language (DML) statements cannot be performed on the tables on which the indexes are based.
D. The currently executing and future queries will execute normally, but will be slower
A. by using the Flashback Database feature
B. by using RMAN incomplete recovery
C. by performing a user-managed incomplete recovery
D. by dropping and re-creating the index tablespace
最新试题
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?()
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?()
You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID). In which two sources would you find the DBID? ()
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?()
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
You lost the index tablespace in your database. You decided to recreate the index tablespace and the indexes in the tablespace. What methods can you use to recreate the indexes?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()