On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）

A . Add a TraceContextEventHandler to the Trace.TraceFinished event to add the trace records into the database. B . Add a system.diagnostics section to the Web.config file. Then add a listener to the new section. C . Use the System.Diagnostics.Trace object to connect to a database. Then insert the trace records. D . In the Page_Load for the page, place the Trace.Write call into a SQL INSERT statement.

A .  Flashback logs are not archived. B .  Flashback logs are maintained in redo log files. C .  Flashback logs are maintained in the Flash Recovery Area. D .  Flashback logs are used to maintain Flashback Database related errors. E .  Flashback logs need to be cleared manually after you disable Flashback Database.

A .  You must ensure that the SALES database is mounted or open. B .  You must restore a backup control file to perform a block media recovery. C .  You must take the tools01.dbf data file offline before you start a block media recovery. D .  You must put the database in NOARCHIVELOG mode to perform a block media recovery. E .  You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

A .  fixed tables B .  heap tables C .  external tables D .  temporary tables E .  Index-Organized Tables （IOTs）

A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

A .  DB_CREATE_FILE_DEST B .  DB_RECOVERY_FILE_DEST C .  DB_RECOVERY_FILE_DEST_SIZE D .  DB_ONLINE_LOG_DEST_

A .  All the related indexes and views are automatically dropped B .  The flashback drop feature can recover only the table structure C .  Only the related indexes are dropped whereas views are invalidated D .  The flashback drop feature can recover both the table structure and its data

A . An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error B . A user belonging to DSS_QUERIES can log in to a new session but the session will be queued C . The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management . D . The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contentio

A . Move tempdb onto a faster disk volume. B . Increase the initial size of tempdb to 1.5 GB C . Increase the size of the data files in the Tracking database. D . Decrease the file growth increment for tempdb to 25 MB E . Use more local temporary tables and fewer global temporary tables in the Tracking database.

A . All the related indexes and views are automatically dropped B . The flashback drop feature can recover only the table structure C . Only the related indexes are dropped whereas views are invalidated D . The flashback drop feature can recover both the table structure and its data

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

A .  multiplexing of the control file B .  adding the redo log member to the database C .  database and operating system upgrades D .  changing the database storage to ASM-managed storage

A . You can perform consistent backups only. B . You can perform a complete database backup without shutting down the database instance. C . You can back up data files only when all data files have the same SCN recorded in the control file. D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command

A . The backup performed on Sundays contains all the blocks that have ever been used in the database. B . The backup performed on Sundays contains all the blocks that have changed since the last level 1backup.  C . The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup. D . The backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.

A . The backup performed on Sundays contains all the blocks that have ever been used in the database. B . The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup. C . The backup performed on each working day contains all the blocks that have changed since the last level 0 backup. D . The backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backu

A . You must ensure that the SALES database is mounted or open. B . You must restore a backup control file to perform a block media recovery. C . You must take the tools01.dbf data file offline before you start a block media recovery. D . You must put the database in NOARCHIVELOG mode to perform a block media recovery. E . You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

A . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

A . All the related indexes and views are automatically dropped B . The flashback drop feature can recover only the table structure C . Only the related indexes are dropped whereas views are invalidated D . The flashback drop feature can recover both the table structure and its data

A .  Restore the lost data file from the backup， and then flash back the database. B .  Restore the data file pertaining to index tablespace， and then recover the tablespace. C .  Restore all the data files， and then perform an incomplete recovery to get the tablespace back. D .  Restore all the data files， and then perform an incomplete recovery using the backup control file. E .  Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

A . Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login. B . Ensure that the stored procedure and the tables are owned by the same database user. C . Ensure that the stored procedure and the tables use the same database schema. D . Configure the multiuser database option on both databases. E . Configure the cross-database ownership chaining option on both databases.

A . You can perform consistent backups only. B . You can perform a complete database backup without shutting down the database instance. C . You can back up data files only when all data files have the same SCN recorded in the control file. D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

A . The data files of the read-only tablespaces in the target database are not duplicated B . The read-only tablespaces in the target database are still defined in new the database C . The read-only tablespaces in the target database are changed to online after duplication D . The data files of the read-only tablespaces in the target database get duplicated E . The read-only tablespaces in the target database are not defined in the new database