当前分类： 1Z0-053
问题：多选题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...
查看答案
问题：To set the history retention period for either window loggin...
问题：多选题Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）AA range of SCN valuesBA list of SCN valuesCA starting and ending timestampDMinimum and maximum sequence valuesEA list of sequence values...
问题：单选题Which command creates an image copy？（）A backup as copyB backup copyC copy as backupD copy back...
问题：单选题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 （）A identify the segments that you should shrinkB modify the storage parameters for the tablespaceC automat...
问题：单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performi...
问题：单选题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？（）A They will be renamed.B Nothing will hap...
问题：单选题Which of the following are not disabled by default？（）A JobsB ChainsC WindowsD Window groupsE Schedule...
问题：单选题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 o...
问题：You issue the following command： RMAN>CONFIGURE BACKUP OPT...
问题：单选题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？（）A Put the database in hot backup mode and perform an ...
问题：单选题What is the end result of these commands if they are successful？（） RMAN show retention policy； RMAN configuration parameters for database with db_unique_name ORCL are： CONFIGURE RETENTION POLICY TO REDUNDANCY 1； # default Backup database tag=gold_c...
问题：多选题Which three statements are true about windows？（）AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during wi...
问题：单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）A Drop the affected 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 o...
问题：The EMP table exists in your schema. You want to execute the...
问题：What RMAN command is used to execute a tablespace point-in-t...
问题：多选题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）AALTER DATABASE FLASHBACK ONBGRANT SELECT any transaction TO scottCGRANT EXECUT...
问题：多选题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 passwor...
问题：You want to create the Recovery Manager （RMAN） Virtual Priva...
