问题:单选题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...
查看答案
问题:多选题You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()AEvery SQL statement in the STS is co...
问题:单选题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...
问题:单选题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 database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()A Allow the database to continue ru...
问题:多选题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...
问题:单选题Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?()A The database must be running in ARCHIVELOG mode.B No special set...
问题:多选题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...
问题:单选题Which steps are mandatory to enable Direct NFS?() 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS. 3. Replace the ODM library libo...
问题:单选题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...
问题:多选题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...
问题:单选题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...
问题:多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup pie...
问题:多选题Which two statements about workload capture and replay operations are true?()AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enabl...
问题:多选题You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after...
问题:多选题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...
问题:多选题Which three statements are true about windows?()AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during wi...
问题:单选题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 ...
问题:多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?()AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagno...