当前分类： 1Z0-032
问题：单选题You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application？（）A RECOVERY_PARALLELISMB FAST_START_MTTR_TARGETC LOG_CHECKPOINT_INTERVALD FAST_START_PARALLEL_ROLLBAC...
查看答案
问题：单选题You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）A SPFILEB archive logC control fileD system tablespace...
问题：单选题Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）A RESTOREB RECOVERC REPORTD BACKUP...
问题：多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）ASWITCH_TIMEBSWITCH_GROUPCMAX...
问题：多选题Which two file types must be included in a closed database backup taken with operating system commands？（）Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file...
问题：单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins...
问题：多选题Which four are true regarding the Workspace Manager in Oracle9i？ （）AAutomatically versions all tables.BAutomatically installed with Oracle9i.CMerges changes with parent rows or discard changes.DProvides mechanism to identify and resolve conflicts.EAllo...
问题：单选题Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）A Listener.oraB Tnsnames.oraC Cman.oraD Sqlnet.ora...
问题：单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A Only the damaged or lost data files.B All of the data files of the database.C Only the data files belonging to the SYSTEM tablespace.D The data files be...
问题：多选题Which three types of information does the control file contain？（）ACurrent log sequence.BRecover tuning parameters.CRedo log names and locations.DData file names and locations.EUndo segment names and locations....
问题：多选题Some data storage and transfer media have fixed-length physical records. When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data： 1119 Smith 1120 Yvonne 1121 ...
问题：单选题Examine this statement： RMAN BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2； What state must the target database be in for you to use this RMAN command？（）A The target database must be open.B The target database must be closed.C The ...
问题：单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）A V$LOGB V$LOFHISTC V$LOGFILED V$LOG_HISTORY...
问题：单选题What is the maximum database block size supported for the Oracle9i database？（）A 16KBB 32KBC 64KBD 128KB...
问题：单选题Which of the following files cannot be cataloged using the CATALOG command？（）A Data filesB Control filesC Archived log filesD Files storing RMAN scripts...
问题：单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A A text copy of the control file.B A binary copy of the control file.C A file containing a SQL statement which will re-create the database.D A fil...
问题：多选题What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）AGlobal indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with...
问题：多选题Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the Database Administrator had few options to deal with stuck recovery. If the co...
问题：单选题You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set...
