当前分类： 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...
查看答案
问题：单选题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...
问题：While tuning a SQL statement, the SQL Tuning Advisor finds a...
问题：单选题You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN comma...
问题：单选题Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）A backup databaseB backup database and archivelogsC backup database plus archivelogsD backup database plus arch...
问题：单选题You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back t...
问题：You executed the following command to drop a user： DROP US...
问题：单选题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...
问题：多选题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 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...
问题：You performed the RMAN database backup having a backupset ke...
问题：单选题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...
问题：Which view shows all valid values for the NLS_LANGUAGE， NLS_...
问题：单选题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...
问题：单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQLCREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WH...
问题：单选题On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）A Check the alert log fileB ...
问题：You issue the following command： RMAN>CONFIGURE BACKUP OPT...
问题：You realize that the control file is damaged in your product...
问题：多选题Which two statements are true regarding hot patching？（）AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all pl...
