多选题Which three statements are true about adaptive SQL plan management?（）AIt automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.BThe optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.CIt adds new, bettor plans automatically as fixed plans to the baseline.DThe non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.EThe non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
多选题
Which three statements are true about adaptive SQL plan management?（）
A
It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
B
The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
C
It adds new, bettor plans automatically as fixed plans to the baseline.
D
The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
E
The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
参考解析
解析：
暂无解析
相关考题：
多选题Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）AThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.BThe C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.CThe C # # A_ADMIN user can perform wallet operations.DThe C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).EThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS
多选题Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）AThread creation must be routed through a dispatcher processBThe local listener may spawn a now process and have that new process create a threadCEach Oracle process runs an SCMN thread.DEach multithreaded Oracle process has an SCMN thread.EThe local listener may pass the request to an existing process which in turn will create a thread.
单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）AOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.BOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.COne audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.DOne audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.EOne audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
多选题Which two statements are true about the Oracle Direct Network File system (DNFS)?（）AIt utilizes the OS file system cache.BA traditional NFS mount is not required when using Direct NFS.COracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.DDirect NFS is available only in UNIX platforms.EDirect NFS can load-balance I/O traffic across multiple network adapters.
单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）ATransportable databaseBTransportable tablespaceCData Pump full export/importDThe DBMS_PDB packageERMAN
多选题You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
单选题A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）AThe keep pool is not configured.BAutomatic Workarea Management is not configured.CAutomatic Shared Memory Management is not enabled.DThe data blocks in the SUBSCRIBE_LOG table are rarely accessed.EAll the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
单选题Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）AData files that belong to only the root containerBData files that belong to the root container and all the pluggable databases (PDBs)CData files that belong to only the root container and PDB$SEEDDData files that belong to the root container and all the PDBs excluding PDB$SEED
单选题In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）AThe CDB must be open.BThe CDB must be in the mount stage.CThe CDB must be in the nomount stage.DAlt existing PDBs must be closed.