Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q401: In SQL, which command is used to create a database?
- A: CREATE DATABASE
- B: CREATE DB
- C: DB_CREATE
- D: NEW DB
View Answer
A
Q402: Which of the following is a constraint that ensures a column cannot contain a NULL value?
- A: CHECK
- B: UNIQUE
- C: NOT NULL
- D: DEFAULT
View Answer
C
Q403: What is the primary use of the CREATE command in SQL?
- A: To create a new database
- B: To retrieve data from a table
- C: To update data in a table
- D: To delete a database
View Answer
A
Q404: The SQL command to define the schema of a relation is part of which SQL sublanguage?
- A: DML
- B: DCL
- C: DDL
- D: TCL
View Answer
C
Q405: Which constraint enforces that no duplicate values are allowed in a column?
- A: PRIMARY KEY
- B: NOT NULL
- C: UNIQUE
- D: FOREIGN KEY
View Answer
C
Q406: What does the "ON DELETE CASCADE" clause in SQL do?
- A: Deletes all data from the table
- B: Deletes the entire table when a row is deleted
- C: Deletes related rows in another table
- D: Prevents any delete operation
View Answer
C
Q407: Which of the following commands is non-transactional in SQL?
- A: CREATE
- B: INSERT
- C: UPDATE
- D: SELECT
View Answer
A
Q408: What does the following SQL command do? CREATE TABLE Student (stId char(5), stName char(25))
- A: Creates a new table with two columns
- B: Updates the "Student" table with new columns
- C: Deletes the "Student" table
- D: Renames the "Student" table
View Answer
A
Q409: What is the maximum allowed length of an identifier in SQL?
- A: 128 characters
- B: 256 characters
- C: 512 characters
- D: 1024 characters
View Answer
B
Q410: Which data type is used to store large textual data in SQL Server?
- A: VARCHAR
- B: TEXT
- C: CHAR
- D: TINYINT
View Answer
B