问题：多选题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 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）？（）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
问题：单选题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 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
问题：多选题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
问题：单选题ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created？（）AIt is a list of remote database links stored in the XML file that are available to the users of the database.BIt is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.CIt is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.DIt is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
问题：单选题You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature？（）AALTER DATABASE ENABLE BLOCK CHANGE TRACKINGBALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
问题：多选题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 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
问题：多选题When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)AIt produces less accurate results of the comparison analysis.BIt automatically calls the SQL Tuning Advisor for recommendations.CIt shortens the time of execution and reduces the impact on system resources.DOnly the changes in the execution plan, and not performance regression, are detected.
问题：多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
问题：多选题What information does the report schema command not provide？（）ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup
问题：单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）ASet the BACKUP_TAPE_IO_SLAVES parameter to FALSEBSet the BACKUP_TAPE_IO_SLAVES parameter to TRUECUse compression when performing tape backupsDConfigure multiple SBT channels
问题：单选题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.
问题：多选题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 NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）ANLS_SORT = BINARYBNLS_SORT = BINARY_AICNLS_SORT = BINARY_CIDNLS_SORT = BINARY_AI_CIEBinary sorts are case insensitive and accent insensitive by default
问题：单选题Which command creates an image copy？（）Abackup as copyBbackup copyCcopy as backupDcopy back
问题：单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）ArecoverBduplicateCrestoreDcopyENone of the above
问题：单选题You executed the following command in Recovery Manager （RMAN）： RMAN> REPORT NEED BACKUP days 3； What is the output of this command？（）Aa list of files that require a backup within three daysBa list of files requiring more than 3 days of archive logs to applyCa list of files that RMAN recommends be backed up only once in every three days，based on low volatilityDa list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
问题：多选题What are the prerequisites for performing flashback transactions? （）(Choose all that apply)ASupplemental log must be enabledBSupplemental log must be enabled for the primary keyCUndo retention guarantee for the database must be configuredD”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user
