Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q441: Which SQL statement is used to change data in a table?
- A: INSERT
- B: SELECT
- C: UPDATE
- D: DELETE
View Answer
C
Q442: What does the INSERT...SELECT statement do?
- A: Inserts a single row
- B: Joins tables and inserts rows based on SELECT
- C: Deletes rows from one table
- D: Creates a new table
View Answer
B
Q443: Which command is procedural in SQL DML?
- A: SELECT
- B: UPDATE
- C: INSERT
- D: Both A and C
View Answer
D
Q444: What is the main purpose of SQL's DELETE statement?
- A: Insert rows
- B: Delete rows conditionally
- C: Update rows
- D: Add a column
View Answer
B
Q445: What does the INSERT INTO statement do?
- A: Deletes records from a table
- B: Updates records in a table
- C: Inserts records into a table
- D: Joins two tables
View Answer
C
Q446: How many formats does the INSERT INTO statement have?
- A: One
- B: Two
- C: Three
- D: Four
View Answer
B
Q447: What does the VALUES clause in an INSERT statement specify?
- A: Table name
- B: Query name
- C: Values to place in columns
- D: Attribute name
View Answer
C
Q448: Which clause is used to retrieve data from a table in SQL?
- A: INSERT
- B: DELETE
- C: SELECT
- D: UPDATE
View Answer
C
Q449: The basic SELECT statement has how many clauses?
- A: One
- B: Two
- C: Three
- D: Four
View Answer
C
Q450: What is the purpose of the WHERE clause in an SQL SELECT statement?
- A: To specify which columns are retrieved
- B: To filter rows based on a condition
- C: To specify the table being queried
- D: To list table columns
View Answer
B