oracle-10g-数据库基础教程课后习题答案择题(中文)

第3章创建数据库
(1)后台进程跟踪文件的位置是（ C ）
A．LOGFILE_DEST B．ORACLE_HOME C．BACKGROUND_DUMP_DEST D．CORE_DUMP_DEST
(2)手动创建数据库的第一步是（ C ）
A．启动实例
B．启动SQL*Plus 以SYSDBA身份连接Oracle
C．查看系统的实例名
[
D．创建参数文件
(3)关于控制文件以下正确的是（ A ）
A．Oracle建议至少二个控制文件存放在二个磁盘分区
B．Oracle建议至少二个控制文件存放在一个磁盘分区
C．Oracle建议存放一个控制文件
D．一个控制文件不足以运行数据库
(4)执行CREATE DATABASE命令之前，应该发出的命令是（ B ）A．STARTUP INSTANCE B．STARTUP NOMOUNT
:
C．STARTUP MOUNT D．以上都不是
(5)创建数据库时，Oracle如何得知需要创建的控制文件信息（ A ）A．从初始化参数文件
B．从 CREATE DATABASE 命令
C．从环境变量
D．从$ORACLE_HOME目录名为 <db_name>.ctl的文件
(6)哪个脚本文件创建数据字典视图（ A ）
A． B． C． D．
(7);
(8)创建数据库时，DATAFILE子句能定义几个数据文件（ C ）
A．一个
B．二个
C．多个；仅一个属于系统表空间
D．多个；都属于系统表空间
(9)谁拥有数据字典（ A ）
A．SYS B．SYSTEM C．DBA D．ORACLE
(10)在CREATE DATABASE命令中，非法子句是（ B ）
&
A．MAXLOGMEMBERS B．MAXLOGGROUPS
C．MAXDATAFILES D．MAXLOGHISTORY
(11)创建一个数据库至少需要几个控制文件（ A ）
A．一个 B．二个 C．三个 D．无
第5章物理存储结构
(1)关于联机重做日志，以下哪两个说法是正确的( BC )
A．所有日志组的所有文件都是同样大小
B．一组中的所有成员文件都是同样大小
！
C．成员文件应置于不同的磁盘
D．回滚段大小决定成员文件大小
(2)DBA使用哪个命令显示当前归档状态（ A ）
A．ARCHIVE LOG LIST B．FROM ARCHIVE LOGS
C．SELECT * FROM V$THREAD D．SELECT * FROM ARCHIVE_LOG_LIST
(3)创建一个数据库需要多少个控制文件（ A ）
A．1 B．2 C．3 D．0
(4)将下句补充完整：控制文件的建议配置是（ C ）
…
A．每数据库一个控制文件 B．每磁盘一个控制文件
C．二个控制文件置于二个磁盘 D．二个控制文件置于一个磁盘
(5)当创建控制文件时，数据库必须处于什么状态（ B ）
A．加载 B．未加载 C．打开 D．受限
(6)哪个数据字典视图显示数据库处于归档状态（ C ）
A. V$INSTANCE B．V$LOG C．V$DATABASE D．V$THREAD
(7)把多路镜像控制文件存于不同磁盘最大的好处是（ B ）
A．数据库性能提高
/
B．防止失败
C．提高归档速度
D．能并发访问提高控制文件的写入速度
(8)哪个文件用于记录数据库的改变，并且用于实例的恢复（ B ）
A．Archive log file B．Redo log file C．Control file D．Alert log file (9)一个实例可以建立几个归档进程（ C ）
A．5 B．4 C．10 D．取决于操作系统
(10)定义归档目标地址时，哪两个参数不能一起使用（ BC ）
!
A．LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST B．LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_1
C．LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_2
D．以上都不是;可以指定所有的归档参数
第6章逻辑存储结构
(1)段的集合称为（ C ）
A．区 B．段 C．表空间 D．数据库
(2)]
(3)当数据库崩溃，何时使用回滚信息（ C ）
A．在崩溃之前
B．恢复完成之后
C．数据库重新打开之后、恢复之前
D．数据库崩溃后回滚信息不被使用
(4)数据字典表和视图存储在（ B ）
A．USERS表空间 B．SYSTEM表空间C．TEMPORARY表空间 D．以上三个中任意
(5)【
(6)PCTFREE与PCTUSED之和不应超过（ A ）
A．100 B．50 C．25 D．10
(7)数据块的哪三个部分合称为块头部（ C ）
A．表目录、行目录和行数据
B．标题、表目录、空闲区
C．表目录、行目录、标题
D．块头部、行数据、行头部
(8)数据库打开时，以下哪个表空间必须联机（ A ）
.
A．SYSTEM B．TEMPORARY C．ROLLBACK D．USERS (9)指定哪个表空间参与排序操作，可以提高排序效率B A．SYSEM B．TEMPORARY C．ROLLBACK D．USERS (10)临时表空间中用于排序的段是何时创建的（ A ）
A．排序操作开始的时候
B．临时表空间创建的时候
C．当排序操作需要内存操过1KB的时候。

