You have configured ...

多项选择题X 纠错

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

参考答案：

进入题库练习

单项选择题

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.

点击查看答案进入题库练习

多项选择题

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

点击查看答案进入题库练习

单项选择题

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

点击查看答案进入题库练习

多项选择题

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

点击查看答案进入题库练习

多项选择题

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

点击查看答案进入题库练习

单项选择题

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

点击查看答案进入题库练习

单项选择题

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.

点击查看答案进入题库练习

单项选择题

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.

点击查看答案进入题库练习

单项选择题

In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

A. Export and import the mapping table.
B. Drop and re-create the mapping table.
C. Truncate the mapping table and reinsert the values.
D. Use the ALTER TABLE .. REBUILD command to defragment the mapping table.

点击查看答案进入题库练习

多项选择题

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

A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.

点击查看答案进入题库练习