问题:多选题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
查看答案
问题:多选题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
问题:单选题Examine the following PL/SQL block: DECLARE my_plans pls_integer; BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id=> ?9twu5t2dn5xd?; END; Which statement is true about the plan being loaded into the SQL plan baseline by the above command?()AIt is loaded with the FIXED status.BIt is loaded with the ACCEPTED status.CIt is not loaded with the ENABLED status.DIt is not loaded with the ACCEPTED status.
问题:单选题Which of the following statements best describes Flashback Versions Query?()AFlashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.BFlashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.CFlashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.DFlashback Versions Query is used to view all version changes on rows that existed between two points in time.
问题:单选题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.
问题:多选题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 BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’;To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
问题:单选题What RMAN command is used to execute a tablespace point-in-time recovery?()ArecoverBduplicateCrestoreDcopyENone of the above
问题:单选题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
问题:单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
问题:单选题Which of the following commands will fail?()Areport schemaBreport need backupCreport need backup days 3Dreport userEreport obsolete
问题:多选题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
问题:单选题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
问题:单选题What command would you issue to enable automated backups of control files?()Aalter database controlfile autobackup onBalter system controlfile autobackup onCconfigure controlfile autobackup onDenable controlfile autobackup
问题:单选题Which command creates an image copy?()Abackup as copyBbackup copyCcopy as backupDcopy back
问题:多选题Which operation requires that you create an auxiliary instance manually before executing the operation?()ABackup-based database duplication.BActive database duplication.CTablespace point-in-time recovery.DNo operation requires the creation of an auxiliary instance.
问题:单选题What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?()A 100KB default, 10TB maximumB 256KB default, 1024MB maximumC 10MB default, 126PB maximumD 64KB default, 1EB maximumE 1MB default, 64MB maximum
问题:单选题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
问题:多选题Which files are required for a full recovery of the database in ARCHIVELOG mode?()ADatabase datafilesBOnline redo logsCArchived redo logsDBackup control fileEControl file from a backup
问题:单选题Observe the following warning in an RMAN session of your database instance: WARNING:// new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()AThe CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)BThe VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)CThe ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILUREDThe RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
问题:多选题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