Search Header Logo

SQL MCQ

Authored by Biplab Parida

Education

Professional Development

Used 1+ times

SQL MCQ
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following is a TCL command ?

Grant

Revoke

Both Grant and Revoke

None of them

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following statements are not True about UNION ?

It removes duplicates

It returns query in sorted manner

Performance of UNION is better than UNION ALL

Number of columns should match for all the queries.

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following displays unique value of the column?

UNIQUE

ANY

DISTINCT

ALL

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following statements contains an error?

Select * from emp where empid = 10003 and lastname = ‘PARIDA’;

Select empid from emp where empid = 10006;

Select empid from emp;

Select empid where empid = 1009 ;

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which statement is used to get all data from the student table whose name starts with B?

SELECT * FROM student WHERE name = 'B%';

SELECT * FROM student WHERE name LIKE 'B%';

SELECT * FROM student WHERE name = 'B_';

SELECT * FROM student WHERE name LIKE  '%B';

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How many records will be fetched from the below query if the table has total 10 rows

      select * from students where marks > (select max(marks) from students);

0

1

10

ERROR

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

How many rows are expected when you perform SELF JOIN on this table?          

5

6

11

25

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?