SQL Quiz Questions and Answers

DataFlair Team

3 years ago

SQL quiz

FREE Online Courses: Your Passport to Excellence - Start Now

In this SQL Quiz, we will try to test our knowledge of the SQL Concepts. In this Quiz, we have covered questions from almost all topics of SQL.

Do not miss to attempt other parts of the SQL Online Quizzes:

Let us now start our quiz.

Time limit: 0

Quiz Summary

0 of 25 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 25 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

Current
Review / Skip
Answered
Correct
Incorrect

Question 1 of 25

1. Question
What is the full form of SQL?
- Structured Query Language
- Structured Question Language
- Structural Query Language
- Structuring Query Language
Correct

Incorrect
Question 2 of 25

2. Question
How many Primary keys can be created on a table?
- Infinity
- 2
- 1
- 24
Correct

Incorrect
Question 3 of 25

3. Question
Which of the following is not a Clause in SQL?
- Below
- Limit
- Where
- Group By
Correct

Incorrect
Question 4 of 25

4. Question
Which of the following query would limit the output to 5 rows?
- SELECT * FROM DataFlair 5;
- SELECT * FROM DataFlair LIMIT 5;
- SELECT * FROM DataFlair 5 LIMIT;
- SELECT LIMIT(5) * FROM DataFlair ;
Correct

Incorrect
Question 5 of 25

5. Question
Which of the following is not a part of CRUD operations in SQL?
- Creating a table.
- Deleting records from the table.
- Creating a copy of a table.
- Updating the data stored in the table.
Correct

Incorrect
Question 6 of 25

6. Question
Which of the following shows comment in SQL?
- /* This is a comment. */
- # This is a comment.
- % This is a comment. %
- & This is a comment.
Correct

Incorrect
Question 7 of 25

7. Question
Which of the following query depicts the correct Select statement?
- Select # From DataFlair;
- Select * From DataFlair;
- Select From DataFlair;
- Select col1,col2 From;
Correct

Incorrect
Question 8 of 25

8. Question
Which of the following query finds employees with an experience more than 5?
- Select * From DataFlair where experience>5;
- Select * From DataFlair;
- Select * From DataFlair where experience>=5;
- Select * From DataFlair where experience<=5;
Correct

Incorrect
Question 9 of 25

9. Question
Which of the following is used to modify the data stored in the database?
- SELECT
- INSERT INTO
- UPDATE
- LIMIT
Correct

Incorrect
Question 10 of 25

10. Question
Which of the following is not an aggregate function in SQL?
- SUM
- AVG
- COUNT
- FIND
Correct

Incorrect
Question 11 of 25

11. Question
Which of the following is not true about SQL Subqueries?
- They are nested queries.
- Subqueries are executed first.
- Only one subquery can be nested.
- None of these.
Correct

Incorrect
Question 12 of 25

12. Question
Which of the following operator is used to extract pattern matching data from the database?
- LIKE
- SELECT
- FIND
- UPDATE
Correct

Incorrect
Question 13 of 25

13. Question
Which of the following is true about a cursor in SQL?
- It is read-only.
- The cursor can perform all the CRUD operations.
- Cursors are objects of the query.
- Cursors are created automatically.
Correct

Incorrect
Question 14 of 25

14. Question
SQL database follows which of the following principles?
- ACID
- AGILE
- SQL
- DBMS
Correct

Incorrect
Question 15 of 25

15. Question
Which of the following is not a data type in SQL?
- int
- Varchar
- Image
- blob
Correct

Incorrect
Question 16 of 25

16. Question
Which of the following join extracts data of matching rows from both tables?
- Full Outer Join
- Left Join
- Right Join
- None of these.
Correct

Incorrect
Question 17 of 25

17. Question
Which keyword allows us to find the unique values in the database?
- DISTINCT
- UNIQUE
- FIND
- DIFF
Correct

Incorrect
Question 18 of 25

18. Question
Which of the following clause allows us to extract data in a range?
- Between
- Range
- Find In
- Like
Correct

Incorrect
Question 19 of 25

19. Question
Which of the following is not true about views?
- Can be created only from one table.
- Grouping using functions is present.
- No DML queries can be executed on the views.
- All of the above statements are true.
Correct

Incorrect
Question 20 of 25

20. Question
Which of the following statements about the MAX function in SQL are true?
- Can be used on any datatype.
- Returns the max value of the attribute.
- It is an aggregate function.
- All of the above statements are true.
Correct

Incorrect
Question 21 of 25

21. Question
Which of the following is true about the RDBMS?
- RDBMS stands for the Relational Database Management System.
- RDBMS is mandatory to use to create a database.
- Both a and b.
- None of these.
Correct

Incorrect
Question 22 of 25

22. Question
Which of the following is true about NULL values in SQL?
- A NULL value means zero.
- A null value can only be used with numeric attributes.
- Null value just means that data of that attribute is not available.
- None of these.
Correct

Incorrect
Question 23 of 25

23. Question
BLOB in SQL stands for?
- Binary Large Object
- Big Logic Object
- Binary Logic Object
- None of these.
Correct

Incorrect
Question 24 of 25

24. Question
Which data type of SQL is used to store a JSON object?
- NVarchar
- BLOB
- Char
- Int
Correct

Incorrect
Question 25 of 25

25. Question
Which of the following is true about a view?
- The view gets deleted automatically after the session is completed.
- Views cant be updated once created.
- Views are created by grouping a single desired attributes of a database.
- None of these.
Correct

Incorrect

Summary

In this SQL quiz, we have tried to cover almost all topics from our tutorials.

We have covered all the important topics and we will be rolling out more quizzes soon. We recommend attempting the quiz once you are well aware of all the topics.

Exit mobile version