D．上述所有选项。

(11)]
(12)以下哪个段是自管理的（ C ）
A．TEMPORARY B．ROLLBACK C．CACHE D．INDEX
(13)如果未定义临时表空间，哪一个会作为默认的临时表空间（ D ）A．ROLLBACK B．USERS C．INDEX D．SYSTEM
(14)回滚段的作用是（ D ）
A．数据的读一致性 B．事务回滚
C．数据库恢复D．以上都是
(15)回滚段存储（ A ）
(
A．事务修改的数据原值
B．事务修改的数据新值
C．事务修改的数据原值和新值
D．以上都不是
第7章数据库实例
(1)Oracle实例是（ D ）
A．Oracle 内存结构B．Oracle I/O 结构
C．Oracle 后台进程D．以上都是
(2)*
(3)SGA区包括（ D ）
A．数据高速缓冲区B．共享池C．重做日志缓冲区D．以上都是(4)最近使用过的SQL语句存储在（ B ）
A．共享池B．数据高速缓冲区C．私有全局区 D．用户全局区(5)以下哪个不是Oracle后台服务进程（ B ）
A．DBWR B．DBCM C．LGWR D．SMON
(6)以下哪个是合法的Oracle后台服务进程（ D ）
A．ARCH B．LGWR C．DBWR D．以上都是
(7)}
(8)将修改过的数据块写入数据文件的进程是（ A ）
A．DBWR B．LGWR C．PMON D．SMON
(9)已提交的事务所做的改变由哪个进程记录（ D ）
A．DBWR B．SMON C．CKPT D．以上都不是(10)Oracle事务提交即（ B ）
A．数据由DBWR进程写入磁盘文件
B．LGWR进程成功写入日志
C．PMON 进程提交
%
D．SMON 进程写数据
(11)回收表空间碎片的进程是___________（ B ）
A．PMON B．SMON C．DBWR D．ARCH
(12)管理用户会话连接的进程是______________（ A ）
A．PMON B．SMON C．SERV D．NET8
第8章数据库启动与关闭
(1)实例启动时数据库所处的状态是（ C ）
A．MOUNT B．OPEN C．NOMOUNT D．None
(2)—
(3)数据库启动时，如果一个数据文件或日志文件不可用，会出现什么结果（ B ）A．Oracle返回警告信息并打开数据库。

B．Oracle 返回警告信息，不打开数据库。

C．Oracle 返回警告信息，并进行数据库恢复。

D．Oracle忽略不可用的文件。

(4)受限会话的系统权限应授予哪些用户（ B ）
A．在客户端与服务器之间通过SQL*NET 或NET8传输数据，需要特别安全保护的用户。

B．执行数据导入、导出的DBA用户。

