当前分类： 1Z0-053
问题：单选题The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）A The tape I/O performed is asynchronousB The tape buffer is allocated from the System Global A...
查看答案
问题：多选题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 run the following commands： RMAN> list expired backup；...
问题：To set the history retention period for either window loggin...
问题：单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configu...
问题：Which three are the valid statements in relation to SQL plan...
问题：多选题Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor...
问题：Your database is running In ARCIIIVELOG mode. One of the dat...
问题：单选题In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）A Setting a nonzero value for SGA_TARGETB Configuring Automatic Shared Memory ManagementC Configuring Automatic Memory ManagementD S...
问题：单选题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 type of backup must be performed first with an increme...
问题：单选题Which command creates an image copy？（）A backup as copyB backup copyC copy as backupD copy back...
问题：多选题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 want to create the Recovery Manager （RMAN） Virtual Priva...
问题：单选题Which statement about using RMAN stored scripts is true?（）A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is wri...
问题：单选题Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A An SCN is never used to perform a Flashback Table recovery.B If a significant number of changes have been made to the table， row movement must be enable...
问题：单选题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 RMAN command is used to execute a tablespace point-in-t...
问题：单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three databa...
问题：多选题Which of these recommendations should be followed before capturing a workload？（）AMake sure your replay database has the same structure as the capture database， except without data.BMake sure the replay and capture databases are similar in data content....
