问题:多选题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()AMultiple change tracking files can be created for a database.BThe change tracking file must b...
Tuesday, October 24, 2023
问题:单选题Which statement is true regarding the COALESCE function?()A It can have a maximum of five expressions in a list B It returns the highest NOT NULL value in the list for all rows C It requires that all expressions in the list must be of the same data typ...
Monday, August 14, 2023
问题:单选题The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: What would be the outcome of this command? ()A It executes successfully, and the transition ...
Tuesday, January 23, 2024
问题:单选题As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()A CKPTB SMONC MMOND DBWR...
Thursday, August 17, 2023
问题:单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()A SET_JOB_ARGUMENT_VALUEB SET_JOB_VALUE_ANYDATAC SET_JOB_ANYDATA_VALUED SET_SPECIAL_JOB_VALUEE SET_JOB_ANYTYPE_...
问题:多选题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...
Sunday, December 18, 2022
问题:单选题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 ...
问题:单选题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 ...
Tuesday, August 22, 2023
问题:单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()A backup database plus archivelogB backup database plus archivlog until time ‘10:00‘C backup database plus...
Thursday, July 6, 2023
问题:单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?()A CREATE SYNONYM ord FOR orders; This c...
问题:Which two commands never trigger an implicit rebalancing wit...
Wednesday, September 14, 2022
问题:多选题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...
Wednesday, May 24, 2023
问题:单选题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...
Wednesday, April 17, 2024
问题:单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()A New channels for restore and recovery tasksB New name for the data files of the tablespaceC Auxiliary name fo...
Saturday, August 26, 2023
问题:单选题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...
Tuesday, February 7, 2023
问题:单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding th...
Tuesday, July 11, 2023
问题:多选题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...
Saturday, September 2, 2023
问题:多选题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 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...
Thursday, May 18, 2023
问题:单选题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...