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.

A.The tables being joined have NOT NULL columns.
B.The tables being joined have only matched data.
C.The columns being joined have NULL values.
D.The tables being joined have only unmatched data.
E.The tables being joined have both matched and unmatched data.
F.Only when the tables have a primary key-foreign key relationship.

A.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
B.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
C.CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
D.CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
E.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
F.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );

A.DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B.DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);
C.DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');
D.DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');

A.SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
B.SELECT ROUND(hire_date) FROM EMP;
C.SELECT sysdate-hire_date FROM EMP;
D.SELECT TO_NUMBER(hire_date + 7) FROM EMP;

A.DELETE employees;
B.DESCRIBE employees;
C.ROLLBACK TO SAVEPOINT C;
D.GRANT SELECT ON employees TO SCOTT;
E.ALTER TABLE employees SET UNUSED COLUMN sal;
F.SELECT MAX(sal) FROM employees WHERE department_id = 20;

A.The UNIQUE constraint does not permit a null value for the column.
B.A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
C.The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
D.The NOT NULL constraint ensures that null values are not permitted for the column.

A.You can join a maximum of two tables through an equijoin.
B.You can join a maximum of two columns through an equijoin.
C.You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D.To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
E.You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

A.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d RIGHT OUTER JOIN employees e ON d.department_id = e.department_id RIGHT OUTER JOIN locations l ON d.location_id = l.location_id;
B.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d FULL OUTER JOIN employees e ON d.department_id = e.department_id FULL OUTER JOIN locations l ON d.location_id = l.location_id;
C.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d LEFT OUTER JOIN employees e ON d.department_id = e.department_id LEFT OUTER JOIN locations l ON d.location_id = l.location_id;
D.SELECT last_name, department_id, department_name, city FROM departments d NATURAL JOIN employees e NATURAL JOIN locations l;

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