问题：Which statement is true regarding subqueries?（）...
查看答案
问题：多选题Which two statements regarding a SQL profile are true?（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CR...
问题：单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A User processB Server...
问题：单选题What is the implication of this command?（）A The command produces an error because the retention time cannot be reduced. B All historical data is retained but the subsequent flashback data archives are maintained for only three years. C All historical d...
问题：多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed afte...
问题：单选题Which of the following is not a valid linguistic sort element?（）A Accent expansionB Canonical equivalenceC Reverse secondary sortingD Ignorable charactersE Character rearrangement...
问题：多选题Which three tasks can be performed using a duplicate database?（）ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously upd...
问题：单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A statistics recommendationsB SQL Pro...
问题：多选题Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）ABackup retention policyBDefault backup device typeCDefault destinations for backupsDMultiple backup device types for single backupEDef...
问题：单选题If two windows overlap, which window attribute will determine whether one should be chosen over the other?（）A WINDOW_PRIORITYB PRIORITYC PRIORITY_LEVELD WINDOW_PRIORITY_LEVELE OVERLAP_RULE...
问题：单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?（）A None. The database will switch over to the stand-by archive-log destination directory. B A warning message will be written to the alert log of the ...
问题：单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated M...
问题：Which three statements correctly describe the features of th...
问题：多选题Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）AYou can use RMAN stored scriptsBRecovery is faster if data is stored in catalog in addition to the control fileCYou can store b...
问题：单选题View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?（）A because AWR baseline is not enabledB because Current Open Cursors Count is not ...
问题：单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?（）A The Oracle database will perform block checking for the index blocks only B The Oracle database will not perform block checking ...
问题：单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor...
问题：多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for rec...
问题：单选题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the ...
问题：单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）A The shrink operation touches every block in the BOOKING tableB The high-water mark (HWM) for the BOOKING...
