Which SQL command is used to modify the structure of an existing table? MCQ with Answer and Explanation

Which SQL command is used to modify the structure of an existing table?
A. CHANGE
B. UPDATE
C. ALTER
D. MODIFY
Answer: Option C
Solution (By JKSSB Mock Tests)
ALTER TABLE is a DDL command used to add, delete, or modify columns and constraints in an existing table.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following represents raw, unorganized, and unprocessed facts that lack contextual meaning?
A. Information
B. Knowledge
C. Metadata
D. Data

Correct Answer: Option D


Explanation:
Data refers to raw, unorganized, and unprocessed facts, figures, or symbols that do not convey a specific meaning on their own. When data is processed and organized, it becomes information.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which schema architecture level describes how the data is physically stored on disk storage media?
A. Conceptual Level
B. Logical Level
C. External Level
D. Internal Level

Correct Answer: Option D


Explanation:
The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a purpose of a database management system?
A. All of the above
B. To define and create databases
C. To manipulate data
D. To control access to data

Correct Answer: Option A


Explanation:
A DBMS provides functionalities for defining, constructing, manipulating, and controlling access to databases.

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