SQL MCQ

Which of the following is a TCL command ?

• Grant

• Revoke

• Both Grant and Revoke

• None of them

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.

Which of the following displays unique value of the column?

• UNIQUE

• ANY

• DISTINCT

• ALL

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 ;

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';

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

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

• 5

• 6

• 11

• 25

SQL Like is NOT used with which of the following statements

• SELECT

• DELETE

• ALTER

• INSERT

How many Rows are expected when the below query is executed?

Select * from TABLEA LEFT JOIN TABLEB ON TABLEA.ID=TABLEB.ID

• 6

• 7

• 8

• 9

Which of the following query will give error?

• SELECT DISTINCT EMPID FROM EMP;

• SELECT * FROM EMP WHERE EMPID = 'B%';

• SELECT EMPID, DEPTID, COUNT(*) FROM EMP GROUP BY EMPID;

• SELECT EMPID, COUNT(*) FROM EMP GROUP BY EMPID HAVING COUNT(*)>1;