多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement
多选题
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()
A
Bind Variable Peeking
B
SQL Plan Baselines
C
Adaptive Cursor Sharing
D
Bind variable used in a SQL statement
E
Literals in a SQL statement
参考解析
解析:
暂无解析
相关考题:
多选题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.
多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?()ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
多选题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.
多选题Which three functions are performed by the SQL Tuning Advisor?()ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending the restructuring of SQL queries that are using bad plans
多选题Examine the commands executed to monitor database operations: $ conn sys oracle/oracle@prod as sysdba SQL VAR eid NUMBER SQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’); Which two statements are true?()ADatabase operations will be monitored only when they consume a significant amount of resource.BDatabase operations for all sessions will be monitored.CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.DOnly DML and DDL statements will be monitored for the session.EAll subsequent statements in the session will be treated as one database operation and will be monitored.
多选题Which three statements are true concerning the multitenant architecture?()AEach pluggable database (PDB) has its own set of background processes.BA PDB can have a private temp tablespace.CPDBs can share the sysaux tablespace.DLog switches occur only at the multitenant container database (CDB) level.EDifferent PDBs can have different default block sizes.FPDBs share a common system tablespace.GInstance recovery is always performed at the CDB level.
多选题Identify three benefits of Unified Auditing.()ADecreased use of storage to store audit trail rows in the database.BIt improves overall auditing performance.CIt guarantees zero-loss auditing.DThe audit trail cannot be easily modified because it is read-only.EIt automatically audits Recovery Manager (RMAN) events.
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?()AAll database operations performed by the impdp command are logged.BOnly CREATE INDEX and CREATE TABLE statements generated by the import are logged.COnly CREATE TABLE and ALTER TABLE statements generated by the import are logged.DNone of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.