Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q451: What keyword is used to avoid duplicate values in an SQL query?
- A: UNIQUE
- B: DISTINCT
- C: FILTER
- D: CHECK
View Answer
B
Q452: What is the output of the query: SELECT * FROM students;?
- A: Only selected rows
- B: All rows and all columns
- C: Only rows with a condition
- D: Only the first row
View Answer
B
Q453: Which of the following is optional in a SELECT statement?
- A: SELECT clause
- B: FROM clause
- C: WHERE clause
- D: VALUES clause
View Answer
C
Q454: The INSERT INTO statement can insert values for which types of columns?
- A: Non-nullable columns only
- B: All columns if NULL is allowed
- C: Primary key columns only
- D: Foreign key columns only
View Answer
B
Q455: Fill in the blank: The ____ clause specifies which table rows are used.
- A: SELECT
- B: FROM
- C: WHERE
- D: VALUES
View Answer
C
Q456: The AS keyword is used for which purpose in SQL?
- A: Create a new table
- B: Assign an alias to a column
- C: Sort the results of a query
- D: Specify conditions
View Answer
B
Q457: Which of the following is NOT a valid SQL clause?
- A: FROM
- B: UPDATE
- C: SELECT
- D: CREATE
View Answer
B
Q458: The SELECT DISTINCT statement is used to _____.
- A: Filter rows based on conditions
- B: Retrieve all rows
- C: Select only unique values
- D: Select only null values
View Answer
C
Q459: The query SELECT stName, prName FROM student; returns which data?
- A: Only student names
- B: Only program names
- C: Both student names and program names
- D: Only student IDs
View Answer
C
Q460: What is the format of the simplest SELECT statement?
- A: SELECT * FROM table_name
- B: SELECT DISTINCT FROM table_name
- C: SELECT WHERE table_name
- D: SELECT FROM VALUES
View Answer
A