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 names of all the students whose email ids are not provided?

A - select first_name, last name from students where email = 0;

B - select first_name, last name from students where email = ‘ ‘;

C - select first_name, last name from students where email is null;

D - select first_name, last name from students where email = ‘null’;

Answer : C

Q 5 - You want to calculate the sum of commissions earned by the employees of an organisation. If an employee doesn’t receive any commission, it should be calculated as zero. Which will be the right query to achieve this?

A - select sum(nvl(commission, 0)) from employees;

B - select sum(commission, 0) from employees;

C - select nvl(sum(commission), 0) from employees;

D - None of the above.

Answer : A

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

Answer : B

Q 10 - Which of the following is not a developer’s privilege?

A - CREATE USER

B - CREATE TABLE

C - CREATE VIEW

D - CREATE SEQUENCE

Answer : A


sql_questions_answers.htm

Advertisements
E-Books Store