Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 24
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
Correct Answer:
B
Chapter: 25
Q382:
Which sub-language of SQL is used to create and destroy database objects?
A. DDL
B. DML
C. DQL
D. TCL
Correct Answer:
A
Chapter: 25
Q383:
In SQL, user-defined identifiers are written in which case?
A. Uppercase
B. Lowercase
C. Title Case
D. Snake Case
Correct Answer:
B
Chapter: 25
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 @
Correct Answer:
C
Chapter: 25
Q385:
Which data type is used for integer data with values from 0 to 255?
A. Int
B. Smallint
C. Tinyint
D. Bigint
Correct Answer:
C
Chapter: 25
Q386:
Which SQL command is used to retrieve data from a database?
A. SELECT
B. INSERT
C. DELETE
D. CREATE
Correct Answer:
A
Chapter: 25
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
Correct Answer:
B
Chapter: 25
Q388:
Which of the following is a variable-length text data type in SQL Server?
A. Char
B. Varchar
C. Nchar
D. Text
Correct Answer:
B
Chapter: 25
Q389:
What is the maximum length for an identifier in SQL?
A. 64 characters
B. 128 characters
C. 256 characters
D. 512 characters
Correct Answer:
C
Chapter: 25
Q390:
Which SQL command is used to modify data in a database?
A. SELECT
B. UPDATE
C. DELETE
D. INSERT
Correct Answer:
B
Chapter: 25
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
Correct Answer:
A
Chapter: 25
Q392:
Which statement is used to remove data from a table in SQL?
A. UPDATE
B. DELETE
C. SELECT
D. INSERT
Correct Answer:
B
Chapter: 25
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
Correct Answer:
B
Chapter: 25
Q394:
What type of SQL command is "GRANT"?
A. DDL
B. DML
C. DCL
D. TCL
Correct Answer:
C
Chapter: 25
Q395:
Which SQL data type is used to handle monetary values?
A. Char
B. Varchar
C. Money
D. Bit
Correct Answer:
C
Chapter: 25
Q396:
What does DML stand for in SQL?
A. Data Modification Language
B. Data Manipulation Language
C. Data Management Language
D. Data Modeling Language
Correct Answer:
B
Chapter: 25
Q397:
Which SQL sub-language is used for inserting, updating, and deleting data?
A. DDL
B. DML
C. DCL
D. TCL
Correct Answer:
B
Chapter: 25
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
Correct Answer:
B
Chapter: 26
Q399:
What does DDL stand for in SQL?
A. Data Definition Language
B. Data Development Language
C. Data Descriptive Language
D. Data Derivation Language
Correct Answer:
A
Chapter: 26
Q400:
Which of the following is NOT a command in DDL?
A. CREATE
B. SELECT
C. DROP
D. ALTER
Correct Answer:
B