问题:单选题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?()A SYSTEM B OUTLN C INTERNAL D SYS
查看答案
问题:单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()A Library cache B Row cacheC Dictionary cache D Large area E Buffer cache
问题:单选题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
问题:单选题Records from the data dictionary information are stored in which of the following database memory areas?()A Library cache B Row cache C Session UGA D Buffer cache
问题:单选题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 allocate another role to a user, which command is most appropriate?()A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT
问题:单选题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
问题:单选题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 Index-organized tables D Hash clusters
问题:单选题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
问题:单选题The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?()A DISPATCHER B USER C SERVER D LGWR EDBW0
问题:单选题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 path load is a high-speed version of the SQL INSERTC A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERTD The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
问题:单选题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 identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()A DB_CREATE_FILE_DEST B DB_CREATE_ONLINE_LOG_1 C DB_CREATE_ONLINE_LOG_2D The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
问题:单选题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 ROLLBACK SEGMENT D ALTER TABLE
问题:单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A When the instance is started B When the database is mounted C When the database is opened D When the database is closed
问题:单选题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
问题:单选题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
问题:单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? ()A Size of typical transactions B Concurrent transactions C Size of rows in table most frequently changed D Number of anticipated disk sorts
问题:单选题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 EXCEPT ROLE_1
问题:单选题You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()A Immediately following statement execution B After the ALTER TABLE DROP UNUSED COLUMNS command is issued C After the ALTER TABLE SET UNUSED COLUMN command is issued D After the ALTER TABLE MODIFY command is issued