问题:You want to take a complete database backup using RMAN. The...
Wednesday, September 14, 2022
问题:单选题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...
Tuesday, July 11, 2023
问题:单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A It will display a list of files that need incremental backupB It will display a list of files that need backup after...
Thursday, May 18, 2023
问题:单选题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
问题:多选题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
问题:单选题What is the proper command to shut down the database in a consistent manner?()A shutdown abort B shutdown kill C Shutdown nowait D shutdown immediateE shutdown halt...
问题:单选题Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()A NLS_SORT = BINARYB NLS_SORT = BINARY_AIC NLS_SORT = BINARY_CID NLS_SORT = BINARY_AI_CIE Binary sorts are case insensitive and acce...
Thursday, June 8, 2023
问题:多选题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
问题:多选题Which statements are true regarding SecureFile LOBs?()AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encrypt...
Tuesday, October 24, 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...
问题:多选题Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. ...
问题:The Database Resource Manager is automatically enabled in th...
Thursday, September 22, 2022
问题:单选题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...
问题:单选题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
问题:单选题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...
Thursday, April 20, 2023
问题:单选题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 ...
Tuesday, January 23, 2024
问题:多选题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 statement is true regarding the VALIDATE DATABASE command?()A It checks the database for intrablock corruptions only.B It checks for block corruption in the valid backups of the database.C It checks the database for both intrablock and interblock...
Thursday, August 17, 2023
问题:单选题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 activities performed as part of the Automatic SQL Tuning process in the maintenance window?()Agenerating the SQL profileBtesting and accepting the SQL profileCgenerating a list of candidate SQLs for tuningDadding tuned SQL plans into the S...