SQL Online Quiz

Q 1 - Which of the following is not true about SQL statements?

A - SQL statements are not case sensitive.

B - SQL statements can be written on one or more lines.

C - Keywords cannot be split across lines.

D - Clauses must be written on separate lines.

Q 2 - What is returned by TRUNC(789.8389, 2)?

A - 789.84

B - 789.83

C - 78

D - 789.00

Q 3 - You want to calculate the tax payable by the employees of an organization. If the employee gets a commission, then the tax would be calculated on commission plus salary, if the employee does not get any commission, then the tax would be calculated on salary only. Which function should you use for calculating tax?

A - NVL

B - NVL2

C - NULLIF

D - COALESCE

Q 4 - Consider the following schema −

HONOURS_SUBJECT(subject_code, subject_name, department_head);

LOCATIONS(subject_code, department_name, location_id, city);

Select the right query for retrieving records from the tables HONOURS_SUBJECT and LOCATIONS with the ON clause

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

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

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

D - None of the above.

Q 5 - Which of the following is not true about a subquery?

A - A subquery is a SELECT statement embedded in a clause of another SELECT statement.

B - The subquery executes before the main query.

C - The result of the main query is returned to the subquery.

D - All of the above.

Q 6 - In which of the following cases a DML statement is not executed?

A - When existing rows are modified

B - When some rows are deleted

C - When a table is deleted

D - All of the above

Q 7 - Which statement allows conditional update, or insertion of data into a table simultaneously?

A - INSERT statement

B - MERGE statement

C - UPDATE statement

D - None of the above

Q 8 - Which of the following is not true about creating constraints?

A - Constraints are defined using the CREATE CONSTRAINT statement.

B - They are created at the same time when the table is created.

C - They could be created after the table is created.

D - All the constraints are stored in data dictionary.

Q 9 - Which of the following minimal code would create a sequence named loc_seq as a primary key of the LOCATIONS table?

A - create sequence loc_seq;

B - create sequence loc_seq on locations;

C - create loc_seq;

D - None of the above.

Q 10 - Which of the following code would create a role named student_admin?

A - CREATE student_admin;

B - GRANT student_admin;

C - CREATE ROLE student_admin;

D - ROLE student_admin;