问题:单选题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
查看答案
问题:单选题You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?()A Run Segment AdvisorB Run the SQL Tuning Advisor (STA)C Run the Automatic Workload Repository (AWR) reportD Run the SQL Access Advisor with a hypothetical workload
问题:单选题When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()AINCLUDING DEPENDENCIESBINCLUDING DEPENDENCIES CASCADECCOMPACTDCASCADEENone 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.
问题:多选题Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully?()AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database
问题:单选题Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload: 1) Preprocess the captured workload. 2) Restart the database in RESTRICTED mode. 3) Set up the Replay Clients. 4) Restore the test database to the point when the capture started. 5) Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.()A1,4,5,3 (2 is not required.)B1,4,3,5 (2 is not required.)C1,2,4,5 (3 is not required.)D2,1,5,3,4 E1,2,4,5,3
问题:多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE
问题:单选题You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do?()ATake the whole disk group offline and wait for the controller card to be installed. Once it’s installed,bring the disk group online again.BChange the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced,reset the parameter to its original value.CYou have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.DIf you are using any setting other than REDUNDANCY EXTERNAL for your disk group,you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.EChange the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
问题:多选题You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.()AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing fe ture
问题:多选题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
问题:单选题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
问题:单选题Which command creates an image copy?()Abackup as copyBbackup copyCcopy as backupDcopy back
问题:多选题Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
问题:多选题You are trying to recover your database. During the recovery process, you receive the following error: ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289: suggestion : /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-00280: change 5033391 for thread 1 is in sequence #11 ORA-00278: log file ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 How do you respond to this error?()ARestore the archived redo log that is missing and attempt recovery again.BRecovery is complete and you can open the database.CRecovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.DRecover the entire database and apply all archived redo logs again.ERecovery is not possible because an archived redo log has been lost.
问题:单选题What RMAN command is used to execute a tablespace point-in-time recovery?()ArecoverBduplicateCrestoreDcopyENone of the above
问题:多选题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 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
问题:单选题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
问题:多选题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