-
What two are the prerequisites for enabling Flashback Database?()
A . The database must be in ARCHIVELOG mode
B . The database must be in MOUNT EXCLUSIVE mode
C . The database must be opened in RESTRICTED mode
D . The database instance must be started in the NOMOUNT state
E . The database instance must have the keep buffer pool defined
-
In which scenario do you use the Flashback Database feature?()
A . when a table is dropped and you restore it from the Recycle Bin
B . when a user’s schema is dropped and you recover the user’s schema
C . when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
D . when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duratio
-
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()
A . fixed tables
B . heap tables
C . external tables
D . temporary tables
E . Index-Organized Tables (IOTs)
-
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
A . An upper limit on how far you can flash back the database,depending on the information in the redo logs
B . An upper limit on how far you can flash back the database,depending on the information in the undo tablespace
C . The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
D . The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace,provided that there is enough space
-
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
-
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
A . Enable flashback logging.
B . Start the database in the ARCHIVELOG mode.
C . Issue the ALTER DATABASE FLASHBACK ON; command.
D . Set the FAST_START_MTTR_TARGET initialization parameter.
-
Which two statements regarding the Flashback Table feature are correct?()
A . Flashback Table can be performed on system tables.
B . Flashback Table operation does not shrink the segments.
C . Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D . Flashback Table operation acquires exclusive data manipulation language (DML) locks.
-
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
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?()
A . The Flashback Archive FLA1 is dropped only if it is empty.
B . The tablespace having Flashback Archive is dropped.
C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D . The Flashback Data Archive and historical data are dropped.
-
Which of the following statements best describes Flashback Versions Query?()
A . Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
B . Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
C . Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
D . Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
-
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
A . DBWn
B . RECO
C . RVWR
D . LGWR
-
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()
A . V$DATABASE
B . V$FLASHBACK_DATABASE_STAT
C . V$FLASHBACK_DATABASE_LOG
D . V$RECOVERY_FILE_DEST
-
What are the prerequisites for enabling Flashback Database? ()
A . The database must be started in the MOUNT EXCLUSIVE state.
B . The database must have multiplexed control files.
C . The database must be opened by using a text-based parameter file instead of a server parameter file (SPFILE).
D . The database must be in ARCHIVELOG mode.
E . The database must be in the NOMOUNT state.
F . The database must be opened in RESTRICTED mode.
-
Your Oracle Database 10g is online when you execute the following statement: SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF; What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
A . The database does not record flashback logs for MY_TABLESPACE
B . The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C . All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D . None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
-
View the Exhibit and examine the Flashback Database architecture.
Identify the missing component (shown with a "?") in the Flashback Database architecture.()
https://assets.asklib.com/images/image2/2018080210560571406.jpg
A . DBWn
B . RVWR
C . ARCH
D . RECO
E . TRWR
-
Which two statements regarding the Flashback Table feature are correct?()
A . Flashback Table can be performed on system tables.
B . Flashback Table operation does not shrink the segments.
C . Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D . Flashback Table operation acquires exclusive data manipulation language (DML) locks.
-
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()
A . You must use automatic undo management in the database.
B . You must configure OMF in your database.
C . You must configure ASM for storing the datafiles.
D . You must multiplex the online redo log file.
-
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()
A . Drop the table.
B . Partition the table.
C . Truncate the table.
D . Add a column to the table.
E . Rename a column in the table.
-
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
A . An upper limit on how far you can flash back the database, depending on the information in the redo logs
B . An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
C . The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
D . The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
-
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
E . to recover the EMP table to a point in time in the past by restoring the most recent backu
-
Which three actions are required to configure the Flashback Database?()
A . set Flash Recovery Area
B . enable Flashback logging
C . create FLASHBACK tablespace
D . start the database in the ARCHIVELOG mode
E . start the database in the NOARCHIVELOG mode
-
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?()
A . Flashback logs are not deleted.
B . Flashback logs are deleted automatically.
C . Flashback logs are deleted only if you are using Recovery Manager (RMAN)
D . Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
E . Flashback logs are deleted only if you are using Automatic Storage Management (ASM)
-
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()
A . fixed tables
B . heap tables
C . external tables
D . temporary tables
E . Index-Organized Tables (IOTs)
-
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17133996/81fcc055aa2594a8ac7bbd62b7b620ac.jpg' />
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1