6、一个典型的数据库创建完以后，默认有哪几个表空间，各自功能是什么：（3分）
7、一个数据库管理员在建一个新用户及对应的密码后，却发现该新用户根本无法访问数据库中的某些表，最可能的原因有哪些：（3分）
可能是该新用户没有足够的权限访问那些表
8、在进行数据库恢复的时候，需要哪些前提条件，增量备份和完全备份的区别在哪里，各自的优劣是什么：（3分）
9、下列哪些描述是正确的? （1分）
a
An Oracle server is a collection of data consisting of three file types.
b
A user establishes a connection with the database by starting an Oracle instance.
c
A connection is a communication pathway between the Oracle Server and the
Oracle Instance.
d
A session starts when a user is validated by the Oracle server.
10、以下哪些不是SGA的一部分? （1分）
a
Database buffer cache
b
PGA
c
Redo log buffer cache
d
Shared Pool
11、关于共享池，哪两个是正确的? （1分）
aThe shared Pool consists of the Library Cache, Data Dictionary Cache, Shared SQL
area, Java Pool, and Large Pool.
b
The Shared Pool is used to store the most recently executed SQL statements and the
most recently used data.
c
The Shared Pool is used for object that can be shared globally.
d
The Library Cache consist of the Shared SQL and Shared PL/SQL areas.
12、哪一个内存空间是用来缓存数据字典信息的? （1分）
a
Database Buffer Cache
b
PGA
c
Redo log buffer cache
d
Shared Pool
13、在一个数据库实例启动时，以下哪个进程是能用的？（1分）
a
User process
b
Background process
c
Server process
d
System process
14、关于数据字典，哪些描述是正确的？（1分）
a
The data dictionary describes the database and its objects.
b
The data dictionary includes two types of objects: base tables, data dictionary views.
c
The data dictionary is a set of read-only tables.
d
The data dictionary records and verifies information about its associated database.
15、关于数据字典是怎样使用的，哪些句子是对的？（1分）
a
The Oracle server modifies it when a DML statement is executed.
b
It is used to find information about users, schema objects, and storage structures.
c
Used by users and DBAs as a read-only reference.
d
The data dictionary is a necessary ingredient for the database to function.
|
