1z0-071 試験問題 36
クエリの WHERE 句で指定された内部結合について正しいのはどれですか?
1z0-071 試験問題 37
Examine the data in the PRODUCTS table:
Examine these queries:
1. SELECT prod name, prod list
FROM products
WHERE prod 1ist NOT IN(10,20) AND category _id=1;
2. SELECT prod name, | prod _ list
FROM products
WHERE prod list < > ANY (10,20) AND category _id= 1;
SELECT prod name, prod _ list
FROM products
WHERE prod_ list <> ALL (10, 20) AND category _ id= 1;
Which queries generate the same output?
Examine these queries:
1. SELECT prod name, prod list
FROM products
WHERE prod 1ist NOT IN(10,20) AND category _id=1;
2. SELECT prod name, | prod _ list
FROM products
WHERE prod list < > ANY (10,20) AND category _id= 1;
SELECT prod name, prod _ list
FROM products
WHERE prod_ list <> ALL (10, 20) AND category _ id= 1;
Which queries generate the same output?
1z0-071 試験問題 38
Which two statements are true regarding the GROUP BY clause in a SQL statement?
(Choose two.)
(Choose two.)
1z0-071 試験問題 39
You must write a query that prompts users for column names and conditions every time it is executed.
The user must be prompted only once for the table name.
Which statement achieves those objectives?
The user must be prompted only once for the table name.
Which statement achieves those objectives?
1z0-071 試験問題 40
展示物を見て、CUSTOMERSテーブルの構造を調べてください。
1 つのステートメントでサブクエリまたは結合を実行する必要がある 2 つのタスクはどれですか?
1 つのステートメントでサブクエリまたは結合を実行する必要がある 2 つのタスクはどれですか?
