1Z0-051最も有効な質問と解答で勉強

Oracle Database: SQL Fundamentals Iは業界で広く認知された資格であり、取得はキャリアの信頼性を高める確かな一歩となります。Tech4Examの1Z0-051問題集は292問を収録し、公式の出題範囲に沿って学習を組み立てられます。

Oracle 1Z0-051 試験概要:

Oracle 1Z0-051 試験シラバストピック:

1Z0-051に挑戦する方へ – よくある質問まとめ

Oracle Database: SQL Fundamentals I 認定 1Z0-051 試験問題：

問題 #1

Which two statements are true regarding constraints? (Choose two.)

A. A foreign key cannot contain NULL values.
B. A constraint is enforced only for an INSERT operation on a table.
C. You can have more than one column in a table as part of a primary key.
D. The column with a UNIQUE constraint can store NULLS .

問題 #2

View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.

Which statement is true regarding this SQL statement?

A. It executes successfully and generates the required result.
B. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
C. It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).
D. It produces an error because COUNT(*) should be specified in the SELECT clause also.

問題 #3

Evaluate the following SQL statements: Exhibit:

Exhibit:

The above command fails when executed. What could be the reason?

A. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY
B. The BETWEEN clause cannot be used for the CHECK constraint
C. SYSDATE cannot be used with the CHECK constraint
D. The CHECK constraint cannot be placed on columns having the DATE data type

問題 #4

View the Exhibit and examine the structure of the SALES and PRODUCTS tables.

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You want to list each product ID and the number of times it has been sold.
Evaluate the following query:
SQL>SELECT p.prod_id, COUNT(s.prod_id)
FROM products p _____________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN options can be used in the blank in the above query to get the required output? (Choose two.)

A. LEFT OUTER JOIN
B. FULL OUTER JOIN
C. RIGHT OUTER JOIN
D. JOIN

問題 #5

View the Exhibits and examine PRODUCTS and SALES tables.

You issue the following query to display product name and the number of times the product has been sold:
SQL>SELECT p.prod_name, i.item_cnt
FROM (SELECT prod_id, COUNT(*) item_cnt
FROM sales
GROUP BY prod_id) i RIGHT OUTER JOIN products p
ON i.prod_id = p.prod_id;
What happens when the above statement is executed?

A. The statement produces an error because the GROUP BY clause cannot be used in a subquery in the FROM clause.
B. The statement produces an error because ITEM_CNT cannot be displayed in the outer query.
C. The statement produces an error because a subquery in the FROM clause and outer-joins cannot be used together.
D. The statement executes successfully and produces the required output.

解説：