EXHIBIT, Emp Table
 Exhibit A
	Exhibit A	 Exhibit B
	Exhibit B	 Examine the data from the EMP table.	Evaluate this SQL statement:	SELECT *	FROM emp	WHERE emp _ id = 3);	WHERE commission = (SELECT commission	FROM emp	What is the result when the query is executed?()
	Examine the data from the EMP table.	Evaluate this SQL statement:	SELECT *	FROM emp	WHERE emp _ id = 3);	WHERE commission = (SELECT commission	FROM emp	What is the result when the query is executed?()A:Exhibit A
B:Exhibit B
C:The query returns no rows
D:The query fails because the outer query is retrieving more than one column
E:The query fails because both the inner and outer queries are retrieving data from the same table.
出自:Oracle认证
 
        