问题:单选题You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?()A The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.B The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.C The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.D Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
Thursday, May 2, 2024
问题:多选题Which two commands never trigger an implicit rebalancing within the disk group?()AALTER DISKGROUP misc MOUNTBALTER DISKGROUP misc DROP DISK misc2CALTER DISKGROUP misc CHECK ALL NOREPAIRDALTER DISKGROUP misc RESIZE ALL SIZE 1023mEALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’
Saturday, September 17, 2022
问题:单选题You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()AA base catalog existsBThe recovery catalog is emptyCThe base recovery catalog must be droppedDA target database is registered in the recovery catalog
Thursday, September 22, 2022
问题:单选题What RMAN command is used to execute a tablespace point-in-time recovery?()ArecoverBduplicateCrestoreDcopyENone of the above
问题:单选题You run the following commands: RMAN> list expired backup; RMAN> delete expired backup; What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()AThey will be renamed.BNothing will happen to them. The backup set pieces do not exist.CThey will be deleted immediately since they are not in the flash recovery area.DYou will need to manually remove the physical files listed in the output of the commands.EThey will become hidden files and removed 10 days later.
问题:多选题While deploying a new application module,the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?()AThe plan baselines can be evolved over time to produce better performance.BThe newly generated plans are directly placed into the SQL plan baseline without being verified.CThe new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.DThe optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
Thursday, September 15, 2022
问题:单选题You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?()A 8,1,3,2,4,5,7,6B 1,8,3,4,2,5,7,6C 1,3,4,2,8,5,6,7D 1,3,2,4,6,5,7,8
问题:多选题Which two statements are true about encrypting RMAN backup?()AThe transparent encryption of backups uses the encryption walletBThe database uses the same encryption key for every encrypted backupCThe password encryption of backups only uses the password while creating and restoring backupDIf transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups
Tuesday, January 31, 2023
问题:多选题You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task?()ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
Wednesday, December 6, 2023
问题:多选题Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace
问题:单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity?()AASM_POWER_LIMITBASM_DISKSTRINGCASM_DISKGROUPSDINSTANCE_TYPE
Tuesday, April 25, 2023
问题:多选题You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario?()AThe disk is immediately dropped from the disk group.BThe ASM tracks the extents that are modified during the outaCThe ASM migrates the extents from the unavailable disk to the remaining disks.DThe disk automatically goes offline.
Wednesday, August 23, 2023
问题:单选题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance: LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY’ LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’ LOG_ARCHIVE_MIN-SUCCEED_DEST = 2 While the database instance is functional,you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch?()AThe online redo log file Is not allowed to be overwritten.BThe archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.CThe database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.DThe destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Friday, September 16, 2022
问题:多选题To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME
问题:单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()AOracle Net ManagerBListener Control utilityCDatabase Configuration AssistantDOracle Net Configuration Assistant
问题:单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?()ANone. The database will switch over to the stand-by archive-log destination directory.BA warning message will be written to the alert log of the database,but no adverse impacts to the database will be experienced.CThe database will shut down,and will not restart until you correct the out-of-space situation.DThe 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.EOnce Oracle has cycled through all online redo logs,it will stop processing any DML or DDL until the out-of-space condition is corrected.
Friday, November 18, 2022
问题:单选题Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()APut the database in hot backup mode and perform an online backup,including backing up the archived redo logs.BJust back up the database datafiles without shutting down the database.CYou will have to wait until you can shut down the database to perform the backup.DMark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.EOnly back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
问题:单选题When you create a backup control file, where is the resulting file written to?()AThe database user dump destination directoryBThe database diagnostic destination directoryCTo $ORACLE_HOME/rdbmsDTo $ORACLE_HOME/adminETo the directory and filename you specify in the command
Wednesday, September 21, 2022
问题:单选题Which command creates an image copy?()Abackup as copyBbackup copyCcopy as backupDcopy back
Saturday, April 1, 2023
问题:单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()Ato prevent the creation of an excessive number of scheduler job classesBto allow the Automated Maintenance Tasks to use system resources without any restrictionCto allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowDto prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
Wednesday, September 14, 2022