问题:多选题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
查看答案
问题:单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value
问题:单选题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?()A Differential incremental backupB Different incremental backup C Cumulative backup D Cumulative incremental backup
问题:单选题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
问题:多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
问题:单选题Which of the following is not a valid linguistic sort element?()A Accent expansionB Canonical equivalenceC Reverse secondary sortingD Ignorable charactersE Character rearrangement
问题:多选题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
问题:单选题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
问题:单选题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.
问题:多选题You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? ()AThe ASM-preferred mirror read feature is enabled.BThe ASM supports variable sizes for extents of 1, 8, and 64 allocation units.CThe ASM disk is dropped immediately from a disk group when it becomes unavailable.DThe RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
问题:单选题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 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.
问题:单选题Which statement is true regarding synonyms?()A Synonyms can be created only for a table B Synonyms are used to reference only those tables that are owned by another user C A public synonym and a private synonym can exist with the same name for the same table D The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
问题:多选题You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
问题:单选题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
问题:单选题Which of the following most closely represents an image copy? ()A Unix cp command of a fileB Bit-by-bit copy of a fileC Windows COPY command of a file D All of the above
问题:多选题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
问题:多选题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 backup information of all registered databases in one placeDDatabase backups are automatically deleted when they are older than the specified time period
问题:单选题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
问题:单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?()AThe RMAN backup fails because the TOOLS tablespace is read-onlyBThe RMAN skips the backup of the tablespace because backup optimization is enabledCThe RMAN makes backup because optimization can be enabled only for backups to diskDThe RMAN makes the backup because no backup of the tablespace exists within the seven day window