当前分类： 1Z0-031
问题：单选题By default, checkpoints happen at least as often as（）.A Redo log switches. B UPDATE statements are issued against the database. C The SYSTEM tablespace is accessed. D SMON coalesces free space in a tablespase....
查看答案
问题：单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? （）A DBA_TABLESPACES B DBA_TABLES C DBA_SEGMENTS D DBA_FREE_SPACE...
问题：单选题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?（）A DEFAULT STORAGE B EXTENT MANAGEMENT C AUTOEXTEND D DATAFILE...
问题：单选题The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）A ALTER USER DEFAULT ROLE ALLB ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1C ALTER USER DEFAULT ROLE NONED ALTER USER DEFAULT ROLE NONE EX...
问题：单选题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）A One runs faster than the otherB A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct pa...
问题：单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）A Materialized views B Indexes C ...
问题：单选题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?（）A Password file B Initialization file C Datafile D Control file E Nothing - SYSDBA privileges ar...
问题：单选题To allocate another role to a user, which command is most appropriate?（）A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT...
问题：单选题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）A INSERT B SELECT C UPDATE D DELETE...
问题：单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）A ALTER DATABASE B SET TRANSACTION C ALTER R...
问题：单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）A ARCH B SMON C LGWRD SERVER...
问题：单选题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifi...
问题：单选题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?（）A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTER...
问题：单选题During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）A DBW0 B LGWR C ARCH D SMON E PMON...
问题：单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A Nothing happensB Oracle will automatically switch redo logs when detected C Oracle eventually won'...
问题：单选题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?（）A REF B TABLE C CLOB D VARRAY...
问题：单选题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?（）A DROP TABLE B ALTER TABLE C RESIZE D COALESCE...
问题：单选题You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）A V$SESSION B V$SYSSTAT C DBA_SEGMENTS D V$SORT_USAGE...
