SQL Online Quiz


Advertisements

Following quiz provides Multiple Choice Questions (MCQs) related to SQL. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

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 the distinct honours subjects in the STUDENTS table?

A - select honours_subject from students;

B - select distinct honours_subject from students;

C - select all honours_subject from students;

D - select * from students;

Answer : B

Q 2 - What is returned by MOD(1000,30)?

A - 33

B - 30

C - 3

D - 10

Answer : D

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;

Answer : D

Q 5 - You want to calculate the minimum percentage of marks obtained under each honours group students, where the minimum marks is more than the minimum marks in economics department. Under which clause should the subquery be?

A - WHERE clause

B - FROM clause

C - HAVING clause

D - None of the above.

Answer : C

Answer : D

Answer : C

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;

Answer : B

sql_questions_answers.htm
Advertisements