单选题 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
多选题 Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table?（）
All the triggers for the table are disabled without changing any of the column names or column types in the table.
The primary key constraint on the EMPLOYEES table is disabled during redefinition.
VPD policies are copied from the original table to the new table during online redefinition.
You must copy the VPD policies manually from the original table to the new table during online redefinition.
多选题 Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）
Allocates memory for RMAN backup and restore operations
Allocates memory for shared and private SQL areas
Contains a cursor area for storing runtime information about cursors
Contains stack space
Contains a hash area performing hash joins of tables
You can detach from a data pump export job and reattach later.
Data pump uses parallel execution server processes to implement parallel import.
Data pump import requires the import file to be in a directory owned by the oracle owner.
The master table is the last object to be exported by the data pump.
You can detach from a data pump import job and reattach later.
多选题 You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
User session data
Private SQL area
Location of the runtime area for DML and DDL Statements
Location of a part of the runtime area for SELECT statements
Flashback Database must be enabled.
Undo retention guarantee for the database must be configured.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Supplemental logging must be enabled.
Recycle bin must be enabled for the database.
Block change tracking must be enabled tor the database.
多选题 Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）
The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
All the components may be moved into SYSAUX tablespace.
All the components may be moved from the SYSAUX tablespace.
单选题 In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）
Increasing the number of DBWN process
Using Automatic Segment Space Management (ASSM)
Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
单选题 In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）
Setting a metric threshold
Implementing Database Resource Manager
Enabling resumable timeout for user sessions
Decreasing the value of the IDLE_TIME resource limit in the default profile
The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
The MRKT tablespace may be dropped if it has no contents.
Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
No more data files can be added to the tablespace.
The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.