网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “多选题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.” 相关考题
考题
多选题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?（）A
One 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.B
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C
One 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.D
One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E
One 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?（）A
Transportable databaseB
Transportable tablespaceC
Data Pump full export/importD
The DBMS_PDB packageE
RMAN
考题
多选题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?（）A
The keep pool is not configured.B
Automatic Workarea Management is not configured.C
Automatic Shared Memory Management is not enabled.D
The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E
All 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?（）A
Data files that belong to only the root containerB
Data files that belong to the root container and all the pluggable databases (PDBs)C
Data files that belong to only the root container and PDB$SEEDD
Data 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?（）A
The CDB must be open.B
The CDB must be in the mount stage.C
The CDB must be in the nomount stage.D
Alt existing PDBs must be closed.
热门标签
最新试卷