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. UPDATE
B. CHANGE
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 is NOT an advantage of DBMS over traditional file systems?
A. Data independence
B. Data redundancy control
C. Simpler implementation and lower cost
D. Higher data security

Correct Answer: Option C


Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a subquery in SQL?
A. A query that returns multiple results
B. A query nested inside another query
C. A query that is used to create a table
D. A query that is always correlated

Correct Answer: Option B


Explanation:
A subquery is a SELECT statement nested within another SQL statement (e.g., SELECT, INSERT, UPDATE, DELETE).

This question belongs to: Computer Database Management System (DBMS)
Question #3
In SQL, which clause is used to specify the table(s) from which to retrieve data?
A. GROUP BY
B. SELECT
C. WHERE
D. FROM

Correct Answer: Option D


Explanation:
The FROM clause identifies the table(s) from which data is to be selected.

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