Which language is used to define the structure of a database, such as creating tables and constraints? MCQ with Answer and Explanation

Question

Share Report Error

Which language is used to define the structure of a database, such as creating tables and constraints?

A. TCL

B. DDL

C. DML

D. DCL

Answer: Option B

Solution (By JKSSB Mock Tests)

Data Definition Language (DDL) is used to define and modify the database schema, including CREATE, ALTER, and DROP statements.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

Which of the following is a valid SQL statement to add a new column to a table?

A. Both A and C

B. ALTER TABLE table_name ADD column_name datatype;

C. ADD COLUMN TO table_name column_name datatype;

D. ALTER TABLE table_name ADD COLUMN column_name datatype;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.

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

Question #2

Share Report

What is a tuple in a relational database?

A. A relationship between tables

B. A single row in a table

C. A single column in a table

D. The name of the table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In RDBMS, a tuple represents a single row or record in a relation (table).

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

Question #3

Share Report

Which of the following is a type of database backup?

A. Incremental backup

B. Full backup

C. Differential backup

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Full, incremental, and differential backups are common backup strategies.

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

Explore All Database Management System (DBMS) MCQs