单项选择题
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 inner 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.
单项选择题 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = James; Rollback to s2; UPDATE new_emp set name = James WHERE employee_id =180; Rollback; At the end of this transaction, what is true?（）
多项选择题 Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work? （）
多项选择题 Which three SELECT statements display 2000 in the format "$2,000.00"? （）