What does DDL stand for in SQL? MCQ with Answer and Explanation

What does DDL stand for in SQL?
A. Data Description Language
B. Data Definition Language
C. Dynamic Data Link
D. Data Manipulation Language
Answer: Option B
Solution (By JKSSB Mock Tests)
DDL (Data Definition Language) includes commands like CREATE, ALTER, DROP for defining database structures.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which rule state that 'no component of a primary key can accept a NULL value'?
A. Referential Integrity Rule
B. Domain Constraint Rule
C. Entity Integrity Rule
D. Security Integrity Rule

Correct Answer: Option C


Explanation:
The Entity Integrity Rule states that a primary key column cannot contain NULL values, ensuring each row can be explicitly identified.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following is a benefit of DBMS?
A. Limited data access
B. Data sharing among multiple users
C. Higher data redundancy
D. Increased data inconsistency

Correct Answer: Option B


Explanation:
DBMS allows controlled data sharing while maintaining integrity and security.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The total number of attributes (columns) present in a relation determines its what?
A. Schema
B. Degree
C. Domain
D. Cardinality

Correct Answer: Option B


Explanation:
The number of attributes or columns in a relation is defined as the degree of that relation.

This question belongs to: Computer Database Management System (DBMS)