Oracle 1z0-071 問題集

質問 1：
Which three statements are true about the Oracle join and ANSI Join syntax?
A. The Oracle join syntax supports natural joins.
B. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI Join Answer.
C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
D. The SQL:1999 compliant ANSI join syntax supports natural joins.
E. The Oracle join syntax supports creation of a Cartesian product of two tables.
F. The Oracle join syntax only supports right outer joins,
G. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
正解：D,E,G

質問 2：
Examine these two queries and their output:
SELECT deptno, dname FROM dept;

SELECT ename, job, deptno FROM emp ORDER BY deptno;

Now examine this query:
SELECT ename, dname
FROM emp CROSS JOIN dept WHERE job = 'MANAGER'
AND dept.deptno IN (10, 20) ;
A. 3
B. 12
C. 6
D. 64
正解：C

質問 3：
Which two statements are true about an Oracle database?
A. A column definition can specify multiple data types.
B. A table can have multiple foreign keys.
C. A NUMBER column without data has a zero value.
D. A table can have multiple primary keys.
E. A VARCHAR2 column without data has a NULL value.
正解：B,E

質問 4：
Which statement is true regarding the SESSION_PRIVS dictionary view?
A. It contains the current system privileges available in the user session.
B. It contains the system privileges granted to other users by the current User session.
C. It contains the object privileges granted to other users by the current user session.
D. It contains the current object privileges available in the user session.
正解：A

質問 5：
Examine the description of the EMPLOYEES table:

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTM ENT_ID?
A. UPDATE employees e1
SET salary=
(SELECT e1.salary + MIN(e2.salary)
FROM employees e2
WHERE e1. department_ id = e2.department_id);
B. UPDATE employees e1
SET salary = salary+(SELECT MIN (salary)
FROM employees e2) ;
C. UPDATE employees e1
SET salary =(SELECT e2. salary + MIN(e2.salary)
FROM employees e2
WHERE e1.department_ id = e2. department_id GROUP BY e2. department_id) ;
D. UPDATE employees e1
SET salary = salary +
(SELECT MIN(e1. salary)
FROM employees e2
WHERE e1.department_id = e2 .department_id);
正解：A

質問 6：
Which three are true about multiple INSERT statements?
A. They can insert each computed row into more than one table.
B. They can be performed on external tables using SQL*Loader.
C. They can be performed on remote tables.
D. They can be performed only by using a subquery.
E. They can be performed on views.
F. They can be performed on relational tables.
正解：C,D,F

質問 7：
Examine this Statement which returns the name of each employee and their manager, SELECT e.last name AS emp,,m.last_name AS mgr FROM employees e JOIN managers m ON e.manager_ id = m. employee_ id ORDER BY emp; You want to extend the query to include employees with no manager. What must you add before JOIN to do this?
A. FULL OUTER
B. LEFT OUTER
C. CROSS
D. RIGHT OUTER
正解：B

質問 8：
Examine this statement which executes successfully:
CREATE view emp80 AS
SELECT
FROM employees
WHERE department_ id = 80
WITH CHECK OPTION;
Which statement will violate the CHECK constraint?
A. SELECT
FROM emp80
WHERE department_ id = 90;
B. DELETE FROM emp80
WHERE department_ id = 90;
C. SELECT
FROM emp80
WHERE department. id = 80;
D. UPDATE emp80
SET department. 1d =80;
WHERE department_ id =90;
正解：D

質問 9：
Which two statements are true regarding non equijoins?
A. The ON clause can be used.
B. Table aliases must be used.
C. The USING clause can be used.
D. The Oracle join syntax can be used.
E. The SQL:1999 compliant ANSI join syntax must be used.
正解：A,D