SQL Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

427

SQL Questions

1 / 15

1. Command that comes under DML is/are –

A. ROLLBACK

B. GRANT

C. UPDATE

D. All of the above

2 / 15

2. Which among the following are the correct definitions for “NULL” in Mysql?

A. Absence of value

B. Unknown

C. Empty set

D. All of the mentioned

3 / 15

3. SQL Views are also known as

A. Simple tables

B. Virtual tables

C. Complex tables

D. Actual Tables

4 / 15

4. The clause that filters JOIN results is called _________

A. WHERE

B. SORT

C. GROUP

D. GROUP BY

5 / 15

5. In inner join, result is produced by matching rows in one table with rows in another table.

A. true

B. false

6 / 15

6. What is the difference between HAVING and WHERE clause?

A. HAVING clause is used in column operation whereas WHERE clause is used in row operation.

B. HAVING clause is post-filter whereas WHERE clause is pre-filter.

C. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.

D. All of the above

7 / 15

7. Which keyword in the UPDATE statement is used to assign values to columns?

A. ASSIGN

B. SET

C. MARK

D. GET

8 / 15

8. Select the correct syntax of SELECT TOP clause?

A. SELECT TOP name

B. SELECT TOP column

C. SELECT TOP FROM

D. SELECT TOP Number

9 / 15

9. Which feature is used for the automatic increment of the column?

A. AUTO_INCREMENT

B. AUTO

C. INCREMENT

D. All of the mentioned

10 / 15

10. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

A. select_list

B. table_list

C. row_constraint

D. grouping_columns

11 / 15

11. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

A. column name

B. table name

C. server name

D. database name

12 / 15

12. How many Primary keys can have in a table?

A. Only 1

B. Only 2

C. Depends on no of Columns

D. Depends on DBA

13 / 15

13. Which operator is used to compare a value to a specified list of values?

A. ANY

B. BETWEEN

C. ALL

D. IN

14 / 15

14. Command that comes under DCL is/are –

A. GRANT

B. REVOKE

C. Both A. and B.

D. None of the above

15 / 15

15. Full form of TCL is –

A. Transaction Common Language

B. Transaction Commit Language

C. Transaction Concatenate Language

D. Transaction Control Language

Your score is

The average score is 58%

By WordPress Quiz plugin

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Shubhranshu Shekhar

Shubhranshu Shekhar is a coding instructor, mentor, and founder of VSIT Delhi with 20+ years of teaching experience (since 2004). He has guided many students who are now working in multinational companies and specializes in Full Stack Development, Python, Digital Marketing, and Data Analytics.

Related Posts