多项选择题You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）

A. backup pieces
B. copies of all the parameter files
C. trace file generated using BACKUP CONTROLFILE TO TRACE
D. control file autobackups

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A. The database writer writes to a trace file， indicating that the temporary file is not found.
B. The database prompts for a database recovery.
C. The database opens normally.
D. The database gets mounted and throws an error indicating that the temporary file requires recovery.

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

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

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

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

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

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

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

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

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

点击查看答案

最新试题

In which case would you use the Flashback Database feature to perform a recovery？（）

题型：单项选择题

Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario， which statement is true？（）

题型：单项选择题

You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）

题型：单项选择题

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

题型：单项选择题

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

题型：多项选择题

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

题型：单项选择题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based recovery？（）

题型：多项选择题

Your database operates in ARCHIVELOG mode and user­managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）

题型：单项选择题

The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

题型：单项选择题

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

题型：单项选择题