SQL Online Quiz

Q 1 - Consider the following schema −

STUDENTS(student_code, first_name, last_name, email, 
         phone_no, date_of_birth, honours_subject, percentage_of_marks);

Which of the following query would display all the students where the second letter in the first name is ‘i’?

A - select first_name from students where first_name like ‘_i%’;

B - select first_name from students where first_name like ‘%i_’;

C - select first_name from students where first_name like ‘%i%’;

D - select first_name from students where first_name like ‘_i_’;

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

A - 789.84

B - 789.83

C - 78

D - 789.00

Q 3 - Which of the following is not true about USING clause?

A - When more than one column has the same name, USING clause is used for specifying the column to be joined by equijoin.

B - It is used for matching one column only.

C - You can use a table name or alias in the referenced columns.

D - The NATURAL JOIN and the USING clauses are mutually exclusive.

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 - A subquery can be placed in which of the SQL clauses?

A - The WHERE clause

B - The HAVING clause

C - The FROM clause

D - All of the above.

Q 6 - Which of the following is true about inserting news rows to a table?

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.

Q 7 - Which of the following is NOT true about the SQL transaction control statements?

A - The COMMIT statement ends the current transaction and makes all data changes permanent.

B - The ROLLBACK statement ends the transaction and discards all the pending data changes.

C - Each DML statement is automatically committed.

D - All are true.

Q 8 - Which of the following code will successfully delete the table LOCATIONS from the database?

A - DROP TABLE locations;

B - DELETE TABLE locations;

C - TRUNCATE TABLE locations;

D - None of the above.

Q 9 - Which of the following code will delete a sequence named loc_seq?

A - delete sequence loc-seq;

B - drop sequence loc_seq;

C - delete primary key loc_sec;

D - drop primary key loc_sec;

Q 10 - Which of the following statements allows William to change his database user account password to bill?

A - create user william identified by bill;

B - alter user william identified by bill

C - create user william password bill;

D - alter user william password bill;