1Z0-032 题目列表
单选题SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）Adirect-path loadBconventional path load
单选题What is true regarding direct-load insert？（）AA direct-load insert can be invoked by suing the APPEND hint.BInserting using the NOLOGGING option is the default for direct-load inserts.CAll data loaded using direct-load insert is loaded below the high-water mark.DAn object that is modifies using parallel direct-load can be queried within the same Transaction.
单选题Which of the following environment variables specifies a non-default location for the listener configuration file？（）ALSN_ADMINBTNS_ADMINCADMIN_TNSDTSN_ADMIN
单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A’SQL ALTER DATABASE OPEN’；BSQL ALTER DATABASE ’OPEN’；COPEN DATABASE；DDATABASE OPEN
多选题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）ANOCHECKSUMBMAXCORRUPTCCHECK LOGICALDBACKUP INCREMENTALECONFIGURE DEVICE TYPE ... PARALLELISM
多选题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_SESS_POOLDSWITCH_ESTIMATE
单选题Which of the following files cannot be cataloged using the CATALOG command？（）AData filesBControl filesCArchived log filesDFiles storing RMAN scripts
多选题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 Albert 1130 Thomas Which two statements can you use to load the data into the EMP table？（）AABBCCDD
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）ARESTOREBRECOVERCREPORTDBACKUP
多选题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 the UNUSABLE status.BYou do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.CGlobal indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.DGlobal indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.
单选题You can control instance recover performance by setting parameters to define targets for（）AThe size of the redo buffer in SGA. BThe instance that will perform recovery in Real Application Cluster database. CThe number of blocks to be read during instance recovery, or the time needed to complete instance recovery. DThe number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
多选题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
多选题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
多选题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 corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost. Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database. What are three other characteristics of Trial Recovery（）ASpeeds up subsequent media recover actions.BWrites any uncorrupted block to disk during the test recovery.CCan be invoked by adding the TEST option to any RECOVER command.DAllows the Administrator to determine how many blocks are affected by corruption.EMarks blocks as corrupt in memory， allowing the test recover to proceed to completion.