问题:多选题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 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...
问题:多选题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...
问题:多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BL...
问题:单选题Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()A only the control file, the current SPFILE, and data filesB onl...
问题:单选题In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?()A VARCHAR2B CHARC NVARCHAR2D CLOBE LONG...
问题:多选题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...
问题:单选题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...
问题:单选题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 regarding the ORDER BY clause? ()AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a colum...
问题:多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming ...
问题:单选题What does the SCN represent?()A The system change number, which is a point in time relative to transactions within a given database. B A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. C The security change numbe...
问题:单选题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...
问题:单选题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...
问题:单选题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 ...
问题:单选题Which statement is true regarding this setting?()A It drops the connection after the specified number of login attempts fail for any user.B It is enforced only if the password profile is enabled for the user. C It locks the user account after the speci...
问题:单选题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...
问题:单选题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...
问题:单选题You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?()A Mount the databaseB Open the database in NORMAL ...
问题:What are the recommendations for Oracle Database 11g install...