Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q481: Which SQL operator is used to check for NULL values?
- A: LIKE
- B: IS
- C: BETWEEN
- D: IN
View Answer
B
Q482: The SQL statement SELECT crCode, crName FROM course WHERE prName NOT = 'MCS' returns courses:
- A: Offered to the MCS program
- B: Not offered to the MCS program
- C: Offered to both MCS and BCS programs
- D: None of the above
View Answer
B
Q483: What does the WHERE clause do when multiple tables are joined?
- A: Deletes matching rows
- B: Inserts data into multiple tables
- C: Filters rows from multiple tables
- D: Creates new tables
View Answer
C
Q484: Which SQL command is used to retrieve rows where a column's value is within a certain range?
- A: LIKE
- B: IN
- C: BETWEEN
- D: EXISTS
View Answer
C
Q485: The ORDER BY clause can only be used in which SQL statement?
- A: INSERT
- B: UPDATE
- C: SELECT
- D: DELETE
View Answer
C
Q486: What is the default sorting order if ASC or DESC is not specified in the ORDER BY clause?
- A: Ascending
- B: Descending
- C: Random
- D: No order
View Answer
A
Q487: Which of the following SQL functions converts the value to uppercase?
- A: UPPER
- B: LOWER
- C: LEN
- D: SUBSTRING
View Answer
A
Q488: Which SQL function returns the current system time?
- A: CURRENT_TIME
- B: TIME_NOW
- C: GET_TIME
- D: SYSTEM_TIME
View Answer
A
Q489: Which of the following is a built-in SQL function?
- A: SUM
- B: USER_DEFINED
- C: RANDOM_FUNC
- D: FUNC_USER
View Answer
A
Q490: Which category does the ABS function fall under?
- A: Mathematical
- B: String
- C: Date
- D: System
View Answer
A