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 - 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 correctly display the students’ first name, last name, honours subject and date of birth, born between July 1^st 1996, and 30^th June 1999.

A - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth between ’30-JUN-1999’ and ’01-JUL-1996’;

B - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth in (’30-JUN-1999’ , ’01-JUL-1996’);

C - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth like ’30-JUN-1999’ and ’01-JUL-1996’;

D - select first_name, last name, honours_subject, date_of_birth from students where date_of_birth between ’01-JUL-1996’ and ’30-JUN-1999’;

Q 3 - Which of the following is true about SQL joins?

A - The join condition is not separated from other search conditions in a query.

B - The ON clause makes code difficult to understand.

C - The join condition for natural join is basically an equijoin of all columns with same name.

D - None of the above.

Q 4 - Which of the following is not true about the MAX and MIN functions?

A - Both can be used for any data type.

B - MAX returns the maximum value.

C - MIN returns the minimum value.

D - All are true.

Q 5 - Which of the following is not true about the COUNT function?

A - COUNT(*) returns the number of rows in the table.

B - COUNT(exp) returns the number of rows with non-null values for the exp.

C - COUNT(DISTINCT exp) returns the number of unique, non-null values in the column.

D - All are true.

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

A - When new rows are added to a table.

B - When a table is created.

C - When a transaction is committed.

D - None of the above.

Q 7 - Consider the following schema −

LOCATIONS(subject_code, department_name, location_id, city);

Which code snippet will alter the table LOCATIONS and delete the column named CITY?

A - MODIFY TABLE locations DROP (city varchar2(30));

B - ALTER TABLE locations DROP COLUMN city;

C - ALTER TABLE locations DROP (city);

D - None of the above.

Q 8 - Which of the following code will remove all the rows from the table LOCATIONS?

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 view named all_marks_english?

A - delete view all_marks_english;

B - drop view all_marks_english;

C - delete all_marks_english;

D - drop all_marks_english;

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;