当前分类： 1Z0-053
问题：单选题Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace...
查看答案
问题：单选题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 want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory a...
问题：多选题When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics. Which two statements describe the implications of this？（）AIt produces less accurate results of the comparison analysis.BIt automaticall...
问题：单选题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...
问题：单选题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...
问题：单选题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 executed the following command to drop a user： DROP US...
问题：多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance. SQL STARTUP； Which two activities are performed during a suc...
问题：单选题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...
问题：多选题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 setting enables the baselines by default in Oracle Dat...
问题：单选题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...
问题：单选题You want to migrate your database to ASM， so you have done a clean shutdown， made a closed backup of the entire You wa database， noted the location of your control files and online redo log files， and changed your spfile to use OMF. The last step is to...
问题：单选题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...
问题：单选题If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）A TS_OBJECTS_TO_BE_DROPPEDB TS_PTTR_OBJECT_DROPPEDC TS_PITR_OBJECTS_TO_BE_DROPPEDD TS_OBJECTS_DROPPEDE TS_DROPPED_OBJEC...
问题：单选题Evaluate the following command： SQLALTER SYSTEM SET db_securefile = ’IGNORE’； What is the impact of this setting on the usage of SecureFiles？（）A It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOBB It f...
问题：You issue the following command： RMAN>CONFIGURE BACKUP OPT...
问题：单选题ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created？（）A It is a ...
