Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q471: Which function allows the use of multiple conditions in a WHERE clause?
- A: BETWEEN
- B: LIKE
- C: AND/OR
- D: NOT
View Answer
C
Q472: SQL allows rows to be filtered by specific conditions using the _______ clause.
- A: SELECT
- B: WHERE
- C: JOIN
- D: INSERT
View Answer
B
Q473: What does the ORDER BY clause do in SQL?
- A: Filters rows
- B: Sorts records
- C: Deletes rows
- D: Joins tables
View Answer
B
Q474: The SQL command SELECT * FROM suppliers WHERE supplier_id BETWEEN 10 AND 50 returns:
- A: Rows with supplier_id outside the range
- B: Rows with supplier_id between 10 and 50
- C: All rows
- D: No rows
View Answer
B
Q475: To perform pattern matching in SQL, which operator would you use?
- A: LIKE
- B: IN
- C: BETWEEN
- D: IS
View Answer
A
Q476: Which clause is required to filter specific rows in an SQL query?
- A: SELECT
- B: WHERE
- C: INSERT
- D: ORDER BY
View Answer
B
Q477: In the SQL statement SELECT crName FROM course WHERE prName = 'MCS', what is being filtered?
- A: Course name
- B: Program name
- C: Course credits
- D: Supplier name
View Answer
B
Q478: The SQL statement SELECT * FROM suppliers WHERE supplier_name = 'IBM' returns rows:
- A: Where the supplier_id is 'IBM'
- B: Where the supplier_name is 'IBM'
- C: Where the supplier_id is between 10 and 50
- D: Where the supplier_name is NULL
View Answer
B
Q479: Which of the following is a wildcard in the LIKE operator?
- A: %
- B: _
- C: *
- D: Both % and _
View Answer
D
Q480: Which SQL statement returns all supplier names and order IDs from matching records in the supplier and orders tables?
- A: SELECT * FROM suppliers WHERE supplier_id = orders.supplier_id
- B: SELECT supplier_name, order_id FROM suppliers WHERE supplier_id = orders.supplier_id
- C: SELECT supplier_name, order_id FROM suppliers, orders WHERE supplier.supplier_id = orders.supplier_id
- D: SELECT order_id FROM orders WHERE supplier_name = 'IBM'
View Answer
C