问题:单选题You are using an Automatic Storage Management (ASM) instance to manage the database files of your production database. After adding a new disk group to the ASM instance, you execute the following command: ALTER DISKGROUP dg3 REBALANCE POWER 0; What would be the result of this command?()A The rebalancing of the disk group would be stopped.B The rebalancing of the disk group would be completed as fast as possible.C The command would result in an error because the value of POWER cannot be 0.D The rebalancing of the disk group would be completed without affecting the disk group DG3.E The command would result in an error because the disk groups cannot be manually rebalanced.
Thursday, September 15, 2022
问题:单选题Consider the following command to add a new disk group called "tdgroupA" with two failover groups: CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’, ’/devices/A2’, ’/devices/A3’ FAILOVERGROUP control02 DISK ’/devices/B1’, ’/devices/B2’, ’/devices/B3’m The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1". Which task would be accomplished by the command?()AThis command would result in an error because a disk group can have only one failover group.BThis command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.CA new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.DA new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.EA new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA
Friday, March 31, 2023
问题:单选题You are performing a backup of your database across the network. While taking the backup, you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup?()ACONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET;BCONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY;CCONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET;DCONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY;
Thursday, April 25, 2024
问题:多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens?()Alog writerBarchivalCprocess monitorDsystem monitorEchange tracking writerFdatabase writer
Monday, August 8, 2022
问题:多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? ()ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
Thursday, September 22, 2022
问题:多选题You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()Alog bufferBJava poolCLarge poolDFixed SGAEShared poolFStreams poolGKeep buffer cacheHDatabase buffer cache
问题:单选题You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this?()A enable index monitoring and query the DBA_OBJECTS viewB enable index monitoring and query the DBA_INDEXES viewC enable index monitoring and query the V$OBJECT_USAGE viewD enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
Monday, March 6, 2023
问题:单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()A The EVENT parameter was not set.B The SQL_TRACE parameter is set to FALSEC The Enterprise Manager Grid Control is not used.D The STATISTICS_LEVEL parameter is set to BASICE The TIMED_STATISTICS parameter is set to FALSE
问题:多选题In your production database, you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager?()ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
Tuesday, February 20, 2024
问题:多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION
Tuesday, February 21, 2023
问题:多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()ABy using the trace file.BBy using the alert log file.CBy using the database IDDBy using the server parameter file.EBy using the V$CONTROLFILE view.FBy using the autobackup format configuration setting.
问题:多选题Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed? ()Abackups that can be deletedBstored scripts in the recovery catalogCbackup sets and image copies that are obsoleteDonly the most recent backup sets or image copiesEbackups that do not have the AVAILABLE status in RMAN repository
Sunday, September 18, 2022
问题:单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()Acolumn sizesBcolumn data typesCPCTFREEDprojected number of rowEPCTUSED
问题:单选题A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?()Aclear the redo log groupBperform redo log file importCperform an incomplete recoveryDperform a redo log recovery using Recovery Manager (RMAN)Eshut down the database and open the database in the NOARCHIVELOG mode
Friday, May 3, 2024
Sunday, July 16, 2023
问题:单选题You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()AUse the CHANGE_PASSWORD command of the Listener control utility.BUse the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.CUse the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.DManually modify the listener.ora file to include the password for the listener and restart the listener.
Sunday, June 11, 2023
问题:单选题On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.B You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.C You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.D You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
问题:单选题Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *ERROR at line 1:ORA-00942: table or view does not exist Client B needs the dropped table and reports the problem to you.With reference to this scenario, which action should you take?()Aretrieve the table by using the flashback featureBrestore all the data files from last Sunday’s backup and then perform a time-based recoveryCrestore all the data files from last Sunday’s backup and then perform a log sequence recoveryDrestore all the data files from last Sunday’s backup and then perform a cancel-based recoveryErestore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery
Saturday, April 15, 2023
问题:单选题You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()A the location used for control filesB the location used for redo log filesC the location set by using $ORACLE_BASED the location set by using $ORACLE_HOMEE the location set by using CORE_DUMP_DESTF the location set by using BACKGROUND_DUMP_DEST
问题:单选题In which scenario will you perform a cancel-based recovery?()Awhen a tablespace is dropped and you have only RMAN-based backup of the databaseBwhen a table is dropped and stored in the Recycle BinCwhen you are required to recover an existing table to its previous stateDwhen a tablespace is dropped and you have only a user-managed full backup of the database
Friday, September 16, 2022