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. ALTER TABLE table_name ADD COLUMN column_name datatype;
D. ADD COLUMN TO table_name column_name datatype;
Answer: Option A
Solution (By JKSSB Mock Tests)
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.
Explanation:
Data Redundancy refers to the unnecessary duplication of the exact same data in multiple files or locations, which wastes storage and can cause inconsistencies.
Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.
No comments yet. Be the first to start the discussion!