SQL Test

A - grant student_admin to william;

B - grant to william student_admin;

C - grant william student_admin;

D - None of the above.

A - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h on right outer join location l where(h.subject_code = l.subject_code);

B - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h outer join location l on(subject_code);

C - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h right outer join location l on(h.subject_code = l.subject_code);

D - None of the above.

A - DROP TABLE locations;

B - DELETE TABLE locations;

C - TRUNCATE TABLE locations;

D - None of the above.

A - Existing rows in a table are modified using the UPDATE statement.

B - You can update more than one row at a time.

C - All the rows in a table are modified if you omit the WHERE clause.

D - None of the above.

A - select honours_subject from students;

B - select distinct honours_subject from students;

C - select all honours_subject from students;

D - select * from students;

A - concat

B - substr

C - instr

D - coalesce

A - You must list values in the default order of the columns in the table.

B - You can also list the columns in the INSERT clause.

C - You can use the INSERT statement to add rows from one table to another.

D - All of the above.

A SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT DISTINCT m.mgrId FROM emp m)

B SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT DISTINCT m.mgrId FROM emp m WHERE m.mgrId IS NOT NULL)

C SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT m.mgrId FROM emp m)

D SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT m.mgrId FROM emp m WHERE m.mgrId IS NOT NULL)

enables you to monitor events

check if rows are being inserted properly

check the performance of a stored procedure

ALL answers are correct