问题：多选题Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)AA single SQL statement provided by a userBAn existing SQL Tuning Set (STS)CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources
查看答案
问题：单选题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.
问题：单选题Evaluate the following block of code： BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL （ acl => ’mycompany-com-permissions.xml’， principal => ’ACCT_MGR’， is_grant => TRUE， privilege => ’connect’）； DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL （ acl => ’mycompany-com-permissions.xml’， host => ’*.mycompany.com’）； END； What is the outcome of the above code？（）AIt produces an error because a fully qualified host name needs to be specified.BIt produces an error because the range of ports associated with the hosts has not been specified.CIt creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.DIt creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
问题：单选题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
问题：多选题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
问题：单选题Which command creates an image copy？（）Abackup as copyBbackup copyCcopy as backupDcopy back
问题：多选题In which two aspects does hot patching differ from conventional patching？（）AIt consumes more memory compared with conventional patching.BIt can be installed and uninstalled via OPatch unlike conventional patching.CIt takes more time to install or uninstall compared with conventional patching.DIt does not require down time to apply or remove unlike conventional patching.EIt is not persistent across instance startup and shutdown unlike conventional patching.
问题：多选题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 using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups 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 could consider performing the following steps to accomplish this 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 the RESETLOGS option. 7） Recover the data files. 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A8， 1， 3， 2， 4， 5， 7， 6B1， 8， 3， 4， 2， 5， 7， 6C1， 3， 4， 2， 8， 5， 6， 7D1， 3， 2， 4， 6， 5， 7， 8
问题：单选题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 of the following represents the correct sequence of events for Database Replay？（）ACapture，analyze，preprocess，replayBCapture，preprocess，analyze，replayCCapture，preprocess，replay，analyzeDAnalyze，capture，preprocess，replayENone of the above
问题：单选题Which of the following is a benefit of ASM fast disk resync？（）AFailed disks are taken offline immediately but are not dropped.BDisk data is never lost.CBy default， the failed disk is not dropped from the disk group ever， protecting you from loss of that disk.DThe failed disk is automatically reformatted and then resynchronized to speed up the recovery process.EHot spare disks are automatically configured and added to the disk group.
问题：单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to （）Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically shrink the segments with unused spaceDcheck the alerts generated for the tablespace that is running low on space
问题：单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）ArecoverBduplicateCrestoreDcopyENone of the above
问题：多选题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
问题：多选题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
问题：单选题Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（）Awhen ASM disk goes offlineBwhen one or more ASM files are droppedCwhen some disks in a disk group are offlineDwhen some disks in a failure group for a disk group are rebalancing
问题：多选题Which two statements are true about a job chain? （）(Choose two.)AA job chain can contain a nested chain of jobs.BThe jobs in a job chain cannot have more than one dependency.CA job of the CHAIN type can be run using event-based or time-based schedules.DThe jobs in a job chain can be executed only by using the events generated by the Scheduler
问题：多选题For which of the following can you use Segment Shrink？（）AHeap tablesBTables with function-based indexesCIndexesDPartitions and subpartitionsENone of the above
问题：单选题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
