Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q461: Which SQL statement is used to insert a new row into a table?
- A: UPDATE
- B: INSERT
- C: SELECT
- D: DELETE
View Answer
B
Q462: What SQL clause is used to filter the rows that satisfy a specific condition?
- A: SELECT
- B: WHERE
- C: FROM
- D: INSERT
View Answer
B
Q463: Which of the following operators is used for pattern matching in SQL?
- A: LIKE
- B: IN
- C: BETWEEN
- D: EXISTS
View Answer
A
Q464: What does the BETWEEN operator do in SQL?
- A: Retrieves exact matches
- B: Retrieves values within a range
- C: Sorts the results
- D: Deletes rows
View Answer
B
Q465: Which SQL clause is used to join multiple tables?
- A: JOIN
- B: SELECT
- C: WHERE
- D: INSERT
View Answer
C
Q466: Which comparison operator is used to check for null values in SQL?
- A: BETWEEN
- B: NULL
- C: IS
- D: IN
View Answer
C
Q467: What is the default sorting order in the ORDER BY clause?
- A: DESC
- B: ASC
- C: RANDOM
- D: GROUP
View Answer
B
Q468: The IN operator can be used to reduce the use of which SQL keyword?
- A: AND
- B: OR
- C: NOT
- D: LIKE
View Answer
B
Q469: Which operator can be used to reverse the effect of the BETWEEN operator?
- A: NOT
- B: IN
- C: LIKE
- D: OR
View Answer
A
Q470: The format of the WHERE clause in SQL includes which of the following?
- A: SELECT columns FROM tables
- B: INSERT columns INTO table
- C: WHERE
- D: DELETE FROM table
View Answer
C