1Z0-031 题目列表
单选题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）AOne runs faster than the otherBA conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERTCA direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERTDThe conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
单选题Which component of the SGA stores parsed SQL statements is used for process sharing?（）ABuffer cache BRedo log buffer CPrivate SQL area DLibrary cache ERow cache
单选题You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）ADEFAULT STORAGE BEXTENT MANAGEMENT CAUTOEXTEND DDATAFILE
单选题Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）AREF BTABLE CCLOB DVARRAY
单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）ASYSTEM BOUTLN CINTERNAL DSYS
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）AOne tablespace has only one datafileBMany tablespaces can share one datafileCOne tablespace can have many datafilesDOne datafile can contain many tablespaces
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）AWhen the instance is started BWhen the database is mounted CWhen the database is opened DWhen the database is closed
单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）ALibrary cache BRow cacheCDictionary cache DLarge area EBuffer cache
单选题Records from the data dictionary information are stored in which of the following database memory areas?（）ALibrary cache BRow cache CSession UGA DBuffer cache
单选题he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）ASYS.SOURCE$ BSYS.AUD$ CDBA_SOURCE DDBA_AUDIT_TRAIL
单选题In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）APassword file BInitialization file CDatafile DControl file ENothing - SYSDBA privileges are not required for these actions
单选题You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）Alog01.log BlogORCL01.log C1_2.logALTER ROLLBACK SEGMENT Dora_1_asdf1234.log
单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）ASize of redo logs BNumber of datafiles CLOG_CHECKPOINT_INTERVAL DLOG_CHECKPOINT_TIMEOUT
单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）ADROP TABLE BALTER TABLE CRESIZE DCOALESCE
单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）AShared pool BControl file CSGA DPGA