[2024-06-24更新,250問] 無料Oracle 1z0-071試験問題集、1z0-071予想試験(ページ 8)

1z0-071 試験問題 31

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

A. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

B. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

C. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.

D. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.

1z0-071 試験問題 32

展示物を表示し、PRODUCTS テーブルと SALES テーブルを調べます。

次のクエリを発行して、農産物名とその製品が販売された回数を表示します。
SQL>SLECT p. PROD_name、i . アイテム_cnt
FROM (SELECT prod_id =, count (*) item_cnt
FROMmの売上
GROUP BY prod_id) I RIGHT OUTER JION 製品 p
私に。prod_id =.prod_id;
上記のステートメントを実行すると何が起こるでしょうか?

A. ステートメントは正常に実行され、必要な出力が生成されます。

B. ステートメントによりエラーが生成されます。ITEM_CNT は外部クエリに表示できません。

C. FROM 句内のサブクエリとアウタージオンを一緒に使用できないため、ステートメントはエラーを生成します。

D. FROM 句のサブクエリでは GROUP By 句を使用できないため、ステートメントはエラーを生成します。

1z0-071 試験問題 33

Examine the structure of the EMPLOYEES table.

There is a parent-child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123.
Which query provides the correct output?

A. SELECT e.last_name, m.manager_idFROM employees e LEFT OUTER JOIN employees mon (e.employee_id = m.manager_id)WHERE e.employee_id = 123;

B. SELECT e.last_name, m.manager_idFROM employees e RIGHT OUTER JOIN employees mon (e.manager_id = m.employee_id)AND e.employee_id = 123;

C. SELECT m.last_name, e.manager_idFROM employees e LEFT OUTER JOIN employees mon (e.manager_id = m.manager_id)WHERE e.employee_id = 123;

D. SELECT e.last_name, e.manager_idFROM employees e RIGHT OUTER JOIN employees mon (e.employee_id = m.employee_id)WHERE e.employee_id = 123;

1z0-071 試験問題 34

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)

Which two statements are true regarding data type conversion in query expressions?

A. inv_date > '01-02-2008' : uses implicit conversion

B. inv_amt = '0255982' : requires explicit conversion

C. inv_no BETWEEN '101' AND '110' : uses implicit conversion

D. inv_date = '15-february-2008' :uses implicit conversion

E. CONCAT(inv_amt, inv_date) : requires explicit conversion

1z0-071 試験問題 35

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_idFROM order_itemsWHERE(unit_price*quantity) = (SELECT
MAX(unit_price*quantity)FROM order_items)GROUP BY order_id;

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

C. SELECT order_idFROM order_itemsWHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)FROM order_itemsGROUP BY order_id)

D. SELECT order_idFROM order_itemsWHERE(unit_price*quantity) =
MAX(unit_price*quantity)GROUP BY order_id;