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

A. SELECT TO_CHAR(2000, '$#,###.##') FROM dual;
B. SELECT TO_CHAR(2000, '$0,000.00') FROM dual;
C. SELECT TO_CHAR(2000, '$9,999.00') FROM dual;
D. SELECT TO_CHAR(2000, '$9,999.99') FROM dual;
E. SELECT TO_CHAR(2000, '$2,000.00') FROM dual;
F. SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;

A.INSERT
B.UPDATE
C.SELECT
D.DESCRIBE
E.DELETE
F.RENAME

A.SELECT SUM(subj1, subj2, subj3) FROM marks;
B.SELECT SUM(subj1 + subj2 + subj3) FROM marks;
C.SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;
D.SELECT MAX(subj1, subj2, subj3) FROM marks;
E.SELECT MINIMUM(subj1) FROM marks;
F.SELECT COUNT(std_id) FROM marks WHERE subj1 >= AVG(subj1);

A.SELECT COUNT(*) FROM employees WHERE last_name='Smith';
B.SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
C.SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
D.SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
E.SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

A.SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B.SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C.SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D.SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E.SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

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.

A.The two statements produce identical results.
B.The second statement returns a syntax error.
C.There is no need to specify DESC because the results are sorted in descending order by default.
D.The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.