Oracle_开发数据库应用工程师面试题 必备
Oracle_开发数据库英语工程师面试题 必备
////////////////////////////////////////////////////////////
1.()是Oracle维护数据库中其他文件的列
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
、数据库名称和系统改
变号(SCN)的文件。(第二章)
A. 控制文件。B. 参数文件。C. 数据文件。D. 可执行文件。 答案. A
2. Oracle数据库被划分为()的逻辑存储单元，该逻辑存储单元本身
由操作系统磁盘文件和原始分区组成。(第二章)
A. 表空间。B. 联机重做日志文件。C. 归档重做日志文件。D. 回滚段。 答案. A
3.()是包含Oracle数据库中所有数据的数据库对象。(第二章)
and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hangers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2-3 4-6 7-10 weld form no slope mouth weld strengthening height h (mm) 1-1.5 1.5-2 weld width b (mm) 5-6 7-6 has slope mouth weld strengthening height h (mm) 1.5-2 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 2--3 3--4 5--6 weld form weld strengthening height h (mm) 1-1 .5 1.5-2 2-2.5 width b (mm)
A. 视图。B. 索引。C. 存储过程。D. 表。 答案. D
4.()是为了加速对特定表数据的访问而创建的数据段。(第二章)
A. 视图。B. 索引。C. 存储过程。D. 触发器。 答案. B
5.下面是有关date数据类型和timestamp数据类型的描述，请问哪一
种描述是正确的,(第二章)
A. 两者都只能存储日期数据，不能存储时间数据。B. 两者都只能存储
时间数据，不能存储日期数据。
C. date数据类型比timestamp数据类型的存储时间精度高。D. date
数据类型比timestamp数据类型的存储时间精度低。
答案. D
6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple22.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-
6.可以自动执行操作的存储对象是()。 (第二章)
A. 程序包。B. 函数。C. 过程。D. 触发器。 答案. D
7.当Oracle创建数据库时，所有为数据库的数据字典所建立的基本表
和视图都存储在()模式中。
A. SYS。B. SYSTEM。C. USER。D. TEMP。 答案. A
8.()是Oracle数据库对象的别名，可以强化对象的安全性。(第二
章)
A. 触发器。B. 视图。C. 表。D. 同义词。 答案. D
9.()是具有只读类型的表和视图集，存储了数据库的物理和逻辑结构
-6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record32.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110
信息。 (第二章)
A. 表空间。B. 盘区。C. 数据字典。D.
方案
气瓶 现场处置方案 .pdf气瓶 现场处置方案 .doc见习基地管理方案.doc关于群访事件的化解方案建筑工地扬尘治理专项方案下载
。 答案. C
10.()是一组Oracle进程和SGA。(第二章)
A. 实例。B. 数据库。C. 表空间。D. 实体化视图。 答案. A
11.()可以用于存储4Gb字节的数据。(第二章)
A. Clob。B. Blob。C. Text。D. Varchar2。 答案. A
12.NUMBER数据类型存储的最大精度是()。(第二章)
A. 12。B. 38。C. 127。D. 64。 答案. B
-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple42.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5
13.当需要描述一个表table1对象结构时，可以使用();(第三章)
A. DES table1。B. DESC table1。C. DESCR table1。D. DESCRIB table1。 答案. B
14.()是目前各类数据库中最重要、最流行的数据库类型。 (第三章)
A. 网络数据库。B. 图像数据库。C. 关系数据库。D. 对象数据库。 答案. C
15.()是对事物的符号表示，是用于表示事物的未经加工的原始素材。
(第三章)
A. 信息。B. 数据。C. 文本。D. 文件。
答案. B
16.()是一种软件，用于建立、使用和维护数据库。它对数据库进行
统一的管理和控制，以保证数据库的安全性和完整性。(第三章)
-6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record52.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110
A. 关系数据库。B. 数据库管理系统。C. 网络数据库。D. 文件系统。
答案. B
17. Oracle的分区表可以包括多个分区，每个分区都是一个独立的()，
可以存放到不同的表空间中。(第三章)
A. 段。B. 盘区。C. 物化视图。D. 数据文件。
答案. A
18.下面的时间函数，()用于返回当前Oracle会话时区中的日期信息。
(第三章)
A. DATE()。B. current_timestamp()。C. current_date()。D.
DBTIMEZONE。
答案. B
19.下面的函数，()用于返回时区信息。(第三章)
6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple62.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-
A. zone()。B. date()。C. dbtimezone()。D. time()。
答案. C
20. ()可用于返回会话中的日期和时间。(第三章)
A. months_between()。B. next_day()。C. current_date()。D.
localtimestamp()。
答案. D
21.下列()是Oracle superaggregate函数, (第三章)
A. ROLLUP。B. VARIANCE。C. REGR_R2。D. RANK。
答案. A
22.()类型的表通常用来创建可扩展的的应用程序，并且对大型表来
说是有用的，这个表可以被几个并发过程查询或操作。(第三章)
A. 有规则的表(Regular table)。B. 簇表(Clustered table)。
10 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record72.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 1
C. 分区表 (Partitioned table)。D. 索引组织
表 (Index-organized table)。
答案. C
23.为了启动Oracle数据库实例，Oracle必须读取一个()文件，该文
件保存了实例和数据库的配置参数列表。(第三章)
A. 控制文件。B. 数据文件。C. 参数文件。D. 初始化文件。
答案. C
24.在命令行中启动SQL*Plus，使用如下()命令。(第三章)
A. SQLPLUS。B. SQL*PLUS。C. SQL。D. SPLUS。
答案. A
25.当启动Oracle实例，如果不需要装置数据库，可以使用如下()命
令。(第三章)
10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple82.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-
A. STARTUP MOUNT。
B. STARTUP NOMOUNT。
C. START NOMOUNT。
D. START MOUNT。 答案. B
26. Orcacle提供了()，用于支持采用向导方式创建数据库。(第二
章)
A. SQL*Plus。
B. Oracle Net。
C. Oracle Listner。
D. Oracle Database Configuration Assistant。 答案. D
torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record92.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-
27.当在SQL*Plus中需要以DBA连接到Oracle数据库，可以使用如下()方式。(第二章)
A. CONNECT SYS/password SYSDBA。
B. CONNECT SYS/password AS SYSDBA。
C. CONNECT AS SYSDBA SYS/password。
D. CONNECT DBA SYS/password。
答案. B
28.以下数据类型中，()是固定长度的数据类型。 (第二章) A. CHAR。
B. VARCHAR2。
C. LONG。
D. VARCHAR。
3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple102.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-
答案. A
29. 当需要删除表，且该表具有外键约束，需要删除表及其外键约束，可以使用如下()类型的SQL语句。(第三章)
A. DROP TABLE table1。
B. DROP TABLE tablel with foreign key。
C. DROP TABLE tablel1 CASCADE CONSTRAINTS。
D.DROP TABLE table1 all。 答案. C
30. 假设需要给某个客户表Customer添加注释信息:客户表，可以使用如下()方式。(第三章)
A.COMMENT ON TABLE CUSTOMER IS '客户表';
B.COMMENT ON COLUMN
torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record112.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-
CUSTOMER.CUSTOMER_NAME IS '客户表'
C.COMMENT ON COLUMN
CUSTOMER.CUSTOMER_NAME '客户表'
D. COMMENT ON COLUMN
CUSTOMER.CUSTOMER_NAME '客户表'
答案. A
31.假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”，可以使用
()语句。 (第三章)
A.ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGE;
B.ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGE;
C.RENAME TABLE CUSTOMER TO CUSTOMER_CHANGE;
D.RENAME TABLE CUSTOMER CUSTOMER_CHANGE;
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple122.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
答案. B
32. 假设需要在Customer客户表中增加一列LogoutTime，数据类型为
TIMESTAMP(6)，表示最后客户退出登录的时间，可以使用如下()方
式。(第三章)
A.ALTER TABLE CUSTOMER
ADD COLUMN "LOGOUTTIME" TIMESTAMP(6) ; B.UPDATE TABLE CUSTOMER
ADD COLUMN "LOGOUTTIME" TIMESTAMP(6) ; C.UPDATE TABLE CUSTOMER
ADD ( "LOGOUTTIME" TIMESTAMP(6)); D.ALTER TABLE CUSTOMER
ADD ( "LOGOUTTIME" TIMESTAMP(6));
d range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record132.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipme
答案. D
33.假设需要删除Customer表中的LogoutTime列，可以使用如下()方式。(第三章)
A. ALTER TABLE CUSTOMER DROP column LOGOUTTIME ;。 B. UPDATE TABLE DROP column LOGOUTTIME ;。
C. ALTER TABLE CUSTOMER DROP LOGOUTTIME ;。
D. UPDATE TABLE DROP LOGOUTTIME ;。
答案. A
34.假设需要为表customer添加主键约束，主键列为customer_id，可以使用如下()方式。 (第三章)
A.Alter table CUSTOMER
ADD PK_CUSTOMER PRIMARY KEY ("CUSTOMER_ID");
-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple142.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4
B.Alter table CUSTOMER
ADD PRIMARY KEY ("CUSTOMER_ID");
C.Alter table CUSTOMER
ADD CONSTRAINT PK_CUSTOMER ("CUSTOMER_ID"); D.Alter table CUSTOMER
ADD CONSTRAINT PK_CUSTOMER PRIMARY KEY ("CUSTOMER_ID");
答案. D
35.假设需要查看某个表的主键约束信息，可以使用如下()方式。(第
四章)
A.SELECT TABLE_NAME ,CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS FROM DBA_CONSTRAINTS
WHERE TABLE_NAME='CUSTOMER';
c load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record152.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent e
B.SELECT TABLE_NAME ,CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS FROM USER_CONSTRAINTS
WHERE TABLE_NAME='CUSTOMER';
C.SELECT TABLE_NAME ,CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS FROM ALL_CONSTRAINTS
WHERE TABLE_NAME='CUSTOMER';
D. SELECT TABLE_NAME ,CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS FROM SYS_CONSTRAINTS
WHERE TABLE_NAME='CUSTOMER';
答案. B
36.假设需要为CUSTOMER表的Status列设置缺省约束，默认值为“1”，
可以使用如下()方式。(第四章)
event t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple162.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansio
A.UPDATE TABLE CUSTOMER
MODIFY STATUS CHAR
DEFAULT(‘1’);
B.ALTER TABLE CUSTOMER
MODIFY STATUS CHAR
DEFAULT(‘1’);
C.ALTER TABLE CUSTOMER
MODIFY STATUS CHAR(‘1’);
D.ALTER TABLE CUSTOMER
UPDATE STATUS CHAR
DEFAULT(‘1’);
答案. B
d range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record172.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipme
37.假设需要禁用CUSTOMER表上为STATUS列创建的检查约束CK_STATUS，可以使用如下()方式。(第四章)
A.ALTER TABLE CUSTOMER
DISABLE CONSTRAINT CK_STATUS; B.ALTER TABLE CUSTOMER
DISABLE CK_STATUS;
C.UPATE TABLE CUSTOMER
DISABLE CONSTRAINT CK_STATUS; D.ALTER CUSTOMER
DISABLE CONSTRAINT CK_STATUS;
答案. A
38.假设需要删除数据库中的CUSTOMER表，可以使用如下()方式。(第
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple182.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
四章)
A.DROP TABLE CUSTOMER;
B.DROP CUSTOMER;
C.DELETE TABLE CUSTOMER
D.DELETE TOMER
答案. A
39.以下对INSERT语句，说法错误的是()。(第四章)
A.INSERT语句是数据操纵语言中的一条语句。
B. 在使用INSERT语句执行数据插入时，表中的列顺序一定要与提供的
值顺序相同。
C. 在使用INSERT语句执行数据插入时，必须为表中所有列定义数据值。
D. 在插入数据时，应当满足表中定义的检查约束。
nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record192.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2
答案. C
40.假设需要给表AUTHOR表插入的数据中的EMAIL地址更新为gaiguoqiang@sina.com，可以使用如下()方式。(第四章) A.Update AUTHOR
(EMAIL = ‘gaiguoqiang@sina.com’);
B.Update AUTHOR
SET EMAIL = ‘gaiguoqiang@sina.com’;
C.ALTER AUTHOR
SET EMAIL = ‘gaiguoqiang@sina.com’;。
D. MODIFY AUTHOR
EMAIL = ‘gaiguoqiang@sina.com’;
答案. B
ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple202.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2
41.在Oracle中引入的()语句通常被称作“更新插入”，因为使用该
语句可以在同一个步骤中更新(update)并插入(insert)数据行，对于抽
取、转换和载入类型的应用软件可以节省大量宝贵的时间。(第四章)
A. 子查询。B. 合并查询。C. 外连接查询。D. 内连接查询。 答案. B
42.当需要提交某个事务时，可以使用()语句。(第四章)
A. ROLLBACK。B. COMMIT。C. SAVEPOINT。D. SET Transaction。 答案. B
43.()可以让用户在事务处理中建立标记点，从而能够用于支持用户
的事务处理。(第四章)
A. 保存点。B. 事务点。C. 回滚点。D. 提交点。
答案. A
-6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record212.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110
44. Oracle的数据操纵包括()。(第四章)
A. 数据查询操作。B. 数据更新操作。C. 数据删除操作。D. 数据插入操作。 答案. A、B、C、D
45.内连接查询操作列出与连接条件匹配的数据行，它使用比较运算符比较被连接列的列值。内连接分()。(第四章)
A. 等值连接。B. 不等连接。C. 自然连接。D. 交叉连接。
答案. A、B、C
46.在Oracle中，约束可以在DML语句执行之后立即生效，也可以延迟到事务处理提交时才生效。()语句可以让用户在事务处理中设置延迟约束的强制模式。(第四章)
A. set constraint。
-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple222.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1
B. set transaction。
C. take constraint。
D. take transaction。
答案. A
47.假设需要格式化作者表AUTHOR查询的列信息，将AUTHOR_NAME列名字格式化为“作者编号”，AUTHOR_NAME列名字格式化为“作者名称”，AUTHOR_DESC列名字格式化为“作者简介”，可以使用如下()方式。(第四章)
A.FORMAT AUTHOR_ID HEADING ’作者编号’
FORMAT AUTHOR_NAME HEADING ’作者名称’
FORMAT AUTHOR_DESC HEADING ’作者简介’
SELECT AUTHOR_ID, AUTHOR_NAME, AUTHOR_DESC
torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record232.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-
FROM AUTHOR;
B.COLUMN AUTHOR_ID HEADING ’作者编号’
COLUMN AUTHOR_NAME HEADING ’作者名称’
COLUMN AUTHOR_DESC HEADING ’作者简介’
SELECT AUTHOR_ID, AUTHOR_NAME, AUTHOR_DESC
FROM AUTHOR;
C.MODIFY AUTHOR_ID HEADING ’作者编号’
MODIFY AUTHOR_NAME HEADING ’作者名称’
MODIFY AUTHOR_DESC HEADING ’作者简介’
SELECT AUTHOR_ID, AUTHOR_NAME, AUTHOR_DESC
FROM AUTHOR;
D.ALTER AUTHOR_ID HEADING ’作者编号’
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple242.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
ALTER AUTHOR_NAME HEADING ’作者名称’
ALTER AUTHOR_DESC HEADING ’作者简介’
SELECT AUTHOR_ID, AUTHOR_NAME, AUTHOR_DESC
FROM AUTHOR;
答案. B
48.在Oracle中，()是一个基于Web的SQL*Plus工具，能够在网页中执行SQL*Plus命令。(第四章)
A. SQL*Plus。
B. iSQL*Plus
。C. PL*SQL。
D. iPL*SQL。
torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record252.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-
答案. B
49.假设需要从CUSTOMER客户表中检索数据，可以使用如下()语句。(第四章)
A.SELECT * FROM CUSTOMER;
B.SELECT * CUSTOMER;
C.MODIFY * FROM CUSTOMER;
D.UPDATE*FROM USTOMER;
答案. A
50.假设需要从CUSTOMER查询客户表数据，按照CUSTOMR_ID降序排列，可以使用如下()方式。(第四章)
A.SELECT CUSTOMER_ID, CUSTOMER_NAME FROM CUSTOMER
n. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple262.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing sy
ORDER CUSTOMER_ID DESC;
B.SELECT CUSTOMER_ID, CUSTOMER_NAME FROM CUSTOMER
TAKE BY CUSTOMER_ID DESC; C.SELECT CUSTOMER_ID, CUSTOMER_NAME FROM CUSTOMER
ORDER BY CUSTOMER_ID DESC; D.SELECT CUSTOMER_ID, CUSTOMER_NAME FROM CUSTOMER
TAKE CUSTOMER_ID DESC;
答案. C
Oralce数据库应用开发(2)
c load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record272.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent e
1.在Oracle中，可以用一个SELECT语句同时从多个表中取出数据，只
需在SELECT语句的()子句中列出要从中取出数据的表名称即可。(第
四章)
A. ORDER BY。B. FROM。C. GROUP BY。D. JOIN。
答案. B
2. Oracle的时间格式通常是'HH24:MI:SS'形式，它也是通过
nls_date_formate系统参数定义的，要查询Oracle系统的日期格式，
可以使用如下()SQL语句。(第四章)
A.select currenttimestamp from systable; B.select currenttimestamp from dual; C.select systimestamp from systable; D.select systimestamp from dual;
-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple282.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4
答案. D
3. 使用()，可以将某个SQL语句的执行依赖于另一个查询语句的执行结果。(第四章)
A. 内连接查询。B. 子查询。C. 外连接查询。D. 合并查询。
答案. B
4. 下面有关子查询，说法错误的是()。(第四章) A. 子查询必须使用括号括起来，否则无法确定其开始和结束。 B. 在子查询中，可以使用函数。C. 在子查询中，可以使用排序子句order by。
D. 在子查询中，还可以包含子查询，称为嵌套子查询，但是最多嵌套255层。
答案. C
3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record292.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-
5. 分组查询是在查询语句中使用()子句，对查询结果执行分组操作。
(第四章)
A. ORDER BY。B. GROUP BY。C. JOIN。D. COUNT。 答案. B
6.()不带WHERE子句，它返回被连接的两个表所有数据行的笛卡尔积，
返回到结果集合中的数据行数等于第一个表中符合查询条件的数据行
数乘以第二个表中符合查询条件的数据行数。(第四章)
A. 交叉连接。B. 外连接。C. 内连接。D. 自然连接。 答案. A
7.在检索数据过程中，经常需要把检索的数据进行合并，满足实际需要。
为此，需要使用()，将两个字符表达式连接起来(第四章)
A. MERGE。B. 连接运算符(||)。C. JOIN。D. GROUP BY。
6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple302.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-
答案. B
8.层次查询是针对数据之间的层次关系提供的一种查询机制。Oracle
Database 10g提供了层次查询的功能，用户可以利用层次查询，检索层
次结构数据。为了执行层次查询，需要在select语句中添加()。(第
四章)
A. JOIN子句。B. START WITH子句和CONNECT BY子句。
C. GROUP BY子句。D. ORDER BY子句。
答案. B
9.在Oracle中，使用()可以生成一列整数值，这个整数值可以作为
表的主键约束。(第五章)
A. 序列。B. 同义词。C. 索引。D. 触发器。
答案. A
-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record312.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7
10.当需要查询某个序列seq_customer_id的初始值，可以使用如下()
方式。(第五章)
A.SELECT seq_customer_id.NEXTVALUE from sysdate; B.SELECT seq_customer_id.NEXTVALUE from dual; C.SELECT seq_customer_id.NEXTVALUE from DBA.$V_Sequence D.SELECT seq_customer_id.CURRRENTVALUE from dual;
答案. B
11.当需要创建一个序列seq_Customer_id，初始值为7，每次增长1，
序列最大值为20000，可以使用如下()方式。(第五章)
A.CREATE SEQUENCE seq_customer_id
START 7
INCREMENT 1
n. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple322.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing sy
MAXVALUE 20000;
B.CREATE SEQUENCE seq_customer_id START WITH 7
INCREMENT BY 1
MAXVALUE 20000;
C.CREATE SEQUENCE seq_customer_id START WITH 7
INCREMENT BY 1
MAXVALUE WITH 20000;
D.CREATE SEQUENCE seq_customer_id START WITH 7
INCREMENT 1
stati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record332.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowe
MAXVALUE 20000;
答案. B
12.假设向某个Customer表插入数据，使得Customer_ID列的值引用序
列seq_customer_id的下一个值，可以使用()方式。(第五章)
A. INSERT INTO CUSTOMER
(CUSTOMER_ID, CUSTOMER_NAME, "PASSWORD", TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION, PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.CURVAL,'杨善', 'ys',
'ata','yangsan@ata.net.cn','your name?','yangsan'); B.INSERT INTO CUSTOMER
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple342.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
(CUSTOMER_ID, CUSTOMER_NAME, "PASSWORD", TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION, PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.CURRENTVAL,'杨善', 'ys',
'ata','yangsan@ata.net.cn','your name?','yangsan'); C.INSERT INTO CUSTOMER
(CUSTOMER_ID, CUSTOMER_NAME, "PASSWORD", TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION, PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.NEXTVAL,'杨善', 'ys',
'ata','yangsan@ata.net.cn','your name?','yangsan'); D.INSERT INTO CUSTOMER
c load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record352.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent e
(CUSTOMER_ID, CUSTOMER_NAME, "PASSWORD", TRUE_NAME, EMAIL_ADDRESS,PASSWORD_QUESTION, PASSWORD_ANSWER)
VALUES(SEQ_CUSTOMER_ID.NEXTVALALUE,'杨善', 'ys', 'ata','yangsan@ata.net.cn','your name?','yangsan');
答案. C
13.假设数据库中已经创建了一个序列seq_Customer_ID，其增量为1，
需要将其修改为10，可以使用如下()方式。(第五章)
A.ALTER SEQUENCE seq_Customer_ID
INCREMENT BY 2;
B.ALTER SEQUENCE seq_Customer_ID
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple362.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
INCREMENT 2
C.UPDATE SEQUENCE seq_Customer_ID
INCREMENT BY 2
D.UPDATE SEQUENCE seq_Customer_ID
INCREMENT 2
答案. B
14.在数据库中，()使数据库程序无须对整个表进行扫描，就可以在
其中找到所需数据。作为独立的结构，需要存储空间的支持。(第五章)
A. 视图。B. 索引。C. 主键。D. 过程。
答案. B
15.当需要删除某个序列seq_customer_id，可以使用如下()方式。(第
五章)
nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record372.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2
A.DROP SEQ_CUSTOMER_ID;
B.DELETE SEQUENCE SEQ_CUSTOMER_ID;
C.DROP SEQUENCE SEQ_CUSTOMER_ID;
D.DELETE SEQ_CUSTOMER_ID; 答案. C
16.()是一个单元操作，要么全部执行成功，要么全部执行失败。(第
五章)
A. 事务。B. 插入操作。C. 更新操作。D. 删除操作。
答案. A
17.当需要更改视图的时候，可以使用()语句，显式重新编译视图。
(第五章)
A. UPDATE VIEW。B. ALTER VIEW。C. DROP VIEW。D. MODIFY VIEW。
stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple382.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-
答案. B
18. 当需要删除视图时，用户可以使用()语句删除视图。(第五章)
A. DROP VIEW。B. DELETE VIEW。C. MODIFY VIEW。D. ATLER VIEW。
答案. A
19.()是方案对象的别名，可以屏蔽对象的名称和拥有者，以及通过
为分布式数据库的远程对象提供位置透明来提供一个安全层。(第五章)
A. 同义词。B. 视图。C. 触发器。D. 过程。
答案. A
20.当需要重建某个索引ix_customername，可以使用()方式。(第五
章)
A. ALTER INDEX ix_customername REBUILD。
3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record392.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-
B. ALTER INDEX ix_customername BUILD。
C. UPDATE INDEX ix_customername BUILD。
D. UPDATE INDEX ix_customername REBUILD。
答案. A
21.为了监视索引的空间使用效率，可以首先分析该索引的结构，使用()语句，然后查询INDEX_STATE视图。 (第五章) A. SELECT INDEX „ VALIDATE STRUCTURE。
B. ANALYZE INDEX „ VALIDATE STRUCTURE。
C. UPDATE INDEX „ VALIDATE STRUCTURE。
D. REBUILD INDEX „ VALIDATE STRUCTURE。
答案. B
22.()是在分区中使用范围分区分区数据，而在子分区中使用散列分
stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple402.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-
区方法，它适合于历史数据和条块数据，改善范围分区及其数据放置的
管理性，提供了散列分区的并行机制优点。(第五章)
A. 列表分区。B. 组合分区。C. 交叉分区。D. 时间分区。 答案. B
23.使用()命令，可以在屏幕上输出一行数据，这种输出方式，非常
有组于在存储的脚本文件中向用户传递相应的信息。(第六章)
A. help。B. desc。C. prompt。D. spool。 答案. C
24.使用()命令，可以获得有关SQL*Plus的环境设置、创建PL/SQL
代码的错误消息和init.ora参数等。(第六章)
A. help。B. show。C. prompt。D. spool。 答案. B
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record412.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
25. PL/SQL和数据库之间是通过()进行数据交换。(第六章)
A. 函数。B. 过程。C. 常量。D. 变量。 答案. D
26.采用Select语句返回的结果是一个结果集。用户只能浏览该结果集
中的数据，无法对数据进行操作。如果需要逐行对数据进行访问和操作，
可以使用()。(第六章)
A. 视图。B. 过程。C. 函数。D. 游标。 答案. D
27. PL/SQL很容易
检测
工程第三方检测合同工程防雷检测合同植筋拉拔检测方案传感器技术课后答案检测机构通用要求培训
和处理预定义和用户定义的错误条件，称为()。
(第六章)
A. 消息。B. 错误。C. 异常。D. 溢出。 答案. C
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple422.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
28.()是由PL/SQL所提供的系统异常。当PL/SQL应用程序违反了Oracle规则或者系统限制，则会隐含地触发一个内部异常。(第六章) A. 预定义异常。B. 自定义异常。C. 系统错误。D. 内存溢出。
答案. A
29.当定义Oracle错误和异常之间的关联时，需要使用伪过程()。(第六章)
A. EXCEPTION_INIT。B. EXCEPTION_END。
C. EXCEPTION_LAST。D. EXCEPTION。
答案. A
30. 从本质上来看，()就是命名的PL/SQL程序块，它可以被赋予参数，存储在数据库中，然后由另外一个应用或PL/SQL例程调用。(第
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record432.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
六章)
A. 异常。B. 过程。C. 表。D. 视图。 答案. B
31. 定义过程和定义函数的主要区别之一是，定义函数必须使用()返
回数据。(第六章)
A. return子句。B. throw。C. RAISE。D. TRY。 答案. A
32.()是用PL/SQL、Java和C编写的过程，能够在对表或视图执行DML
语句时执行。(第六章)
A. 过程。B. 触发器。C. 函数。D. 程序包。 答案. B
33.()是一种用于执行SQL语句的Java API，可以为多种关系数据库
10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple442.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-
提供统一访问，它由一组用Java语言编写的类和接口组成。(第七章) A. JDBC。B. OCI。C. 程序包。D. 过程。
答案. A
34.()实现了JDBC ResultSet中的所有方法，但与ResultSet不同的是，OracleCachedRowSet中的数据在Connection关闭后仍然有效(第七章)
A. OracleCachedRowSet。B. OracleRowSet。
C. OracleSet。D. CachedRowSet。
答案. A
35.当JDBC程序提取SQL数据到Java中的时候，需要执行数据类型转换，例如，SQL数据类型CHAR将转换为
标准
excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载
java数据类型()处理。(第七章)
10 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record452.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 1
A. CHAR。B. STRING。C. RECORD。D. byte。 答案. B
36.()是Apache的一个开源子项目，是一种实现数据映射的轻量级框
架，减少了应用开发的编码数量。(第八章)
A. iBatis。B. Spring。C. Hibernate。D. JDBC。 答案. A
37.在iBatis框架中，持久化对象之间一对一的关联关系是通过()元
素定义的。(第八章)
A. one-to-one。B. 1-to-1。C. only one。D. one 答案. A
38.在iBatis框架中，SQL Map使用()统一配置不同的属性，包括
DataSource的详细配置信息，SQL Map和其他可选属性，如线程管理等
-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple462.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1
(第八章)
A. XML配置文件。B. 映射文件。C. 持久化对象。D. 初始化文件。 答案. A
39.在IBatis框架中，利用()来定义需要持久化的对象。(第八章)
A. 映射文件。B. 配置文件。C. 初始化文件。D. 参数文件。 答案. A
40.()表示虽然iBATIS向数据库发送了SQL语句，但是，只有在访
问该对象时才会执行该SQL语句。(第八章)
A. 立即加载。B. 提交事务。C. 回滚事务。D. 延迟加载。 答案. D
41.在iBatis框架的配置文件中，使用()属性定义缓存模型，可以很
容易地缓存查询返回的数据集。 (第八章)
10 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record472.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 1
A. LRU。B. oscache。C. Cache Model。D. FIFO。
答案. C
42.iBatis框架中提供了一套独有的()来封装持久层的操作，同时支
持事务处理。(第八章)
A. 持久化对象。B. DAO框架。C. 映射文件。D. 配置文件。 答案. B
43.iBATIS提供了自动化的JDBC事务管理机制。对于传统JDBC 连接而
言，获得Connection实例之后，需要调用()设定事务提交模式。 (第
九章)
A. Connection.SetAutoCommit。B. Connection.SetCommit。
C. Connection.SetROLLBACK。D. Connection.SetAutoROLLBACK。 答案. A
6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple482.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-
44.在Hibernate框架中，在执行可编程配置方式时，可以使用()的实例，将整个应用的Java类型映射为SQL数据库的完整集合。(第九章)
A. org.hibernate.SessionFactory。
B. org.hibernate.cfg.Configuration。
C. org.hibernate.HibernateUtil。
D. org.hibernate.Util。
答案. B
45.在Hibernate映射文件中，类映射配置是通过()标签来完成的。(第九章)
A. 。B.
。C. 。D. 。
答案. B
3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record492.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-
46.()是Hibernate为应用程序操纵数据库提供了的核心接口，支持
对数据库执行保存、更新、删除操作。(第九章)
A. Configuration接口。B. Session接口。
C. HibernateException接口。D. SessionFactory接口。
答案. B
47.在Hibernate中，Session类提供了()接口，提供了参数绑定、结
果集处理以及运行实际查询的方法。(第九章)
A. createSQLQuery()。B. save()。C. update()。D. delete()。
答案. A
48.Hibernate的二级缓存是由()维护的。 (第九章)
A. SessionFactory实例。B. Session实例。
C. Query接口实例。D. Configuration实例。
-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple502.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1
答案. A
49.Oracle创建()来处理连接到实例的用户进程的请求。(第十章)
A. 服务器进程。B. SGA。C. 应用程序代码。D. 网络服务进程。 答案. A
50.初始化参数()指定了实例启动时希望创建的共享服务器进程的数
目。(第十章)
A. SHARED_SERVICES。B.DISPATCHERS。C. HOST。D. NET_SERVICES。 答案. A
Oralce数据库应用开发(3)
1.()进程可以将数据库高速缓冲区中的修改的块写到数据文件中。(第
十章)
A. LGWR。B. DBWn。C. CKPT。D. SMON。
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record512.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
答案. B
2.当失败的实例再次启动时，()可以执行紧急恢复操作。(第十章)
A. LGWR。B. DBWn。C. CKPT。D. SMON。 答案. D
3.()可以用于备份联机重做日志文件，以便在文件中充满日志或者发
生日志切换时存储档案。(第十章)
A. ARCn。B. RECO。C. SMON。D. PMON。 答案. A
4.当需要查询当前活动进程的信息时，可以使用()视图。(第十章)
A. V$PROCESS。B. V$SESS_IO。C. V$SESSION_WAIT。D. V$LATCH。 答案. A
5.表空间和数据文件在物理存储上是()的关系(第十章)
6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple522.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-
A. 一对多。B. 多对一。C. 一对一。D. 多对多。 答案. A
6.()是ORACLE最基本的逻辑存储单位。(第十章)
A. 盘区。B. 段。C. 表空间。D. 数据块。 答案. D
7.()是Oracle存储区中被单个用户进程所使用的内存区域，是用户
进程私有的，不能共享。(第十章)
A. 系统全局区。B. 程序全局区。C. Java池。D. SQL共享池。 答案. B
8.()是由表和视图组成的、存储有关数据库结构信息的一些数据库对
象，描述了实际数据是如何组织的。对它们可以像处理其他数据库表或
视图一样进行查询，但不能进行任何修改。(第十章)
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record532.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
A. 数据字典。B. 数据文件。C. 控制文件。D. 表空间。 答案. A
9. 在Oracle数据字典视图中，()视图存储了数据库中所有对象的信
息。(第十章)
A. dba_*。B. user_*。C. all_*。D. sys_*。
答案. A
10.()包含了一些潜在的由系统管理员如SYS维护的表和视图，由于
当数据库运行的时候它们会不断进行更新。(第十章)
A. 动态数据字典。B. 静态数据字典。C. dba_*视图。D. all_*视图。 答案. A
11.使用数据库初始化参数文件中的()参数可以指定控制文件名。(第
十章)
6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple542.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-
A. CONTROL_FILES。B. CONTROL_FILES_NAME。
C. CONTROL_NAME。D. CONTROL_FILE。
答案. A
12.在恢复操作中，使用的最重要的结构是()，包括两个或者更多预先分配好的文件，存储了对数据库所做的修改。(第十章) A. 联机重做日志文件。B. 归档日志文件。C. 归档数据文件。D. 联机数据文件。
答案. A
13. Oracle提供了()的能力，以免损坏实例的联机重做日志文件，LGWR将同一个重做日志同时写到多个同样的联机重做日志文件中。(第十章) A. 双向联机重做日志文件。B. 单向联机重做日志文件。 C. 切换联机重做日志文件。D. 多路复用联机重做日志文件。
-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record552.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7
答案. D
14.在CREATE DATABASE语句中，使用()参数，可以为每个数据库指
定联机重做日志文件的最大组数。
A. MAXFILES。B. MAXLOGFILE。C. MAXLOGFILES。D. LOGFILES。 答案. C
15.下面()的语句，将向数据库添加一个新的重做日志文件组。(第
十章)
A.ALTER DATABASE ADD LOGFILE(‘/oracle/dbs/logic.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 500K;
B.ALTER DATABASE ADD ONLIELOGFILE(‘/oracle/dbs/logic.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 500K;
C.MODIFY DATABASE ADD ONLIELOGFILE(‘/oracle/dbs/logic.rdo’,
ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple562.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2
‘/oracle/dbs/log2c.rdo’) SIZE 500K;
D.MODIFY DATABASE ADD LOGFILE(‘/oracle/dbs/logic.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 500K;
答案. A
16. Oracle允许将已填满的联机重做日志文件的组保存到一个或者多
个脱机目的地，这些日志全都称为()。(第十章)
A. 联机归档重做日志文件。B. 已归档的重做日志。
C. 已归档的联机重做日志文件。D. 非归档的重做日志文件。 答案. B
17. Oracle 允许数据库中有比操作系统
规定
关于下班后关闭电源的规定党章中关于入党时间的规定公务员考核规定下载规定办法文件下载宁波关于闷顶的规定
的限制更多的数据文件，
Oracle的()进程能够打开所有联机的数据文件。(第十章)
A. LGWR。B. DBWn。C. SMON。D. PMON。
-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record572.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4
答案. B
18.当需要创建并添加一个数据文件到表空间，可以使用如下()语句。(第十章)
A. CREATE TABLESPACE。B. CREATE TABLESPACE... ADD DATAFILE。 C. ALTER TABLESPACE„ ADD TEMPFILE。D. ALTER DATABASE„CREATE
DATAFILE。 答案. B
19.如果想要配置Oracle以使用校验和来验证数据块，将初始化参数()设置为TRUE。(第十章)
A. DB_BLOCK。B. DB_EXTENT_CHECKSUM。
C. DB_BLOCK_CHECKSUM。D. DB_SEQENT_CHECKSUM。
答案. C
20.每个运行的Oracle数据库都与Oracle实例相联系。当一个数据库
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple582.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
服务器上的数据库启动时，Oracle将分配内存区，称为()，启动一个
或者多个Oracle进程。(第十一章)
A. 程序全局区。B. 系统全局区。C. 临时表空间。D. 回滚表空间。
答案. B
21.()是有自己的系统全局区和与其相关数据库文件的Oracle服务器
进程集，都要用称为SID(SystemIdentifier，系统标识符)的标识符来
标识。(第十一章)
A. Oracle数据库。B. Oracle进程。C. Oracle实例。D. Oracle服务。
答案. C
22.()是驻留在客户和Oracle数据库服务器之中的软件层，它负责建
立和维护客户应用和服务器之间的连接，并在它们之间进行消息传递。
(第十一章)
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record592.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
A. Oracle OCI。B. Oracle瘦驱动程序。C. Oracle Net。D. 侦听器。
答案. C
23.()是驻留在自己计算机上的软件组件，同客户和Oracle服务器相分离，代理数据库服务器的请求。(第十一章)
A. Oracle Net。B. 侦听器。C. Oracle连接管理器。D. Oracle数据库驱动程序。 答案. C
24.当需要为实例设置并发会话的最大数量，需要设置()初始化参数。(第十二章)
A. DBA_MAX_SESSIONS。B. LICENSE_MAX_SESSIONS。
C. MAX_SESSIONS。D. CONNECT_MAX_SESSIONS
答案. B
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple602.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
25.当需要在数据库运行时修改最大并发使用限制或者警告限制，可以
使用如下()语句。(第十二章)
A. ALTER SYSTEM。B. ATLER TABLE。C. ALTER VIEW。D. ALTER TRIGER。
答案. A
26.了限制在数据库中创建的用户数，就要在数据库的初始化参数文件
中设置()初始化参数。(第十二章)
A. LICENSE_MAX_USERS。B. MAX_USERS。
C. CONNECT_MAX_USERS。D. AVAILABLE_MAX_USERS。
答案. A
27.当需要创建用户时，可以使用如下()语句来完成。(第十二章) A. CREATE USER。B. CREATE ROLE。C. CREATE PROCESS。D. CREATE LOGIN。 答案. A
-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record612.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7
28.在Oracle中，每个用户都应该有一个默认表空间，当用户创建模式对象，并没有为其指定容纳它的表空间时，Oracle就在该用户的默认表空间中存储该对象。每个用户的默认表空间的默认设置是()。(第十二章)
A. SYSTEM表空间。B. SYS表空间。C. USER表空间。D. 临时表空间。
答案. A
29.当需要查询用户的表空间限额时，可以使用如下()数据字典视图。(第十二章)
A. DBA_USERS。B. ALL_USERS。
C. DBA_TS_QUOTAS。D. USER_PASSWORD_LIMITS。
答案. C
30.当需要为某个数据库创建一个用户，用户名为test，密码为test，
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple622.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
可以使用如下()SQL语句。(第十二章)
A.CREATE USER test
IDENTIFIED BY test; B.CREATE USER test
PASSWORD test;
C.UPDATE USER test
IDENTIFIED BY test; D.UPDATE USER test
PASSWORD test;
答案. A
31.假设数据库中创建了一个用户test，状态为锁定状态，需要使用SQL语句解除锁定，可以使用如下()语句。(第十二章)
d range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record632.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipme
A. ALTER USER test ACCOUNT;。B. ALTER USER test NOLOCK;。
C. ALTER USER test ACCOUNT NOLOCK;。D. ALTER test ACCOUNT NOLOCK;。 答案. C
32.假设需要删除数据库中的某个用户test，可以使用如下()语句。
(第十二章)
A. DELETE USER test。B. DROP USER test。
C. DROP test。D. DELETE test。
答案. B
33.假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下()语句。(第十二章)
A. GRANT CREATE ANY TABLE test;B. GRANT CREATE ANY TABLE TO test;
C. TAKE CREATE ANY TABLE TO test;。D. ALTER CREATE ANY TABLE TO
3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple642.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-
test;。 答案. B
34.假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可
以使用如下()语句。(第十二章)
A. TAKE BACK CREATE ANY TABLE FROM test;B. REVOKE CREATE ANY TABLE FROM test;
C. REVOKE CREATE ANY TABLE test;D. TAKE BACK CREATE ANY TABLE test;
答案. B
35.假设需要在数据库中创建角色test_role，可以使用如下()语句。
(第十二章)
A. ALTER DATABASE ROLE test_role。B. CREATE ROLE test_role。
C. UPDATE ROLE test_role。D. ALTER ROLE test_role。 答案. B
-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record652.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4
36.假设需要为test_role角色授予ALTER ANY TABLE系统权限，可以
使用如下()语句。(第十二章)
A. GRANT ALTER ANY TABLE TO test_role;B. REVOKE ALTER ANY TABLE TO test_role;
C. TAKE ALTER ANY TABLE TO test_role;D. ALTER DATABASE ALTER ANY TABLE TO test_role;
答
案. A
37.假设需要收回为角色test_role授予的ALTER ANY TABLE权限，可
以使用如下()语句。(第十二章)
A. GRANT ALTER ANY TABLE FROM test_role;B. TAKE ALTER ANY TABLE FROM test_role;
n. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple662.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing sy
C. REVOKE ALTER ANY TABLE FROM test_role;D. DELETE ALTER ANY TABLE
FROM test_role; 答案. C
38.假设需要为数据库创建表空间tablespace_ temp，可以使用如下()
语句。(第十三章)
A.CREATE tablespace_temp
LOGGING DATAFILE 'users02.dbf' SIZE 10M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE 100M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
B. CREATE TABLESPACE tablespace_temp
LOGGING DATAFILE 'users02.dbf' SIZE 10M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE 100M
c load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record672.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent e
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
C.ALLOCATE TABLESPACE tablespace_temp
LOGGING DATAFILE 'users02.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE 100M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
D.REVOKE TABLESPACE tablespace_temp
LOGGING DATAFILE 'users02.dbf' SIZE 10M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE 100M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple682.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent
答案. B
39.假设需要在Windows的命令行工具中使用侦听器工具，可以在命令
行中输入以下()命令。(第十一章)
A. LISTNER。B. LSNR。C. LSNRCTL。D. LSTN。 答案. C
40.当在侦听器命令行环境中，如果需要查看侦听器当前的运行状态，
可以输入()命令。(第十一章)
A. state。B. start。C. status。D. current。 答案. C
41.如果需要在侦听器命令行环境中查看关于数据库服务以及服务处理
器的运行状态等详细信息，可以使用()命令。(第十一章)
A. server。B. service。C. svr。D. help。
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record692.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
答案. B
42.假设创建了一个侦听器listner1，在侦听器命令行工具中将其设置为当前侦听器，可以使用如下()命令。(第十一章)
A. set listner listner1。B. set current_listner listner1。 C. alter current_listner listner1。D. alter system current_listner listner1。 答案. B
43.通常情况下，Oracle的本地命令方式使用()文件来保存服务名的映射信息，建议使用Oracle Net Configuration Assistant等工具对其进行修改。(第十一章)
A. listner.ora。B. tnsnames.ora。C. net.ora。D. init.ora。
答案. B
44.()是Oracle最高一级逻辑存储结构。(第十章)
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple702.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
A. 块。B. 盘区。C. 段。D. 表空间。
答案. D
45.()是比块更高一级的存储结构，由一系列的块组成，它是Oracle
在进行存储空间分配、回收和管理的基本单元。(第十章)
A. 表空间。B. 盘区。C. 数据文件。D. 段。 答案. B
46.()存储了系统表和数据字典。(第十章)
A. 系统表空间。B. 字典表空间。C. 用户表空间。D. 临时表空间。 答案. A
47.假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下
()方式。(第十章)
A. SELECT name, status FROM V$datafile;
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record712.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
B. SELECT name, status FROM V$userfile;。
C. SELECT name, status FROM V$DBA;。
D. SELECT name, status FROM V$ctrlfile;。
答案. A
48.当需要查询Oracle的控制文件的名称、位置和状态时，可以使用()语句。(第十章)
A. SELECT name FROM V$CONTROLFILE; B. SELECT name FROM V$CTRLLFILE; C. SELECT name FROM V$USERFILES;。
D. SELECT name FROM V$DBAFILE;。
答案. A
49. SGA是一块巨大的共享内存区域，被看成是Oracle数据库的一个大
stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple722.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-
缓冲池，如果需要查看SGA的大小信息，可以使用如下()语句。(第
十章)
A.SELECT SGA FROM V$DBA B.SELECT * FROM V$DBA。
C. SELECT * FROM V$SGA D. SELECT size FROM V%DBA。 答案. C
50. ()进程是一个和前台用户进程通信的进程，当数据库修改时，系
统会产生一个日志并记录在重做日志缓冲区内。(第十章)
A. DBWR。B. SMON。C. LGWR。D. PMON。 答案. C
Oralce数据库应用开发模拟题
1.()是Oracle的定长数据类型。
A. DATE。B. Varchar2。C. NUMBER。D. CHAR。
-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record732.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7
答案.D
2.()是DDL。
A. INSERT INTO TABLE。B. CREATE TABLE 。C. CREATE VIEW。D. DELETE TABLE。
答案. A
3.()函数是按照某种分组方式计算出返回结果的排行，支持分组排名。 A. RANK。B. REGR_R2。C. ROLLUP。D. COBE。
答案.A
4.假设需要更改Customer表中LogoutTime列的数据类型为DATE类型，可以使用如下()方式。
A.ALTER TABLE CUSTOMER
modify ( "LOGOUTTIME" DATE);
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple742.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
B.ALTER TABLE CUSTOMER
ALTER ( "LOGOUTTIME" DATE); C.ALTER TABLE CUSTOMER
modify "LOGOUTTIME" DATE ; D.ALTER TABLE CUSTOMER
ALTER "LOGOUTTIME" DATE ;
答案. A
5.假设需要删除CUSTOMER表上为STATUS列创建的检查约束CK_STATUS，可以采用如下()方式。
A. MODIFY TABLE CUSTOMER
DROP CONSTRAINT CK_STATUS; B. UPDATE TABLE CUSTOMER
d range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record752.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipme
DROP CK_STATUS;
C. ALTER TABLE CUSTOMER
DROP CK_STATUS;
D. ALTER TABLE CUSTOMER
DROP CONSTRAINT CK_STATUS;
答案. D
6.()语句可以使用户设置事务处理的各种属性，例如它的隔离层次、它是只读的还是可以进行读写的、是否需要使用特定的回滚段等。 A. set savepoint。B. set rollback。
C. set transaction。D. set commit。
答案. C
7.在查询中执行数据过滤是通过查询语句的()子句来完成的，通过过
n. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple762.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing sy
滤数据，可以只查询满足要求的数据，减少数据查询的量，提高查询性
能。
A. WHERE。B. FROM。C. SUQUERY。D. JOIN。 答案. A
8.()像表一样由列组成，其查询方式与表相同，但是不包含数据。
A. 同义词。B. 视图。C. 索引。D. 过程。 答案. B
9.使用()命令，可以把查询结果保存到一个文件中，或者把查询结果
发送到打印机。
A. help。B. desc。C. prompt。D. spool。 答案. D
10. 当创建了过程，可以在SQL*Plus中使用()执行之。
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record772.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
A. exec函数。B. SET。C. COMMIT。D. TAKE。 答案. A
11. 在Oracle中使用()可以允许用户从逻辑上组织过程、函数、
对象类型等各种内容。
A. 程序包。B. 过程。C. 函数。D. 对象。 答案. A
12.在IBatis框架中，利用()来定义需要持久化的对象。
A. 配置文件。B. 映射文件。C. 对象。D. 数据库表。 答案. B
13. 在iBatis框架中，()关联不需要额外的表字段。
A. 主键关联。B. 惟一外键关联。C. 外键关联。D. 约束关联。 答案. A
-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple782.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5
14. Hibernate的一级缓存是由()维护的。
A. SessionFactory实例。B. Session实例。C. Query接口实例。D.
Configuration实例。
答案. B
15.当用户进程失败时，由()执行恢复操作，负责清除缓存和进程使
用的空闲资源。
A. SMON。B. PMON。C. ARCn。D. RECO。
答案. B
16.()是数据库中的基本逻辑结构，包含了一系列数据文件的集合。
A. 表。B. 表空间。C. 段。D. 盘区。
答案. B
17.()是Oracle最基本的物理存储单元。
6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record792.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -
A. 数据文件。B. 控制文件。C. 日志文件。D. 物理块。 答案. D
18.()是一个小型的二进制文件，可以记录数据库的物理结构。
A. 参数文件。B. 数据文件。C. 控制文件。D. 配置文件。 答案. C
19. ()进程以循环方式填写联机重做日志文件。
A. ARCn。B. LGWR。C. PMON。D. SMON。
答案. B
20.当启动一个Oracle实例时，初始化参数()指出为数据文件信息保
留的SGA空间的数量。
A. DB_FILES。B. DB_DATAFILES。C. DATABASE_FILES。D. LOG_FILES。 答案. A
10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple802.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-
21.()是Oracle的集成管理平台，能够管理整个Oracle环境，对组织中的所有设备，包括主机、数据库、侦听器、应用服务器、HTTP服务器、Web应用都能够进行管理。
A. SQL*Plus。B. Oracle企业管理器。C. Net Manager。D. 数据库管理器。 答案. B
22. 数据库服务器通过()接收一个来自于客户应用程序的一个初始化连接，它是一个位于Oracle网络基础层顶层的一个应用程序。 A. Oracle Net。B. 监听器。C. Oracle企业管理器。D. Oracle 数据库管理器。 答案. B
23.假设在数据库中已经创建了某个用户test，需要将其口令修改为oracle，可以使用如下()语句。
A. ALTER USER test IDENTIFIED BY oracle;
-6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record812.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110
B. ALTER USER test PASSWORD oracle; C. CREATE USER test IDENTIFIED BY oracle;
D. UPDATE USER test IDENTIFIED BY oracle。
答案. A
24.假设在数据库中创建了某个用户test，需要将其默认表空间修改为users，可以使用如下()语句。
A.UPDATE USER test
DEFAULT TABLESPACE users; B.ALTER USER test
TABLESPACE users;
C.ALTER USER test
ON TABLESPACE users;
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple822.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
D.ALTER USER test
DEFAULT TABLESPACE users; 答案. D
25.假设需要删除某个角色test_role，可以使用如下()语句。
A. DELETE ROLE test_role。B. REVOKE ROLE test_role。
C. DROP ROLE test_role。D. DELETE test_role。
答案. C
26. 当需要查询日志文件所有组及其成员的名称和文件位置，可以
使用()方式。
A. SELECT * FROM V$LOGFILE;B. SELECT * FROM V$LOG;
C. SELECT * FROM V$LOGHISTORY;D. SELECT * FROM V$DBA; 答案. A
nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record832.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2
27. 以下()进程，可以用于同步数据文件、日志文件和控制文件。
A. DBWR。B. LGWR。C. CKPT。D. PMON。
答案. C
28. 对于数据库备份，以下说法错误的是:
A. 冷备份可以在归档模式和非归档模式下进行。B. 冷备份必须在数据
库关闭的情况下进行。
C. 热备份必须在数据库处于归档模式下进行。
D. 使用热备份，只能备份所有的数据文件，不能备份控制文件。 答案. D
29. 假设用户user1的temp1表分区为PART1、PART2和PART3，需要导
出整个表及其分区，可以使用如下()命令。
A. EXP SYSTEM/MANAGER FILE=EXPDAT.DMP
-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple842.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7
TABLES=(user1.temp1,part1,part2,part3)。
B. EXP SYSTEM/MANAGER FILE=EXPDAT.DMP。
C. EXP SYSTEM/MANAGER FILE=EXPDAT.DMP TABLES=(user1.temp1)。 D. EXP SYSTEM/MANAGER FILE=EXPDAT.DMP TABLES=(user1.temp1,full)。 答案. C 30. 假设需要导出某个表table1，只导出表结构，不导出数据，可以使用如下()命令。
A. EXP user/pwd tables=(name, table1) file=export.dmp Rows=y。 B. EXP user1/pwd table table1 file=extable1.dmp。
C. EXP user/pwd tables=(name, table1) file=export.dmp Rows=n。 D. EXP user1/pwd table=table1 file=extable1.dmp Rows=n。
答案. C
-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record852.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4
31. 当需要返回当前用户的名字，可以执行如下()SQL语句。
A. SELECT user FROM V$DBA;B. SELECT user FROM dual; C. SELECT name FROM dual;D. SELECT name FROM V$DBA;
答案. B
32. 下列对于惟一码约束，说法错误的是()。
A. 定义了惟一码约束的字段不能有重复值。B. 惟一码约束只能在表级
定义。
C. 可以使用一个字段作为惟一码约束。D. 定义惟一码约束的字段，可
能出现空值。 答案. B
33. 使用()工具，可以实现数据导出。
A. IMPORT。B. EXPORT。C. DBCA。D. Oracle Net Manager。 答案. B
3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple862.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-
34.数据处理技术通常分为以下()三种类型。
A. 人工处理。B. 文件系统处理。C. 字处理。D. 数据库系统处理。
答案. A、B、D
35.当创建列表分区时，必须指定()。
A. 分区方法:列表。B. 分区列。C. 分区描述。D. 列表分区的多个列
值。 答案. A、B、C
36.使用显式游标的过程主要包括()操作。
A. 定义显式游标。B. 打开显式游标。C. 从显式游标中读取数据。
D. 关闭显式游标。
答案. A、B、C、D
37.程序包通常()组成。
A. 规范。B. 函数。C. 主体。D. 过程。
1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record872.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-
答案. A、C
38.触发器事件和语句是SQL语句、数据库事件、用户事件，导致触发
器触发。触发器时机可以是():
A. 对特别表(视图)的INSERT、UPDATE、DELETE语句;。
B. 对特定模式对象的CREATE 、ALTER和DROP语句;。
C. 数据库启动、实例关闭。D. 特定的错误消息和任何错误消息。 答案. A、B、C、D
39.当需要查询段的详细信息，可以使用如下()数据字典视图。
A. DBA_SEGMENTS。B. ALL_SEGMENTS。C. USER_SEGMENTS。D. USER_SEGMENTS。 答案. A、B、D
40.触发器可以创建在下列()对象上。
A. 数据库表。B. 数据库视图。C. 数据库实例。D. 用户模式。
2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple882.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-
答案. A、B、C、D
41. PL/SQL的循环控制语句LOOP包括以下()几种类型。
A. LOOP。B. WHILE„.LOOP。C. IF„LOOP。D. FOR„LOOP。
答案. A、B、D
42. Oracle中的游标分为()两种类型。
A. 静态游标。B. 动态游标。C. 隐式游标。D. 显式游标。 答案. A、B或者是B、C、D
43. 以下()是数据库冷备份的优点。
A. 只需拷贝文件即可，是非常快速的备份方式。
B. 与数据库归档的模式相结合可以使数据库很好地恢复。
C. 维护量相对较少，安安全性确相对较高。D. 备份时数据库仍然可用。 答案. A、B、C
-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record892.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5
44.以下()是Oracle相关的系统服务，在Windows操作系统中，可以
使用控制面板的服务工具进行管理。
A. Oracle代理服务。B. Oracle的侦听程序。
C. 用于OEM管理结构。D. Oracle 网络服务。
答案. A、B、C
45. Oracle物理数据库包含()类型重要的文件。
A. 数据文件。B. 控制文件。C. 参数文件。D. 配置文件。
答案. A、B、C
46.对于Check约束，下面说法错误的是()。
A. 在CHECK约束的表达式中必须引用到表中的一个或多个字段，并且
表达式的计算结果必须是一个布尔值。B. 可以在表级定义CHECK约束。
C. 不能在字段级定义CHECK约束。
-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pipvibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple902.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5
D. 对同一个字段可以定义多个CHECK约束，同时也可以定义NOT NULL约束。
答案. C
47.当误删除某数据，可以执行()操作，恢复被删除的数据。 A. 闪回查询。B. 事务控制。C. 子查询。D. 合并查询。
答案. A
48.假设需要给某个客户表Customer的Customer_name列添加注释信息:客户姓名，可以使用如下()方式。
A. COMMENT ON TABLE CUSTOMER IS '客户姓名';
B.COMMENT ON COLUMN
CUSTOMER.CUSTOMER_NAME IS '客户姓名'
C.COMMENT ON COLUMN
3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipmed range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record912.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-
CUSTOMER.CUSTOMER_NAME '客户姓名'
D.COMMENT ON COLUMN
CUSTOMER.CUSTOMER_NAME '客户姓名'
答案. B
49.假设需要修改customer客户表的True_name列为非空，可以使用如下()方式。
A.UPDATE TABLE CUSTOMER
MODIFY TRUE_NAME NOT NULL ; B.ALTER TABLE CUSTOMER
UPDATE TRUE_NAME NOT NULL ; C.ALTER TABLE CUSTOMER
TAKE TRUE_NAME NOT NULL ;
vibration and soothing water, without affecting the adjacent equipment maintenance and other piping installation and expansioevent t; guaranteed under various conditions, stress are within the allowed range. Strength, stiffness, and meet requirements to prC. support systems should be rational to withstand pipe loads, static load and incidental load; reasonable piping displacemenion. installation of steam pipe with particular attention reserved for compensation of thermal expansion displacement and orientat ping support and hanger set and selection should be based on comprehensive analysis of general layout of piping systems; coldof pi installed strictly in accordance with the drawings and designs shall not be installed wrong, missing, etc. B. own arrangementtion about the direction you want. 7.3.14. hangers installation 7.3.14.1 hanger layout a. a clear design of hanger should be d rotat and control drawing number one by one, by series baled. Color alloy steel parts, the parts marking installation location anads. 5) check the surface quality, folded layering and without cracks, rust and other defects. 5) after completion of the tesspring, hangers and constant support hangers) it should also be recognized as setting and locking of lo and performance test copies of the record. If necessary, review should be carried out; 4) for spring hangers (included simple922.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ge slope mouth about 2 mm argon arc welding weld strengthening surface height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each ed-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-10 weld form no slope mouth weld strengthening height h (mm) 1-6 7-3 4-stems to prevent pipeline ... Tube wall thickness (mm) 2ing syn. D. equipment connected to the interface to meet pipeline thrust (torque) limit requirements; increase the stability of pip
D.ALTER TABLE CUSTOMER
MODIFY TRUE_NAME NOT NULL ; 答案. A
50.下面()不是Oracle事务控制语句。
A. commit。B. rollback。C. savepoint。D. GoTo。 答案. D
d range. Strength, stiffness, and meet requirements to prevent vibration and soothing water, without affecting the adjacent ec load and incidental load; reasonable piping displacement; guaranteed under various conditions, stress are within the allowestati ompensation of thermal expansion displacement and orientation. C. support systems should be rational to withstand pipe loads,ensive analysis of general layout of piping systems; cold installation of steam pipe with particular attention reserved for cmprehnot be installed wrong, missing, etc. B. own arrangement of piping support and hanger set and selection should be based on co 14.1 hanger layout a. a clear design of hanger should be installed strictly in accordance with the drawings and designs shalln 7.3.y steel parts, the parts marking installation location and rotation about the direction you want. 7.3.14. hangers installatios, rust and other defects. 5) after completion of the test and control drawing number one by one, by series baled. Color allocrack gers) it should also be recognized as setting and locking of loads. 5) check the surface quality, folded layering and without. If necessary, review should be carried out; 4) for spring hangers (included simple spring, hangers and constant support hanand performance test copies of the record932.5 width b (mm)-2 2-1 .5 1.5-6 weld form weld strengthening height h (mm) 1--4 5--3 3--ce height and width tube wall thickness (mm) 22 2 weld width b (mm) cover had each edge slope mouth about 2 mm argon arc welding weld strengthening surfa-6 has slope mouth weld strengthening height h (mm) 1.5-6 7-2 weld width b (mm) 5-1.5 1.5-weld form no slope mouth weld strengthening height h (mm) 110 -6 7-3 4-torque) limit requirements; increase the stability of piping systems to prevent pipeline ... Tube wall thickness (mm) 2nt maintenance and other piping installation and expansion. D. equipment connected to the interface to meet pipeline thrust (quipme
浙公网安备 33021202002483