1z0-043
单选题You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）A the location used for control filesB the location used
题目
the location used for control files
the location used for redo log files
the location set by using $ORACLE_BASE
the location set by using $ORACLE_HOME
the location set by using CORE_DUMP_DEST
the location set by using BACKGROUND_DUMP_DEST
参考答案和解析
相似问题和答案
第1题：
You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）
- A、the location used for control files
- B、the location used for redo log files
- C、the location set by using $ORACLE_BASE
- D、the location set by using $ORACLE_HOME
- E、the location set by using CORE_DUMP_DEST
- F、the location set by using BACKGROUND_DUMP_DEST
正确答案:C
第2题：
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
- A、 Only the Flashback Table
- B、 Both the Flashback Transaction Query and the Flashback Version Query
- C、 Only the Flashback Drop
- D、 Only the Flashback Version
正确答案:B
第3题：
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database
C. Create Flashback Data Archive in the tablespace where the tables are stored.
D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
第4题：
Which two statements are correct regarding the Flashback Versions Query feature？（）
- A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
- B、 You can use this feature to identify the versions of V$ views.
- C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
- D、 You can use this feature for a table only if row movement is enabled for the table.
- E、 You can use this feature to identify the versions of external and fixed tables.
正确答案:A,C
第5题：
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
- A、 You must enable the block change tracking feature.
- B、 You must have enable the flashback feature.
- C、 You must use the OMF in your database.
- D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
正确答案:D
第6题：
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.
正确答案:A,C
第7题：
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.
正确答案:A
第8题：
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database.
C. Create a Flashback Data Archive in the tablespace where the tables are stored.
D. Create a Flashback Data Archive in any suitable tablespace.
E. Enable Flashback Data Archiving for the tables that require tracking
第9题：
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
正确答案:B
第10题：
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 Managed Files （OMF）.
- E、Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.
正确答案:B