多项选择题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.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

A. The Oracle database will not perform block checking for any of the data blocks.
B. The Oracle database will perform block checking for the default permanent tablespace only. 
C. The Oracle database will perform block checking for the data blocks in all user tablespaces.
D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

点击查看答案
2.多项选择题You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）

A. log buffer
B. Java pool
C. Large pool
D. Fixed SGA
E. Shared pool
F. Streams pool
G. Keep buffer cache
H. Database buffer cache

点击查看答案
3.单项选择题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.

点击查看答案
4.多项选择题You want to enforce a company’s business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective？ （）

A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE

点击查看答案
5.单项选择题You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）

A. RBAL
B. CKPT
C. SMON
D. PMON
E. MMON
F. CTWR
G. DBWR

点击查看答案
6.多项选择题Which six files are maintained in the Flash Recovery Area？（）

A. control file
B. RMAN files
C. password file
D. parameter file
E. flashback logs
F. data file copies
G. core dump files
H. archived log files
I. RMAN recovery scripts
J. control file autobackpus

点击查看答案
7.多项选择题Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）

A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script

点击查看答案
8.单项选择题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

点击查看答案
9.单项选择题Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）

A. It would result in an error because the template cannot be used along with the disk group.
B. It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C. It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
D. It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

点击查看答案
10.单项选择题A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

A. The database re-created the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries， no other statements are allowed.
D. The database returns and error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.

点击查看答案

最新试题

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）

题型：多项选择题

The loss of the control file forced you to re­create the control file. After re­creating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five­digit number starting with 0. What could be the possible reason？（）

题型：单项选择题

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file.Which method would you use for recovery？（）

题型：单项选择题

View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）

题型：单项选择题

You lost the PRODSTD tablespace， which was read/write. The tablespace was read­only when the last backup was performed. How would you recover the tablespace？（）

题型：单项选择题

You lost the index tablespace in your database. You decided to re­create the index tablespace and the indexes in the tablespace. What methods can you use to re­create the indexes？（）

题型：多项选择题

View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）

题型：单项选择题

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup？（）

题型：多项选择题

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

题型：多项选择题

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

题型：单项选择题