问题:多选题You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.()AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup
查看答案
问题:多选题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
问题:单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.()ATrueBFalse
问题:单选题Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.A 1,3,6,7B 2,3,6,8C 1,2,3,6,7D 1,2,3,6,,7,8E 2,3,6,5,7
问题:单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?()A using only the RMAN SWITCH command to set the new location for the data fileB placing the database in the MOUNT state for the restore and recovery operations.C using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.D configuring two channels: one for the restore operation and the other for the recovery operation
问题:单选题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
问题:单选题Compressed backups work with which of the following commands?()Acopy as backupBbackup as copyCbackupDcopy
问题:多选题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
问题:单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor
问题:单选题Which command creates an image copy?()Abackup as copyBbackup copyCcopy as backupDcopy back
问题:单选题Which command is used to open the database after an incomplete recovery?()Aalter database openBalter database open repairlogCalter database open resetlogsDalter database open resetlogEalter database resetlogs open
问题:单选题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.
问题:单选题Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()A Configure backup optimizationB Configure the channel to increase MAXOPENFILESC Configure the channel to increase the capacity with the RATE parameterD Configure the channel to adjust the tape buffer size with the BLKSIZE option
问题:单选题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
问题:多选题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
问题:单选题What RMAN command is used to execute a tablespace point-in-time recovery?()ArecoverBduplicateCrestoreDcopyENone of the above
问题:单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ,you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()AThe command succeeds but it retrieves only the disk names.BThe command produces an error because the ASM instance is down.CThe command succeeds but it shows only the status of the ASM instance.DThe command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
问题:多选题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
问题:多选题Which two statements are true about the duplexing of the backups taken by RMAN? ()(Choose two.)AIt's only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
问题:单选题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