1z0-071試験無料問題集（437題）「Oracle Database SQL 認定」

出題：1

Which statement is true regarding sub queries?

A. The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.

B. The LIKE operator cannot be used with single- row subqueries.

C. =ANY and =ALL operators have the same functionality in multiple- row subqueries.

D. The NOT IN operator is equivalent to IS NULL with single- row subqueries.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)

A. The GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause.

B. Using the WHERE clause before the GROUP BY clause excludes the rows before creating groups.

C. You can use column alias in the GROUP BY clause.

D. If the SELECT clause has an aggregate function, then those individual columns without an aggregate function in the SELECT clause should be included in the GROUP BY clause.

E. Using the WHERE clause after the GROUP BY clause excludes the rows after creating groups.

正解：B,D 解答を投票する

出題：3

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson.
Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?

A. SELECT REPLACE (REPLACE(cust_last_name, `son', `'), `An', `O') FROM customers;

B. SELECT REPLACE (TRIM(TRAILING `son' FROM cust_last_name), `An', `O') FROM customers;

C. SELECT INITCAP (REPLACE(TRIM(`son' FROM cust_last_name), `An', `O')) FROM customers;

D. SELECT REPLACE (SUBSTR(cust_last_name, -3), `An', `O') FROM customers;

正解：A 解答を投票する

出題：4

Which two are the minimal requirements for a self-join? (Choose two.)

A. No other condition except the self-join may be specified.

B. Only equijoin conditions may be used in the query.

C. Outer joins must not be used in the query.

D. The table used for the self-join must have two different alias names in the query.

E. There must be a condition on which the self-join is performed.

正解：D,E 解答を投票する

出題：5

View the Exhibit and examine the structure of the ORDER_ITEMS table.

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

A. SELECT order_id
FROM order_items
WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items GROUP BY order_id)

B. SELECT order_id
FROM order_items
GROUP BY order_id
HAVING SUM(unit_price*quantity) = (SELECT MAX(SUM(unit_price*quantity)) FROM order_items GROUP BY order_id);

C. SELECT order_id
FROM order_items
WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items) GROUP BY order_id;

D. SELECT order_id
FROM order_items
WHERE(unit_price*quantity) = MAX(unit_price*quantity)
GROUP BY order_id;

正解：B 解答を投票する

出題：6

Examine this query:
SELECT 2 FROM DUAL d1 CROSS JOIN DUAL d2 CROSS JOIN DUAL d3;
What is returned upon execution?

A. 0 rows

B. 1 row

C. 6 rows

D. an error

E. 8 rows

F. 3 rows

正解：B 解答を投票する

出題：7

Which three queries execute successfully? (Choose three.)

A. SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

B. SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;

C. SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;

D. SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;

E. SELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;

F. SELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;

正解：B,E,F 解答を投票する

出題：8

Which two statements are true regarding the SQL GROUP BY clause?

A. Using the WHERE clause before the GROUP BY clause excludes rows before creating groups.

B. If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.

C. You can use a column alias in the GROUP BY clause.

D. Using the WHERE clause after the GROUP BY clause excludes rows after creating groups.

E. The GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause.

正解：A,B 解答を投票する

出題：9

Which two statements are true about Data Manipulation Language (DML) statements?

A. An UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table.

B. A DELETE FROM ..... statement can remove rows based on only a single condition on a table.

C. A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

D. AH INSERT INTO. . .VALUES. . statement can add multiple rows per execution to a table.

E. An UPDATE...SET.... statement can modify multiple rows based on only a single condition on a table.

F. An INSERT INTO...VALUES..... statement can add a single row based on multiple conditions on a table.

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z0-071試験無料問題集「Oracle Database SQL 認定」