A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache
您可能感兴趣的试卷
你可能感兴趣的试题
A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces
A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON
A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT
A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running
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
最新试题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）
Records from the data dictionary information are stored in which of the following database memory areas?（）
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?（）
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）
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?（）
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?（）
You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）
Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）