单项选择题
EXHIBIT, Emp Table
Exhibit A
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?（）
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.
相关考题
-
多项选择题
Which two statements about creating constraints are true?（）
A. Constraint names must start with SYS_C
B. All constraints must be defines at the column level
C. Constraints can be created after the table is created
D. Constraints can be created at the same time the table is created
E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view -
单项选择题
For which action can you use the TO_DATE function?（）
A. Convert any date literal to a date
B. Convert any numeric literal to a date
C. Convert any character literal to a date
D. Convert any date to a character literal
E. Format '10-JAN-99' to 'January 10 1999' -
单项选择题
What is true regarding subqueries?（）
A. The inner query always sorts the results of the outer query
B. The outer query always sorts the results of the inner query
C. The outer query must return a value to the outer query
D. The inner query returns a value to the outer query
E. The inner query must always return a value or the outer query will give an error
