Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q391: What type of DML allows users to specify what data is needed and how to get it?
- A: Procedural DML
- B: Non-procedural DML
- C: Declarative DML
- D: Transactional DML
View Answer
A
Q392: Which statement is used to remove data from a table in SQL?
- A: UPDATE
- B: DELETE
- C: SELECT
- D: INSERT
View Answer
B
Q393: What is the role of DDL in SQL?
- A: To manipulate data
- B: To define the structure of a database
- C: To control access to the database
- D: To query data from a table
View Answer
B
Q394: What type of SQL command is "GRANT"?
- A: DDL
- B: DML
- C: DCL
- D: TCL
View Answer
C
Q395: Which SQL data type is used to handle monetary values?
- A: Char
- B: Varchar
- C: Money
- D: Bit
View Answer
C
Q396: What does DML stand for in SQL?
- A: Data Modification Language
- B: Data Manipulation Language
- C: Data Management Language
- D: Data Modeling Language
View Answer
B
Q397: Which SQL sub-language is used for inserting, updating, and deleting data?
- A: DDL
- B: DML
- C: DCL
- D: TCL
View Answer
B
Q398: What is the purpose of the SELECT command in SQL?
- A: To modify data in a table
- B: To retrieve data from a database
- C: To delete data from a table
- D: To insert data into a table
View Answer
B
Q399: What does DDL stand for in SQL?
- A: Data Definition Language
- B: Data Development Language
- C: Data Descriptive Language
- D: Data Derivation Language
View Answer
A
Q400: Which of the following is NOT a command in DDL?
- A: CREATE
- B: SELECT
- C: DROP
- D: ALTER
View Answer
B