问题:To set the history retention period for either window loggin...
查看答案
问题:多选题Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() (Choose two.)Astored scripts in the recovery catalog.Bbackups that can be deleted from disk.Cbackup sets and image copies are obso...
问题:单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the re...
问题:多选题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...
问题:单选题When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()A INCLUDING DEPENDENCIESB INCLUDING DEPENDENCIES CASCADEC COMPACTD CASCADEE None of the above...
问题:Examine the CREATE DISKGROUP command used to create a disk g...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:You are working on a CATDB database that contains an Oracle ...
问题:单选题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...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:单选题Which of the following does the recover command not do?()A Restore archived redo logs.B Apply archived redo logs.C Restore incremental backups.D Apply incremental backups.E Restore datafile images....
问题:单选题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 want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?()A The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.B The ZLIB compression algo...
问题:The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SA...
问题:单选题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 ...
问题:You run the following commands: RMAN> list expired backup;...
问题:Your database is running In ARCIIIVELOG mode. One of the dat...
问题:多选题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...