A.Both tables have NULL values.
B.You want all unmatched data from one table.
C.You want all matched data from both tables.
D.You want all unmatched data from both tables.
E.One of the tables has more data than the other.
F.You want all matched and unmatched data from only one table.

A.ALTER TABLE commercials MODIFY (description CHAR2(1000));
B.ALTER TABLE commercials CHANGE (description CHAR2(1000));
C.ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
D.ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
E.You cannot increase the size of a column if the table has rows.

A.ALTER TABLE students ADD PRIMARY KEY student_id;
B.ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
C.ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D.ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E.ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

A.A subquery should retrieve only one row.
B.A subquery can retrieve zero or more rows.
C.A subquery can be used only in SQL query statements.
D.Subqueries CANNOT be nested by more than two levels.
E.A subquery CANNOT be used in an SQL query statement that uses group functions.
F.When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

A.UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180）WHEREemployee_id=180；
B.UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployees）WHEREemployee_id=180；
C.UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180）   WHEREemployee_id=（SELECTemployee_idFROMnew_employees）；
D.UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=（SELECTemployee_idFROMnew_employees）   WHEREemployee_id=180；

A.USER_CONSTRAINTS
B.USER_OBJECTS
C.ALL_CONSTRAINTS
D.USER_CONS_COLUMNS
E.USER_COLUMNS

A.cannot be nested
B.manipulate data items
C.act on each row returned
D.return one result per row
E.accept only one argument and return only one value
F.accept arguments which can be a column or an expression

A.The value displayed in the CALC_VALUE column will be lower.
B.The value displayed in the CALC_VALUE column will be higher.
C.There will be no difference in the value displayed in the CALC_VALUE column.
D.An error will be reported.

A.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, department_id FROM employees WHERE mgr_id IN (102, 120);
C.CREATE VIEW emp_vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_id;
D.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

A.A WHERE clause can be used to restrict both rows and groups.
B.A WHERE clause can be used to restrict rows only.
C.A HAVING clause can be used to restrict both rows and groups.
D.A HAVING clause can be used to restrict groups only.
E.A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
F.A HAVING clause CANNOT be used in subqueries.