Oracle 1z0-071 認定試験の出題範囲：

参照：http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-071

Oracle 1z0-071 試験概要:

Oracle Database SQL 認定 1z0-071 試験問題：

問題 #1
Which three statements are true reading subqueries? (Choose three.)

A. Only one column or expression can be compared between the subquery and main query.
B. The subquery and main query must retrieve date from the same table.
C. A subquery can have more than one main query.
D. The subquery and main query can retrieve data from different tables.
E. A Main query can have many subqueries.
F. Multiple columns or expressions can be compared between the subquery and main query.

問題 #2
SCOTTis a user in the database.
Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?

A. Statement 1 would not execute because the WITH GRANT option is missing.
B. Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.
C. Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.
D. Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.

問題 #3
You must display details of all users whose username contains the string 'ch_'.
Which query generates the required output? (Choose the best answer.)

A. SELECT * FROM users
Where user_name LIKE '%ch_%'ESCAPE'%';
B. SELECT * FROM users
Where user_name LIKE '%ch_';
C. SELECT * FROM users
Where user_name LIKE '%ch\_%' ESCAPE '\';
D. SELECT * FROM users
Where user_name LIKE 'ch\_%' ESCAPE '_';

問題 #4
In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?

A. Abigail PA
B. An error message
C. Abigail Pa
D. Abigail IS

問題 #5
View the Exhibits and examine PRODUCTSand SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

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

解説：