当前分类: 1Z0-053
问题:单选题You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?...
查看答案
问题:A PL/SQL procedure queries only those columns of a redefined...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:多选题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...
问题:Which three statements are true about persistent configurati...
问题:单选题Which of the following is not a valid calendaring syntax element?()A FREQB BYHOURC RUNDATED INTERVALE BYMINUTE...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:多选题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 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...
问题:Given two different character sets (A and B), which of the f...
问题:Your database is running In ARCIIIVELOG mode. One of the dat...
问题:You run the following commands: RMAN> list expired backup;...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:单选题Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL ALTER SYSTEM SET DB_8K_CACHE_SIZE=...
问题:单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()A Restore and recover the datafile.B Restore and recover the tablespace.C Restore and recover the database.D Restore and recover the control ...
问题:单选题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 ...
问题:单选题An online tablespace,TEST_TBS,is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason,if the TEST_TBS tablespace does not include autoextensible data files?()A TE...
问题:多选题You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? ()(Choose two)AYou must configure block change tracking fileBYou ...
问题:To set the history retention period for either window loggin...