Why would you use the following FLASHBACK TABLE command?()
FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);
A. to undo the changes made to the EMP table since the specified time
B. to restore the EMP table that was wrongly dropped from the database
C. to view the transactions that have modified the EMP table since the specified time
D. to view the changes made to the EMP table for one or more rows since the specified time
您可能感兴趣的试卷
你可能感兴趣的试题
A. the V$LOG view
B. the V$DBFILE view
C. the V$LOGFILE view
D. the V$INSTANCE_RECOVERY view
E. Oracle Enterprise Manager Database Control
A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS
You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’);
This command errorsout displaying the following message:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMIN", line 115
ORA-06512: at SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1
What action would you take to overcome this error?()
A. grant SYSDBA to the user
B. grant SYSOPER to the user
C. grant the RESOURCE role to the user
D. use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E. grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
A. Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
B. You can flash back a dropped table provided row movement has been enabled on the table.
C. If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.
D. When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.
E. When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.
F. If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
A. flash back the database
B. import the temporary tablespace from the last export
C. restore all the data files and temporary files from the last full database backup and perform a recovery
D. not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace
These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT
Name Null? Type
------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()
A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
A. by using the STATUS command of the Listener control utility
B. by using the STATUS L1 command of the Listener control utility
C. by using the SHOW RULES command of the Listener control utility
D. by using the SET PASSWORD command of the Listener control utility
E. by searching for the PASSWORD_LISTENER entry in the listener.ora file
A. data file
B. password file
C. archivelog file
D. temporary file
E. online redo log file
F. the current control file
G. the tnsnames.ora file
H. current server parameter file
A. perform point-in-time recovery
B. perform a Flashback Table operation to restore the table to the state it was in two days ago
C. perform a Flashback Database operation to restore the database to the state it was in two days ago
D. perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
When a backup is performed, what would be the status of this backup after seven days?()
A. The backup would be marked as invalid.
B. The backup would be marked as obsolete.
C. The backup would be removed from the media.
D. The backup would be removed from the RMAN repository.
最新试题
In which case would you use the Flashback Database feature to perform a recovery?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived, and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery: RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario, which statement is true?()
Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database using the RESETLOGS option. Back up the database. Case 2: Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3:Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
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 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 an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’20040805:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()