单项选择题
A.The indexed column is declared as NOT NULL.
B.The indexed columns are used in the FROM clause.
C.The indexed columns are part of an expression.
D.The indexed column contains a wide range of values.
单项选择题 What is true regarding subqueries?（）
单项选择题 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? （）