A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP
您可能感兴趣的试卷
你可能感兴趣的试题
A.SYSTEM
B.OUTLN
C.INTERNAL
D.SYS
A.Clone
B.Copy
C.Template
D.Terminal
A.DB_CREATE_FILE_DEST
B.DB_CREATE_ONLINE_LOG_1
C.DB_CREATE_ONLINE_LOG_2
D.The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
A.When the instance is started
B.When the database is mounted
C.When the database is opened
D.When the database is closed
A.Acquire locks on table queried
B.Generate redo for statement
C.Fetch data from disk into memory
D.Write changes to disk
A.ALTER DATABASE
B.SET TRANSACTION
C.ALTER ROLLBACK SEGMENT
D.ALTER TABLE
A.One runs faster than the other
B.A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C.A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D.The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
A.Library cache
B.Row cache
C.Session UGA
D.Buffer cache
A.V_CONTROLFILE_RECORD_SECTION
B.V_CONTROLFILE
C.V$PARAMETER
D.init.ora file
A.Password file
B.Initialization file
C.Datafile
D.Control file
E.Nothing - SYSDBA privileges are not required for these actions
最新试题
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?()
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?()
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?()
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?()
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?()
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?()
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?()
The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?()
A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?()
Records from the data dictionary information are stored in which of the following database memory areas?()