Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q431: Which SQL command allows you to modify existing rows in a table?
- A: INSERT
- B: UPDATE
- C: DELETE
- D: SELECT
View Answer
B
Q432: The INSERT statement must follow specific rules, such as:
- A: Values must match data types
- B: Values can exceed column size
- C: Columns can be omitted
- D: Any values can be inserted
View Answer
A
Q433: What is the purpose of the DROP TABLE command in SQL?
- A: Add columns to a table
- B: Remove a table from the database
- C: Update records in a table
- D: Delete specific rows
View Answer
B
Q434: Which SQL statement is used to retrieve data from a database?
- A: INSERT
- B: DELETE
- C: UPDATE
- D: SELECT
View Answer
D
Q435: What is one of the principal characteristics of 4GLs like SQL?
- A: Non-procedural nature
- B: Focus on hardware
- C: Requires manual indexing
- D: Dependent on storage method
View Answer
A
Q436: What command is used to delete one or more records from a table in SQL?
- A: INSERT
- B: DELETE
- C: TRUNCATE
- D: UPDATE
View Answer
B
Q437: How does SQL handle the retrieval of data?
- A: It focuses on how to get data
- B: It requires manual storage management
- C: It specifies only what data is needed
- D: It relies on primary indices
View Answer
C
Q438: Which of the following commands is used to add a foreign key constraint?
- A: ALTER TABLE
- B: ADD CONSTRAINT
- C: DROP COLUMN
- D: DELETE
View Answer
A
Q439: When would you use the DROP COLUMN command in SQL?
- A: To delete a record
- B: To remove a column from a table
- C: To rename a table
- D: To update a record
View Answer
B
Q440: What is the purpose of the RENAME COLUMN statement?
- A: Change the type of a column
- B: Drop a column
- C: Change a column name
- D: Add a new column
View Answer
C