Oracle 1z0-061 問題集

質問 1：
What is true regarding sub queries?
A. The inner query returns a value to the outer query
B. The outer query must return a value to the outer query
C. The inner query must always return a value or the outer query will give an error
D. The outer query always sorts the results of the inner query
E. The inner query always sorts the results of the outer query
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
See the Exhibit and examine the structure of ORD table:
Exhibit:

Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, '25-jan-2007, 101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?
A. All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.
B. The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.
C. All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.
D. The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.
正解：A

質問 3：
View the Exhibits and examine the structure of the products and sales tables.
Exhibit 1:

Exhibit 2:

Which two SQL statements would give the same output? (Choose two.)
A. SELECT prod_id FROM productsMINUSSELECT prod_id FROM sales;
B. SELECT DISTINCT p.prod_idFROM products p JOIN sales sON p.prod_id <> s.prod_id;
C. SELECT DISTINCT p.prod_idFROM products p JOIN sales sON p.prod_id=s.prod_id;
D. SELECT prod_id FROM productsINTERSECTSELECT prod_id FROM sales;
正解：C,D

質問 4：
Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?

A. Option A
B. Option C
C. Option D
D. Option B
正解：B

質問 5：
Which two statements are true regarding views? (Choose two.)
A. A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated
B. A view is created with the sub query having the DISTINCT keyword can be updated
C. A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table
D. A sub query that defines a view cannot include the GROUP BY clause
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Examine the structure of the transactions table:

You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be displayed for transactions where the transaction amount has not been entered.
Which query gives the required result?

A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 7：
A SELECT statement can be used to perform these three functions:
Which set of keywords describes these capabilities?
A. selection, intersection, join
B. difference, projection, join
C. difference, projection, product
D. selection, projection, join
E. intersection, projection, join
正解：D
解説: (Topexam メンバーにのみ表示されます)