当前分类: 1Z0-053
问题:多选题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...
查看答案
问题:Which statement about Automatic Memory Management with Oracl...
问题:单选题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...
问题:You issue the following command: RMAN>CONFIGURE BACKUP OPT...
问题:Every resource plan must contain an allocation to which cons...
问题:You executed the following command to drop a user: DROP US...
问题:You create two resource plans, one for data warehouse loadin...
问题:单选题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...
问题:单选题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 per...
问题:多选题Which statements are true regarding system-partitioned tables?()AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique lo...
问题:多选题What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()AORACLE_BASE should be set explicitly.BAn Oracle base should have only one Oracle home created in it.CFlash recovery area and d...
问题:单选题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...
问题:You are using RMAN to backup your ARCHIVELOG mode database. ...
问题:多选题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...
问题:多选题Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)AYou can use RMAN stored scriptsBRecovery is faster if data is stored in catalog in addition to the control fileCYou...
问题:单选题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...
问题:Which statement is true regarding virtual private catalogs?(...
问题:What does it mean if a backup is expired?() ...
问题:单选题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance: LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY’ LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch’ LOG_ARCHIV...
问题:At the request of a user, you issue the following command to...