Which of the following commands is used to modify the structure of an existing table, such as adding or deleting a column? MCQ with Answer and Explanation

Question
Which of the following commands is used to modify the structure of an existing table, such as adding or deleting a column?
A. MODIFY
B. UPDATE
C. CHANGE
D. ALTER
Answer: Option D
Solution (By JKSSB Mock Tests)
The ALTER command is part of DDL and is used to modify the schema or structural definition of an existing database object like a table.
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
To be in Second Normal Form (2NF), a relation must already satisfy First Normal Form (1NF) and must completely eliminate what type of dependency?
A. Transitive Dependency
B. Multivalued Dependency
C. Functional Dependency
D. Partial Dependency
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Second Normal Form (2NF) requires that the table is in 1NF and that no non-prime attribute is partially dependent on any candidate key (meaning no partial dependency exists).
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which SQL statement is used to retrieve data from a database?
A. SELECT
B. UPDATE
C. INSERT
D. DELETE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SELECT is the SQL command used to query and retrieve data from one or more tables.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the meaning of the term 'redundancy' in databases?
A. Lack of data
B. Data in multiple tables
C. Duplicate storage of the same data
D. Inconsistent data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Redundancy refers to the unnecessary duplication of data, which can lead to anomalies and wasted storage.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Cyber Security 269 Database Management System (DBMS) 278 Computer Abbreviations 369 Computer Fundamentals 326 Computer Software 347
Explore Subjects
Accountancy and Statistics 3179 Economy GK 2220 English 15164 Computer 5279 Current Affairs 575
Practice Mix
Which of the following is an indirect tax in India?
The valve between the left atrium and left ventricle is the:
A person faces north. He turns 45° left, then 90° right, then 45° left. Which direction is he facing?
Under the Income Tax Act, the 'TDS' on the sale of an immovable property (other than agricultural land) by a resident is governed by which section, and what is the rate?
In 'Piecemeal Distribution' during dissolution, the first priority for payment of outside liabilities is: