Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q381: In which type of partitioning can only part of a table be replicated?
- A: Horizontal partitioning
- B: Vertical partitioning
- C: Both horizontal and vertical partitioning
- D: Neither
View Answer
B
Q382: Which sub-language of SQL is used to create and destroy database objects?
- A: DDL
- B: DML
- C: DQL
- D: TCL
View Answer
A
Q383: In SQL, user-defined identifiers are written in which case?
- A: Uppercase
- B: Lowercase
- C: Title Case
- D: Snake Case
View Answer
B
Q384: Which of the following is a rule for writing SQL commands?
- A: Reserved words are written in lowercase
- B: Identifiers can start with numbers
- C: Reserved words are written in capital letters
- D: Identifiers must always start with @
View Answer
C
Q385: Which data type is used for integer data with values from 0 to 255?
- A: Int
- B: Smallint
- C: Tinyint
- D: Bigint
View Answer
C
Q386: Which SQL command is used to retrieve data from a database?
- A: SELECT
- B: INSERT
- C: DELETE
- D: CREATE
View Answer
A
Q387: What does the "bit" data type in SQL represent?
- A: Text data
- B: Integer data with 0 or 1 values
- C: Decimal data
- D: Character data
View Answer
B
Q388: Which of the following is a variable-length text data type in SQL Server?
- A: Char
- B: Varchar
- C: Nchar
- D: Text
View Answer
B
Q389: What is the maximum length for an identifier in SQL?
- A: 64 characters
- B: 128 characters
- C: 256 characters
- D: 512 characters
View Answer
C
Q390: Which SQL command is used to modify data in a database?
- A: SELECT
- B: UPDATE
- C: DELETE
- D: INSERT
View Answer
B