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

相似题目

• You need to turn on Tracing for a page that is not performing well. You must store the trace information in a database for reporting and trending. Which two actions should you perform?（）

  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.

  查看最佳答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  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.

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

  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.

  查看最佳答案

• 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？ （）

  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.

  查看最佳答案

• You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）

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

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

  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

  查看最佳答案

• View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?（）https://assets.asklib.com/images/image2/2018080214062464323.png

  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

  查看最佳答案

• You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

  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.

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

  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

  查看最佳答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  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.

  查看最佳答案

• You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this 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

  查看最佳答案

• Which two changes and their effect on the system can be tested by using the Database Replay feature？（）

  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

  查看最佳答案

• You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）

  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

  查看最佳答案

• You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape.  Which two statements are true about differential incremental backups（）

  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.

  查看最佳答案

• You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）

  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

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

  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.

  查看最佳答案

• 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？ （）

  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.

  查看最佳答案

• You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

  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

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）

  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

  查看最佳答案

• You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

  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.

  查看最佳答案

• 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 need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）

  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.

  查看最佳答案

• You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

  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.

  查看最佳答案

• Examine the following command that is used to duplicate a database on the same host: https://assets.asklib.com/images/image2/2018080214260721422.jpg Which two statements describe the effect after the database is duplicated successfully? （）

  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

  查看最佳答案