问题:单选题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
Tuesday, July 11, 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 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
Wednesday, April 17, 2024
问题:单选题Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?()A a cumulative level 1 backupB a differential level 1 backupC a full backupD a whole backup
Monday, August 14, 2023
问题:单选题You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()A The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC The database instance starts, but Automatic Memory Management is disabledD The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
问题:单选题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
Tuesday, August 22, 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
Thursday, May 18, 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 after the pending transact ion
Saturday, September 2, 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 backupEDefault section size for backups
Sunday, December 18, 2022
问题:多选题Which two statements are true with respect to the maintenance window? ()AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
问题:单选题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
Tuesday, February 7, 2023
问题:单选题Within a resource-plan definition, what differentiates a top-level plan from a subplan?()A A subplan has the PLAN_SUB parameter value set to SUBB A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC There is no difference in the resource-plan definitionD A subplan always has the CPU_MTH parameter value set to RATIOE The string TOP_LEVEL is appended to the name of top-level resource plans
Thursday, August 17, 2023
问题:多选题Which three are the valid statements in relation to SQL plan baselines?()AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are stored in the SQL plan baseline by default.DThe plan baselines are stored temporarily in the memory as long as the database instance is running.E For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
问题:多选题Which of the following are valid settings for the NLS_COMP parameter?()AASCIIBANSICBINARYDMONOLINGUALEMULTILINGUAL
Thursday, June 8, 2023
问题:单选题Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?()A It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOBC It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOBD It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
Tuesday, January 23, 2024
问题:单选题What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?()A CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA B CONFIGURE DEFAULT DEVICE TYPE TO TAPE C CONFIGURE DEFAULT DEVICE TYPE TO SBT D CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
问题:单选题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.
Wednesday, May 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 recoveryDfailures due to loss of connectivity-for example, an unplugged disk cable
Tuesday, October 24, 2023
问题:单选题What can you determine about the following linguistic sorts based only on their names?() 1. GERMAN 2. FRENCH_M multilingualA 1 is a monolingual sort.B 2 is a monolingual sort.C 1 is case insensitive.D Both 1 and 2 are case insensitive.E Case sensitivity is unknown.
Thursday, April 20, 2023