问题：Your database is in ARCHIVELOG mode. You have two online red...
查看答案
问题：单选题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...
问题：View the following SQL statements： Transaction T1 INSERT I...
问题：多选题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...
问题：What RMAN command is used to execute a tablespace point-in-t...
问题：To set the history retention period for either window loggin...
问题：Your database is running In ARCIIIVELOG mode. One of the dat...
问题：You want to create the Recovery Manager （RMAN） Virtual Priva...
问题：单选题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 ...
问题：多选题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)AMultiple change tracking files can be created for a database.BThe change tracki...
问题：多选题Which two client requests are captured during database replay Capture?（） (Choose two)AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderED...
问题：单选题Which command creates an image copy？（）A backup as copyB backup copyC copy as backupD copy back...
问题：多选题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...
问题：单选题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 run the following commands： RMAN> list expired backup；...
问题：单选题You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk...
问题：When an ASM instance receives a SHUTDOWN NORMAL command，what...
问题：Your database is running in ARCHIVELOG mode， and the databas...
问题：单选题Which command is used to open the database after an incomplete recovery？（）A alter database openB alter database open repairlogC alter database open resetlogsD alter database open resetlogE alter database resetlogs open...
问题：多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo l...
