当前分类： 1Z0-053
问题：You executed the following command to drop a user： DROP US...
查看答案
问题：单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）A Issue the ALTER DISKGROUP ... ADD DISK command.B Issue the ALTER DISKGROUP ... UNDROP DISKS command.C Issue the ALTER DISKGROUP ... DROP DISK CAN...
问题：单选题Which type of database file is spread across all disks in a disk group？（）A All types of files are spread across all disks in the disk group.B DatafilesC Redo log filesD Archived redo log filesE Control files...
问题：单选题Which view provides information on the backup status of the datafiles in the database？（）A V$BACKUPB V$BACKUP_STATUSC V$BACKUP_DATAFILED V$DATAFILE_BACKUPE V$TABLESPCE_BACKUP...
问题：单选题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 about Automatic Memory Management with Oracle 11g is true?（）A You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B Oracle can reallocate...
问题：多选题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...
问题：单选题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...
问题：多选题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 two statements are true about the Automatic Diagnostic Repository （ADR）？（）AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script， which can be used to work with ADRCThe ADR can be used for problem diagno...
问题：单选题What is an obsolete backup set？（）A A backup set that is missing one or more backup set piecesB A backup that has exceeded the retention criteria and is no longer neededC A backup set that does not include archived redo logsD A backup set that can n...
问题：单选题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...
问题：单选题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...
问题：The ORACLE_SID environment variable is set to +ASM. ASMLIB i...
问题：单选题The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of...
问题：You issue the following command： RMAN>CONFIGURE BACKUP OPT...
问题：单选题Which command do you use to generate a report of database incarnations？（）A list incarnation of databaseB report incarnation of databaseC list database incarnationD database incarnation listE report database incarnation...
问题：单选题Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command： ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS； What would be the ...
问题：单选题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent....
问题：单选题At the request of a user， you issue the following command to restore a dropped table： flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop； Later， the user notifies you that the data in the table seems to be very old and out of date. What m...
