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 SUBSTR(‘TUTORIALS POINT’, 1, 9)?

A - TUTORIAL

B - POINT

C - TUTORIALS

D - UTORIALS

Q 3 - Consider the following schema −

HONOURS_SUBJECT(subject_code, subject_name, department_head);

LOCATIONS(subject_code, department_name, location_id, city);

Which query will perform a natural join between the HONOURS_SUBJECT table and the LOCATIONS table?

A - select subject_code, subject_name, location_id, city from honours_subject cross join locations;

B - select subject_code, subject_name, location_id, city from honours_subject join locations;

C - select subject_code, subject_name, location_id, city from honours_subject outer join locations;

D - select subject_code, subject_name, location_id, city from honours_subject natural join locations;

Q 4 - Which of the following is not true about the ON clause?

A - ON clause is used to specify conditions or specify columns to join.

B - ON clause makes the query easy to understand.

C - ON clause does not allow three way joins.

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 not true about inserting news rows to a table?

A - The INSERT INTO statement is used for inserting new rows to a table

B - You cannot insert rows with NULL values to a table.

C - You may insert a new row containing values for each column.

D - All 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 add a column named Address, with datatype VARCHAR2(100)?

A - ALTER TABLE locations ADD (address varchar2(100));

B - ALTER TABLE locations ADD COLUMN(address varchar2(100));

C - MODIFY TABLE locations ADD COLUMN (address varchar2(100));

D - None of the above.

Q 8 - Which of the following is true about deleting a table from the database?

A - All the data in the table are deleted

B - The table structure is removed

C - The indexes in the table are deleted

D - All of the above.

Q 9 - Which of the following code will create an index named stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table?

A - It’s not possible to create an index on two columns.

B - create index stu_marks_ind from students(student_code, percentage_of_marks);

C - create index stu_marks_ind on students(student_code, percentage_of_marks);

D - create index stu_marks_ind (student_code, percentage_of_marks) on students;

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;