当前分类: 1Z0-053
问题:To set the history retention period for either window loggin...
查看答案
问题:You run the following commands: RMAN> list expired backup;...
问题:单选题How many database instances are used during a database-duplication process?()A OneB TwoC ThreeD FourE Five...
问题:单选题Consider the following command: Backup database plus archivelog delete input; How many backup sets would be created by this command if the following were true:() Control-file a NN uto backups were enabled. NN The size of backup sets was not restric...
问题:单选题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...
问题:单选题You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement,which recommends that you accept the profile. Which statement is true when you accept the sug...
问题:单选题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...
问题:单选题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 are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabl...
问题:多选题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...
问题:单选题What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?()A The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.B The ASM rebalance operation will c...
问题:Your database is running In ARCIIIVELOG mode. One of the dat...
问题:单选题Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?()A The incident metadata is purged when the problem is resolved and the DBA closes the SRB The incident files and dumps...
问题:多选题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 are using a recovery catalog to maintain Recovery Manage...
问题:单选题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...
问题:The()writes the Flashback Database logs in the flash recover...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...