当前分类: 1Z0-053
问题:单选题Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?()A shutdown restore datafile 4; recover datafile 4; alter database open;B Sql alter database datafile 4 off...
查看答案
问题:When youre performing active database duplication,a backup o...
问题:多选题Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN).()AYou can use RMAN stored scripts.BRecovery is faster if data is stored in catalog in addition to the control file.CYou can ...
问题:You issue the following command: RMAN>CONFIGURE BACKUP OPT...
问题:单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()A Because row IDs may change during the flashback operationB Because the object number changes af...
问题:多选题To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?()AMultiple change tracking files can be created for a database.BThe change tracking file must ...
问题:You executed the following command to drop a user: DROP US...
问题:单选题What is the end result of these commands if they are successful?() RMAN show retention policy; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default Backup database tag=gold_c...
问题:单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA...
问题:单选题What is the correct order of steps to perform an online database backup?() a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfileA a, b, c, d, eB e...
问题:单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compressio...
问题:单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP c...
问题:Which of the following files cannot be backed up by RMAN? ()...
问题:单选题To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()A EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.B EM Database home page, Software and Support, Adviso...
问题:At the request of a user, you issue the following command to...
问题:单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performi...
问题:多选题What information does the report schema command not provide?()ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup...
问题:单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()A The command fails because you cannot confi...
问题:Which statement about Automatic Memory Management with Oracl...
问题:多选题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...