Oracle Exam 1Z0-061

QUESTION: 1
Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?
A. It executes successfully and displays rows in the descending order of
PROMO_CATEGORY.
B. It produces an error because positional notation cannot be used in the order by
clause with set operators.
C. It executes successfully but ignores the order by clause because it is not located at
the end of the compound statement.
D. It produces an error because the order by clause should appear only at the end of a
compound query-that is, with the last select statement.
Answer: D
QUESTION: 2
View the Exhibit and examine the structure of the product, component, and
PDT_COMP tables. In product table, PDTNO is the primary key.
In component table, COMPNO is the primary key.
In PDT_COMP table, <PDTNO, COMPNO) is the primary key, PDTNO is the foreign
key referencing PDTNO in product table and COMPNO is the foreign key referencing
the COMPNO in component table. You want to generate a report listing the product
names and their corresponding component names, if the component names and product
names exist.
Evaluate the following query:
SQL>SELECT pdtno, pdtname, compno, compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING (compno) WHERE compname IS
NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct
output?







A. JOIN; JOIN
B. FULL OUTER JOIN; FULL OUTER JOIN
C. RIGHT OUTER JOIN; LEFT OUTER JOIN
D. LEFT OUTER JOIN; RIGHT OUTER JOIN
Answer: C
----
QUESTION: 3
View the Exhibit for the structure of the student and faculty tables.



You need to display the faculty name followed by the number of students handled by
the faculty at the base location. Examine the following two SQL statements:



Which statement is true regarding the outcome?
A. Only statement 1 executes successfully and gives the required result.
B. Only statement 2 executes successfully and gives the required result.
C. Both statements 1 and 2 execute successfully and give different results.
D. Both statements 1 and 2 execute successfully and give the same required result.
Answer: D