单项选择题

You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

A. DB_RECOVERY_FILE_DEST only
B. DB_FLASHBACK_RETENTION_TARGET only
C. DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
D. DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
E. DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
F. DB_FLASHBACK_RETENTION_TARGET

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

In which scenario will you use the Flashback Version Query feature？（）

A. when you want to restore a table that has been dropped from the Recycle Bin
B. when you want to identify the transaction ID of the transaction that deleted some important records from a table
C. when you want to recover the schema of a dropped user
D.when you want to restore a dropped tablespace

单项选择题

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

A. V$FLASHBACK_DATABASE_LOG
B. V$FLASHBACK_DATABASE_STAT
C. V$DATABASE
D. V$UNDOSTAT

单项选择题

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

A. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
B. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
C. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
D. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.