最新的Oracle 1Z0-007免費考試真題

問題1

Which clause should you use to exclude group results?

A. GROUP BY

B. RESTRICT

C. HAVING

D. WHERE

E. ORDER BY

正確答案: C

說明：（僅 Fast2test 成員可見）

問題2

Which one is a system privilege?

A. SELECT

B. CREATE TABLE

C. EXECUTE

D. DELETE

E. ALTER TABLE

正確答案: B

問題3

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.
Which SQL statement would you use to create the view EMP_VU?

A. CREATE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20)
WITH CHECK OPTION;

B. CREATE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20);

C. CREATE FORCE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20);

D. CREATE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20)
WITH READ ONLY;

E. CREATE FORCE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20)
NO UPDATE;

正確答案: A

說明：（僅 Fast2test 成員可見）

問題4

Examine the data in the EMPLOYEES and DEPARTMENTS tables.

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

A. SELECT last_name, department_name FROM employees JOIN departments (+);

B. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

C. SELECT last_name, department_name FROM employees(+) , departments ON (e.department_id = d.department_id);

D. SELECT last_name, department_name FROM employees(+) e JOIN departments d ON (e.department_id = d.department_id);

E. SELECT last_name, department_name FROM employees , departments(+);

F. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

正確答案: B

說明：（僅 Fast2test 成員可見）

問題5

The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

A. no privileges

B. all the privileges of a default user

C. only the CONNECT privilege

D. only the SELECT privilege

正確答案: A

說明：（僅 Fast2test 成員可見）

問題6

Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)

A. INTERVAL DAY TO SECOND

B. TIMESTAMP WITH DATABASE TIMEZONE

C. INTERVAL MONTH TO DAY

D. TIMESTAMP

E. INTERVAL YEAR TO MONTH

正確答案: A,D,E

說明：（僅 Fast2test 成員可見）

問題7

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

A. &

B. ACCEPT

C. PROMPT

D. &&

正確答案: D

說明：（僅 Fast2test 成員可見）

最新的Oracle Introduction to Oracle9i: SQL - 1Z0-007免費考試真題

聯系我們

站內鏈接

最新更新