下载APP
z-题库
题数
2000
考试分类
z-
售价
¥30
收藏
分享
去刷题
章节目录
简介
z-
...更多
题目预览
【单选题】
[1/2000]Which statement describes the ROWID data type? （）
参考答案：
E
参考解析：
无
【单选题】
[2/2000]Evaluate the following statement： Which statement is true regarding the evaluation of rows return...
A.
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B.
They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C.
They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D.
The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
参考答案：
A
参考解析：
无
【单选题】
[3/2000]When you use the Oracle Net Configuration Assistant to specify the naming method， which file is upda...
A.
INIT.ORA
B.
SQLNET.ORA
C.
LISTENER.ORA
D.
TNSNAMES.ORA
参考答案：
D
参考解析：
无
【单选题】
[4/2000]Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL L...
A.
SELECT dept_id, MIN(salary(, MAX(salary) FROM employees WHERE MIN(salary) <5000 AND MAX (salary) > 15000;
B.
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
C.
SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) <5000 AND MAX (salary) > 15000;
D.
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN (salary) < 5000 AND MAX(salary)
E.
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN (salary) <5000 AND MAX (salary) > 15000
参考答案：
D
参考解析：
无
【多选题】
[5/2000]Some data storage and transfer media have fixed-length physical records. W...
A.
A
B.
B
C.
C
D.
D
参考答案：
B D
参考解析：
无
【多选题】
[6/2000]Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of cont...
A.
adding a new user to the database
B.
dropping a user from the database
C.
dropping a table from the database
D.
dropping a data file from a tablespace
E.
adding a new tablespace to the database
参考答案：
D E
参考解析：
无
【单选题】
[7/2000]Given that t1 is a reference to a live thread, which is true?（）
A.
The Thread.sleep() method can take t1 as an argument.
B.
The Object.notify() method can take t1 as an argument.
C.
The Thread.yield() method can take t1 as an argument.
D.
The Thread.setPriority() method can take t1 as an argument.
E.
The Object.notify() method arbitrarily chooses which thread to notify.
参考答案：
E
参考解析：
无
【多选题】
[8/2000]Identify four valid requests in a RESTful service using JAX-RS.（）
A.
GET
B.
PUT
C.
UPDATE
D.
LETE
E.
POST
F.
REMOVE
参考答案：
A B D E
参考解析：
无
【单选题】
[9/2000]Examine the parameter for your database instance: You generated the execution plan for the following...
A.
The optimizer used a dynamic plan for the query.
B.
The optimizer chose different plans because automatic dynamic sampling was enabled.
C.
The optimizer used re-optimization cardinality feedback for the query.
D.
The optimizer chose different plan because extended statistics were created for the columns used.
参考答案：
B
参考解析：
无
【多选题】
[10/2000]Which statements are true regarding listeners（）
A.
Listeners use only the TCP/IP protocol.
B.
Multiple listener processes can run simultaneously on a host.
C.
Multiple database instances can be registered with a single listener.
D.
The listener-related errors can be traced only at the administrative level.
E.
Only one database instance can be registered with a single listener at any time
参考答案：
B C
参考解析：
无