当前分类: 1Z0-053
问题:To set the history retention period for either window loggin...
查看答案
问题:单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()A It cancels all pending disk drops within the disk group.B It restores disks that are being dropped as the result of a DROP DISKG...
问题:You run the following commands: RMAN> list expired backup;...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:多选题For which two situations would you use functionality provided by the Resource Manager?()Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDas...
问题:单选题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...
问题:多选题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...
问题:多选题Which of the following Scheduler elements encourage object reuse?()ASchedule objectsBProgram argumentsCJob classesDJob argumentsEAll of the above...
问题:单选题You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?() a. Mount the database with the startup mount command. b....
问题:单选题You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1; What is the effect of this com...
问题:Which of the following ALTER DISKGROUP commands does not use...
问题:多选题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...
问题:You work with a newly created database. Presently, there is ...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:单选题You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. H...
问题:Your database is running In ARCIIIVELOG mode. One of the dat...
问题:单选题Examine the following PL/SQL block: DECLARE my_plans pls_integer; BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id= ?9twu5t2dn5xd?; END; Which statement is true about the plan being loaded into the SQL plan baseline by the above c...
问题:单选题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 ...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...