`
C．上面两类用户都包括。

D．上面几项都不正确。

(5)启动数据库时，如果一个或多个CONTROL_FILES参数指定的文件不存在或不可用，会出
现什么样的结果（ A ）
A．Oracle返回警告信息，但不加载数据库。

B．Oracle返回警告信息，并加载数据库。

C．Oracle忽略不可用的控制文件。

D．Oracle 返回警告信息，并进行数据库恢复。

(6)Bob试图正常关闭数据库，Oracle说实例处于空闲状态，他试图启动数据库，Oracle
说数据库已启动，Bob最好使用什么命令强制关闭数据库（ B ）
、
A．NORMAL B．ABORT C．IMMEDIATE D．NONE
(7)Tom发出启动数据库的命令，实例和数据库经过怎样的过程最终打开（ B ）A．OPEN, NOMOUNT, MOUNT B．NOMOUNT, MOUNT, OPEN
C．NOMOUNT, OPEN, MOUNT D．MOUNT, OPEN, NOMOUNT
(8)Diane是一个新DBA，当数据库服务器正在运行时她发出了关闭数据库的命令，等一会
儿，她发现Oracle正在等待所有用户主动断开，她使用的是哪一个关闭命令（ A ）A．NORMAL B．ABORT C．IMMEDIATE D．NONE
(9)下面哪个脚本文件用于创建数据字典视图B
A．A． B．C． D．
(10)~
(11)为了执行一次完整的数据库介质恢复操作，数据库必须处于那种状态（ B ）
A．处于Mount状态，并且使用RESETLOG方式打开数据库。

B．处于Mount状态，但不打开数据库。

C．处于Mount状态，并且使用ARCHIVELOG方式打开数据库。

D．不能执行完整的数据库介质恢复操作。

(12)数据库启动过程中哪一步读取初始化参数文件（ C ）
A.数据库打开
B.数据库加载
C."
D.实例启动
E.每个阶段
第9章模式对象
（1）用于删除约束的命令是哪一个（ C ）
A．ALTER TABLE MODIFY CONSTRAINT B．DROP CONSTRAINT C．ALTER TABLE DROP CONSTRAINT D．ALTER CONSTRAINT DROP （2）哪个不是ROWID的组成部分（ A ）
A．表空间 B．文件编号 C．对象编号 D．块内行号
{
（3）唯一值约束和主键约束的区别是什么（ D ）
A．唯一值约束建立唯一索引、主码约束建立非唯一索引
B．主码列可以为空、唯一值约束的列不可以为空
C．主码约束可以使用已有的索引、唯一值约束总是创建索引
D．唯一值约束的列可以为空、主码列不可以为空
（4）什么是模式（ B ）
A．数据库对象的物理组织结构
B．数据库对象的逻辑组织结构
/
C．索引模式
D．以上都不是
（5）选择两个正确的答案，当创建一个表时：（ AB ）
A．直接路径加载使用SQL* Loader实用程序不会记录在重做日志文件。

B．直接加载不记录在重做日志文件。

C．表的插入和更新操作不记录在重做日志文件。

D．常规路径加载使用SQL* Loader实用程序不会记录在重做日志文件。

（6）位图索引适合建于怎样的列（ A ）
?
A．索引基数高 B．索引基数低 C．插入率高 D．修改率高（7）选择2个可以被PUBLIC用户组拥有的模式对象。

（ AC ）
A．数据库链接 B．回滚段C．同义词 D．表
（8）ALTER TABLE命令不能用于（ D ）
A．将一个表移动到其他的表空间中
B．修改表的初始分区大小
C．修改表名
D．禁用触发器
;
（9）哪个约束不会自动建立索引（ B ）
A．主码 B．外码 C．唯一
（10）哪个不是建立分区表的方法（ C ）
A．范围 B．列表 C．函数 D．散列
第10章安全管理
(1)创建用户命令中DEFAULT TABLESPACE子句指定_______的位置。

（ A ）
A.用户创建的数据库对象
B.%
C.用户创建的临时对象
D.用户创建的系统对象
E.以上都不是
(2)资源文件中SESSIONS_PER_USER限制了什么（ B ）
A.数据库的并发会话数量
B.每用户会话数量
C.每用户进程数量
D.以上都不是
：
(3)哪个参数限制用户在断开前的最大空闲时间（ A ）
A．IDLE_TIME B．DISCONNECT_TIME C．CONNECT_TIME D．以上都不是
(4)使用ALTER USER命令时，以下哪个子句有错误（ A ）
A．ADD QUOTA 5M B．IDENTIFIED BY usera C．DEFAULT TABLESPACE SYSTEM D．以上都不是
(5)哪个视图包含所有概要文件的资源使用参数（ B ）
、
A．DBA_PROFILE B．DBA_PROFILES
C．DBA_USERS D．DBA_RESOURCES
(6)以下哪个不是系统权限（ A ）
A．SELECT B．UPDATE ANY C．CREATE VIEW D．CREATE SESSION
(7)创建用户的命令中哪个子句限制用户对象在数据库占用的空间（ D ）
A．Size B．NEXT_EXTENT C．MAX_EXTENTS D．QUOTA
(8)对表空间配额的分配限制了哪个操作（ C ）
A．UPDATE B．DELETE C．CREATE D．以上都是
(9)~
(10)概要文件不能限制________。

（ D ）
A．CPU 占用时间
B．最大数据库连接时间
C．最大会话空闲时间
D．读取数据块时间
(11)以下哪个不是角色（ D ）
A．CONNECT B．DBA C．RESOURCE D．CREATE SESSION
第13章SQL语言基础
`
（1）哪个单行函数能够得到字符串的一部分（ B ）
A．INSERT B．SUBSTR C．LPAD D．LEAST
（2）哪个函数接受任何类型的参数，可以多选。

