当前分类： 1Z0-053
问题：多选题Which statements are true regarding the Query Result Cache？（）AIt can be set at the system， session， or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store t...
查看答案
问题：Why would you run the delete obsolete command？（） ...
问题：You issue the following command： RMAN>CONFIGURE BACKUP OPT...
问题：单选题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...
问题：多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming...
问题：You executed the following command to drop a user： DROP US...
问题：单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to...
问题：单选题If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）A Recover the online redo log from backup.B Delete and re-create the log file.C Use the alter database clear logfile command to clear the l...
问题：Which statement about Automatic Memory Management with Oracl...
问题：Which three are the valid statements in relation to SQL plan...
问题：单选题Why should you back up a duplicated tablespace after a TSPITR is complete？（）A The tablespace cannot be duplicated or restored to any point in time after the duplication. B The tablespace cannot be duplicated or restored to the point in time before th...
问题：多选题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...
问题：多选题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...
问题：单选题You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this？（）A Cr...
问题：At the request of a user， you issue the following command to...
问题：During the installation of Oracle Database 11g，you do not se...
问题：多选题ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up...
问题：单选题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...
问题：单选题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...
