单项选择题
A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schema even if you don't have privileges
D.creates a view regardless of whether or not the base tables exist
单项选择题 What is true about updates through a view?（）
单项选择题 Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = Smith); What is the result when the query is executed?（）
单项选择题 The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）