单选题Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）AThe optimizer used a dynamic plan for the query.BThe optimizer chose different plans because automatic dynamic sampling was enabled.CThe optimizer used re-optimization cardinality feedback for the query.DThe optimizer chose different plan because extended statistics were created for the columns used.
单选题
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）
A
The optimizer used a dynamic plan for the query.
B
The optimizer chose different plans because automatic dynamic sampling was enabled.
C
The optimizer used re-optimization cardinality feedback for the query.
D
The optimizer chose different plan because extended statistics were created for the columns used.
参考解析
解析：
暂无解析
相关考题：
单选题In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）ACreate the CREATE_TEST procedure with definer’s rights.BGrant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.CCreate the CREATE_TEST procedure with invoker’s rights.DCreate the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
多选题You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
单选题You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）A3，2，1，4B2，3，4，1C4，1，3，2D3，2，4，1
多选题Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）ASystem privileges apply only to the PDB in which they are used.BLocal users cannot use local system privileges on the schema of a common user.CThe granter of system privileges must possess the set container privilege.DCommon users connected to a PDB can exercise privileges across other PDBs.ESystem privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
单选题Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）AIt executes successfully and creates an UNDO tablespace in hr_pdb.BIt falls and reports an error because there can be only one undo tablespace in a cdb.CIt fails and reports an error because the CONTAINER=ALL clause is not specified in the command.DIt fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.EIt executes successfully but neither tablespace nor the data file is created.
多选题You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.
多选题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 want to flash back a test database by five hours.You issue this command:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）AThe database must have multiplexed redo logs for the flashback to succeed.BThe database must be MOUNTED for the flashback to succeed.CThe database must use block change tracking for the flashback to succeed.DThe database must be opened in restricted mode for the flashback to succeed.EThe database must be opened with the RESETLOGS option after the flashback is complete.FThe database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
单选题What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）AIt fails with the ORA-665610 Invalid DDL statement on history-tracked messageBThe rows in the table are truncated without being archived.CThe rows in the table are archived, and then truncated.DThe rows in both the table and the archive are truncated.
单选题To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）AIt results in an error because these parameter settings are invalid.BOne 64G flash cache file will be used.CTwo 64G flash cache files will be used.DTwo 32G flash cache files will be used.