问题：多选题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 after the pending transact ion
查看答案
问题：单选题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 setup is required, and the feature is enabled by default.C The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.D The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.E Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
问题：多选题For which two situations would you use functionality provided by the Resource Manager?（）Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources
问题：多选题What are the advantages of variable extent size support for large ASM files?（）AIt improves resync operations when the disk comes online after being taken offline for maintenance purposes.BIt improves performance in the extended cluster configuration by reading from a local copy of an extent.CFewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.DThis feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
问题：单选题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 Maintenance Tasks to use system resources without any restrictionC to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
问题：单选题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
问题：多选题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 backupEDefault section size for backups
问题：单选题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 database, but no adverse impacts to the database will be experienced. C The database will shut down, and will not restart until you correct the out-of-space situation. D The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. E Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
问题：多选题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 CREATE PROFILE command.
问题：单选题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 table is shifted from its original positionC The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
问题：单选题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 Profile recommendationsC Index-related recommendationsD restructuring of SQL recommendations
问题：单选题The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）A 1, 4, 5, 2, 3B 1, 4, 3, 2, 5C 4, 5, 2, 3, 1D 2, 3, 4, 5, 1E 1, 4, 2, 3, 5
问题：单选题Case-insensitive sorts are always accent insensitive by default.（）A TrueB False
问题：多选题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 recoveryDfailures due to loss of connectivity-for example, an unplugged disk cable
问题：单选题Examine the parameter setting in your database: Which statement is correct about the database?（）AAutomatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setBThe instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are setCThe database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are setDAutomatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
问题：单选题What is the default value for the ENABLED attribute of a job or program when it is created? （）A TRUEB FALSEC There is no default. It must be defined at creation time.D PENDINGE NULL
问题：单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A Restore and recover the datafile. B Restore and recover the tablespace. C Restore and recover the database. D Restore and recover the control file. E Restore and recover the parameter file.
问题：单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor SQL
问题：多选题Evaluate the following command and its output: Which two statements correctly interpret the output?（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
问题：单选题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?（）Abecause AWR baseline is not enabledBbecause Current Open Cursors Count is not a basic metricCbecause the STATISTICS_LEVEL parameter is set to BASICDbecause the AWR baseline is a system-defined moving window baseline