（ BD ）
A．SUBSTR B．NVL C．ROUND D．DECODE E．SIGN
（3）SIGN（ABS(NVL(-23,0))）的返回值是（ A ）
A．1 B．32 C．-1 D．0 E．NULL
（4）哪个函数能返回字符串的首字符，选择2个。

（ AB ）
A．LTRIM B．SUBSTR C．RTRIM D．INSERT E．MOD
%
（5）哪行代码有错误（ C ）
A．SELECT dname,ename
B．FROM emp e,dept d
C．WHERE =
D．ORDER BY 1,2
（6）哪个语句不会建立隐式事务（ E ）
A．INSERT B．UPDATE C．DELETE D．SELECT FOR UPDATE
,
E．以上语句都会建立隐式事务
（7）以下查询语句是哪种连接（ D ）
SELECT dname，ename FROM dept d，emp e WHERE = ORDER BY dname，ename;
1．自连接 B．等值连接 C．外连接 D．不等值连接
（8）使用多表查询时，在哪个子句指定多个表的名字（ D ）
A．HAVING B．GROUP BY C．WHERE D．FROM
（9）这两个操作不允许使用外部联接两个表之间（ AC ）
A．OR B。

AND C。

AND D。

=
!
（10）如果查询表A(有3行数据)和表B（有4行数据），使用select * from a,b，返回的查询结果有多少行（ D ）
A．7 B．1 C．0 D．12
（11）你需要把NEW_CUST表中的新客户信息导入CUST和CUST_SPECIAL表，如果客户信誉度大于10000，需要导入CUST_SPECIAL表，所有新客户信息都要导入CUST表，使用哪种技术可以尽快完成导入（ D ）
A．外部表 B． MERGE 命令
C．INSERT多表插入命令 D．带有 WITH CHECK OPTION子句的INSERT命令
（12）关于以下SQL语句的作用正确的说法是（ B ）
ALTER TABLE SET UNUSED (mgr_id);
A．EMP表上的同义词需要被重建
)
B．MGR_ID列上的约束都被取消
C．任何包含MGR_ID列的视图都必须删除和重建
D．MGR_ID列的索引仍然有效直到执行DROP UNUSED COLUMNS命令
（13）什么情况下在GROUP BY子句中使用ROLLUP（ C ）
A．对每组进行横向统计和不分组统计
B．对GROUP BY指定的列进行分组智能统计
C．对GROUP BY指定的列从右到左分组统计
D．对GROUP BY指定的列进行横向和纵向分组统计
—
（14）关于子查询以下哪两种说法是正确的（ AD ）
A．外层查询返回结果之后，执行内层查询
B．先执行子查询，再执行外层查询
C．对于子查询返回的结果，外层查询只执行一次
D．外层查询返回的每行结果都与内层查询结果进行比较
{
（15）OE和SCOTT是数据库用户，ORDERS表被OE所拥有。

DBA执行以下操作会导致：( B ) CREATE ROLE r1;
GRANT SELECT, INSERT ON TO r1;
GRANT r1 TO scott;
GRANT SELECT ON TO scott;
REVOKE SELECT ON FROM scott;
A．SCOTT能查询；
B．SCOTT不能查询；
C．，
D．REVOKE命令回收了SCOTT和R1的SELECT权限；
E．REVOKE命令会发生错误，因为SELECT权限已被授予R1。

（16）empdet包含外部表empno和ename列。

该命令将关系到empdet表工作( C )外部数据表都是只读的，因此在外部表不能够执行DML操作，也不能创建索引
A. UPDATE empdet SET ename = 'Amit' WHERE empno = 1234;
B. DELETE FROM empdet WHERE ename LIKE 'J%';
C. CREATE VIEW empvu AS SELECT * FROM empdept;
D. CREATE INDEX empdet_idx ON empdet(empno);
*
！
1.View the Exhibit and examine the data in the PROMOTIONS table
…
PROMO BEGIN DATE is stored in the default date format, dd-mon-rr
You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1,2000
Which SQL statement would you use
A. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
B. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
~
WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
C. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE 'P%' AND promo_begin_date <'l-JANUARY-00';
D. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE '%post%' AND promo_begin_date <'l-JAN-00'; Answer: D
2.!
3.Which statements/commands would not cause a transaction to end B
A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
4.Which two statements are not true regarding constraints D
A. A foreign key can contain NULL values
B. A column with the UNIQUE constraint can contain NULL values
…
C. A constraint can be disabled even if the constraint column contains data
constraints can be defined at the column level as well as the table level
5.Which statement are not true regarding the ORDER BY clause B
A. It must be the last clause in the SELECT statement
B. It cannot be used in a SELECT statement containing a HAVING clause
C. You can specify a column name followed by an expression in this clause
D. You can specify a combination of numeric positions and column names in this clause
6.Which statement is true regarding the default behavior of the ORDER BY clause
A
|
A. In a character sort, the values are case-sensitive
B. NULL values are not considered at all by the sort operation
C. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause
D. Numeric values are displayed from the maximum to the minimum value if they have decimal positions
7.Which three statements are not true regarding subqueries C
A. Subqueries can contain GROUP BY and ORDER BY clauses
B. Main query and subquery can get data from different tables
C. Main query and subquery must get data from the same tables
—
D. Multiple columns or expressions can be compared between the main query and subquery
8.Which statement is true regarding synonyms C
A. Synonyms can be created only for a table
B. Synonyms are used to reference only those tables that are owned by another user
C. A public synonym and a private synonym can exist with the same name for the same table
D. The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
9.View the Exhibit and examine the structure of the PROMOTIONS table
}
You need to generate a report of all promos from the PROMOTIONS table based on the
following conditions:
1. The promo name should not begin with 'T' or 'N'
2. The promo should cost more than $20000
3. The promo should have ended after 1st January 2001
Which WHERE clause would give the required result（C ）
A. WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND promo_cost >
20000 AND promo_end_date> 'l-JAN-0l'
B. WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' ) OR promo_cost >
20000 OR promo_end_date> 'l-JAN-0l'
C. WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND promo_cost >
20000 AND promo_end_date> 'l-JAN-0l'
：
D. WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%') AND (promo_cost >
20000 AND promo_end_date> 'l-JAN-0l')
10.You need to create a table with the following column specifications:
1. Employee ID (numeric data type) for each employee
2. Employee Name (character data type) that stores the employee name
3. Hire date, which stores the date of joining the organization for each employee
4. Status (character data type), that contains the value 'ACTIVE' if no data is entered
5. Resume (character large object [CLOB] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table（ D ）。

A. CREATE TABLE EMP_1
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
e_status VARCHAR2(l0) DEFAULT 'ACTIVE',
resume CLOB(200));
B. CREATE TABLE 1_EMP
(emp_id NUMBER(4),
<
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(l0) DEFAULT 'ACTIVE',
resume CLOB);
C. CREATE TABLE EMP_1
(emp_id NUMBER(4), emp_name VARCHAR2(25),
start_date DATE, emp_status VARCHAR2(l0) DEFAULT "ACTIVE",
resume CLOB);
/
D. CREATE TABLE EMP_1
(emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(l0) DEFAULT 'ACTIVE',
resume CLOB);
11.Evaluate the following query:
[
What would be the outcome of the above query（ C ）
A. It produces an error because flower braces have been used
B. It produces an error because the data types are not matching
C. It executes successfully and introduces an 's at the end of each promo_name in the output
D. It executes successfully and displays the literal " {'s start date was } "for each row in the output
12.Which statements are not true regarding indexes（ B ）
A. When a table is dropped, the corresponding indexes are automatically dropped
B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique index
【
C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index
D. For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated
13.Which statement are true about sequences created in a single instance database
（ D ）
A. The numbers generated by a sequence can be used only for one table
B. DELETE <sequencename> would remove a sequence from the database
C. NEXTVAL is used to refer to the last sequence number that has been generated
D. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
14.You issued the following command to drop the PRODUCTS table:（ C ）
,
SQL> DROP TABLE products;
What is not the implication of this command
A. All data along with the table structure is deleted
B. The pending transaction in the session is committed
C. All indexes on the table will remain but they are invalidated
D. All views and synonyms will remain but they are invalidated
15.Which statement are true regarding views （ C ）
A. A simple view in which column aliases have been used cannot be updated
^
B. Rows added through a view are deleted from the table automatically when the view
is dropped
C. The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it
D. The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view
（
16.View the Exhibit and examine the structure of the ORD table
Evaluate the following SQL statements that are executed in a user session in the specified order.
What would be the outcome of the above statements（ A ）
A. All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST ID 101
B. The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified
C. The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified
/
D. All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20
17.Evaluate the following query:（ C ）
SQL> SELECT TRUNC(ROUND,-1),-1)
FROM DUAL;
What would be the outcome
A. 16
B. 100
C. 160
？
D. 200
18.Which statement is true regarding subqueries（ D ）
A. The LIKE operator cannot be used with single-row subqueries
B. The NOT IN operator is equivalent to IS NULL with single-row subqueries
C. =ANY and =ALL operators have the same functionality in multiple-row subqueries
D. The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
19.Which statement are not true regarding the data types in Oracle Database 10g
（ B ）
A. Only one LONG column can be used per table
{
B. A TIMESTAMP data type column stores only time values with fractional seconds
C. The minimum column width that can be specified for a VARCHAR2 data type column is one
D. The value for a CHAR data type column is blank-padded to the maximum defined column width
20.Which is the valid CREATE TABLE statement （ A ）
A. CREATE TABLE emp9$# (emp_no NUMBER(4));
B. CREATE TABLE 9emp$# (emp_no NUMBER(4));
C. CREATE TABLE emp*123 (emp_no NUMBER(4));
D. CREATE TABLE emp9$# (emp_no NUMBER (4), date DATE);
21.…
22.Which two statements are not true regarding the COUNT function （ A ）
A. The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types
B. COUNT (*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
C. COUNT (cust_id) returns the number of rows including rows with duplicate customer IDs value in the CUST_ID column
D. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column
23.Which statement is true regarding the INTERSECT operator（ D ）
A. It ignores NULL values
B. Reversing the order of the intersected tables alters the result
`
C. The names of columns in all SELECT statements must be identical
D. The number of columns and data types must be identical for all SELECT statements in the query
24.The ORDERS table belongs to the user OE. OE has granted the SELECT privilege
on the
ORDERS table to the user HR.
Which statement would create a synonym ORD so that HR can execute the following query successfully（ D ）
SELECT * FROM ord;
A. CREATE SYNONYM ord FOR orders; This command is issued by OE
B. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
·
C. CREATE SYNONYM ord FOR ; This command is issued by the database administrator
D. CREATE PUBLIC SYNONYM ord FOR ; This command is issued by the database administrator
25.When does not a transaction complete（ A ）
A. when a DELETE statement is executed
B. when a ROLLBACK command is executed
C. when a data definition language (DDL) statement is executed
D. when a TRUNCATE statement is executed after the pending transact ion
26.You executed the STARTUP MOUNT command to start your database. For which database
operation do you need to start the database in the MOUNT state （ C ）
（
A. renaming the control files
B. dropping a user in your database
C. enabling or disabling redo log archiving
a tablespace in your database
27.Which statement are true not about the stages of database startup （ B ）
A. Data files and redo log files can be renamed at the MOUNT stage.
B. Control files are required to bring the database to the NOMOUNT stage.
C. Data files and redo log files are made available to users at the OPEN stage. #
D. Data files and online redo log files are checked for consistency while opening the database （一致性检查）
28.Which statement regarding the contents of the V$PARAMETER view is
true （ C ）
A. displays only the list of default values
B. displays only the list of all basic parameters
C. displays the currently in effect parameter values
the list of all the parameter files of a database
29.Because of a power outage, instance failure has occurred. From wh
at point in the redo log does recovery begin and where does it end （ B ）
A. current redo log and inactive redo log
】
B. checkpoint position to end of redo log
C. beginning of redo log to end of redo log
D. all redo logs before the point of last commit
30.Which operation does require undo data （ B ）
A. committing a transaction
B. rolling back a transaction
C. recording a transaction to redo log files
D. rolling forward during instance recovery
31.}
32.Your database is configured in NOARCHIVELOG mode. All the control files have
been lost due to a hard disk failure but the data files are not lost. You have
the closed whole database backup available to you. Which statement are true in this scenario （ D ）
database cannot be recovered.
B. The database can be recovered by restoring the control files from the backup.
C. The database remains opened and you have to shut it down with the ABORT option.
D. The database can be restored till the point of the last closed whole database backup.
33.A user complains that he gets the following error message repeatedly after
executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392: exceeded session limit on CPU usage, you are being logged off .Which action would you take to increase the session limit on CPU usage （ A ）
A) Modify the profile assigned to the user.
B) Modify the roles assigned to the users.
：
C) Modify the object privileges assigned to the user.
D) Modify the system privileges assigned to the users.
34.Which statement are not true about the roles in the Oracle database （ A ）
A. Roles are owned by the SYS user.
B. Roles can be granted to other roles.
C. A role cannot be assigned external authentication.
D. A role can contain both system and object privileges.
35.View the Exhibit to observe the privileges granted to the MGR_ROLE role.
~
The SCOTT user has been granted the CONNECT and RESOURCE roles only.
The database administrator (DBA) grants MGR_ROLE to the SCOTT user by using this command:
SQL> GRANT MGR_ROLE TO SCOTT WITH ADMIN OPTION;
Which statement is true about the SCOTT user after he is granted this role （ C ）
A) The SCOTT user can grant the MGR_ROLE role and the privileges in it to other users.
B) The SCOTT user can grant the privileges in the MGR_ROLE role to other users but not with ADMIN_OPTION.
C) The SCOTT user can grant only the MGR_ROLE role to other users but not the privileges in it.
：
D) The SCOTT user can grant the privileges in the MGR_ROLE role to other users but cannot revoke privileges from them.
36.You executed the following command to export the EMPLOYEES table from a remote
Machine:
$ EXPDP
DUMPFILE=my_dir：
LOGFILE=data_pump_dir：
TABLES=employees
What would be the outcome of this command （ A ）
A) The command would execute successfully and the export dump file would be created in the destination of the directory object MY_DIR.
|
B) The command would execute successfully. But log file would not be created as DATA_PUMP_DIR directory is only accessible to user with SYSDBA privilege.
C) The command fails with an error because DATA_PUMP_DIR directory have higher precedence over the per-file directory.
D) The command fails with an error because no absolute path is specified for log file and dumpfile.
37.You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command （ A ）
A) One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B) One audit record is created for every session when any user successfully drops a table owned by SCOTT.
!
C) One audit record is created for each successful DROP TABLE command executed by any user to drop tables
owned by SCOTT.
D) One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
38.Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM ;
Table created.
~
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp;
Table dropped.
What happens in this scenario （ D ）
A) The table is moved to the SYSAUX tablespace.
B) The table is moved to the SYSTEM tablespace.
C) The table is removed from the database permanently.
D) The table is renamed and remains in the TBSFD tablespace.
.
39.What are the consequences of executing the SHUTDOWN ABORT command （ B ）
A) The database files are synchronized.
B) Uncommitted changes are not rolled back.
C) The database is closed, but the instance is still started.
D) The database undergoes automatic media recovery during the next startup
er SCOTT wants to export his objects using Oracle Data Pump and executes the
following command:
$ expdp scott/tiger
\
directory = EXPORT_DIR
dumpfile =
include = table
include = view: "like '%DEPARTMENTS%'"
content = DATA_ONLY
Which task would the command accomplish（ C ）
A) Oracle Data Pump would export only the data of all of the tables and views.
B) Oracle Data Pump would export all of the table structures along with data and all the views.
-
C) Oracle Data Pump would export the table data and the view definitions where the view name contains a string named DEPARTMENTS.
D) Oracle Data Pump would export the table data and the view definitions with data where view name contains a string named DEPARTMENTS.
41.You executed the following command to start the database:
SQL> STARTUP
ORACLE instance started.
Total System Global Area 8 bytes
Fixed Size 789000 bytes
Variable Size 6 bytes
《
Database Buffers bytes
Redo Buffers 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info Which view would you query at this stage to investigate this missing control file （ B ）
A) V$INSTANCE
B) V$CONTROLFILE
C) DBA_CONTROL_FILES
D) V$DATABASE_PROPERTIES
42.|
43.Which statement is true about the loss of system-critical data files in
ARCHIVELOG mode
A) The data files can be recovered till the last committed transaction.
B) The data files can be recovered without shutting down the database.
C) The data file is taken offline automatically; the database remains open.
D) The data files can be recovered to the time of the most recent backup.
答案：A
er A executes the following command to update the TRANS table)
SQL> UPDATE SET tr_amt=tr_amt+500 WHERE c_code='C005';
—
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the
TRANS table:
SQl> ALTER TABLE trans MODIFY (tr_type VARCHAR2 (3));
What would happen in this scenario （ A ）
A) The transaction for user A is rolled back.
B) The ALTER TABLE command modifies the column successfully.
C) The ALTER TABLE command fails due to the resource being busy.
D) The ALTER TABLE command waits until user A ends the transaction.
45.[
46.You backed up the control file to trace. Which statement is true about the trace
file generated （ B ）
A) The trace file is in binary format.
B) The trace file has a SQL script to re-create the control file.
C) The trace file is a backup set created during the backup of the control file.
D) The trace file contains the instructions to manually re-create the control file.
47.View the Exhibit and analyze the CREATE TABLE statements used to create the ITEMS
and ORDERS tables.
The ITEMS table has 50 rows and ORDERS table has 500 rows. Because you decide to not deal with the item
…。