SQL command used to add a new column in an existing table is :
एक मौजूदा टेबल में एक नया कॉलम जोड़ने के लिए प्रयुक्त SQL कमांड है :
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. ALTER
Explanation
ALTER TABLE ... ADD column_name datatype adds a new column. UPDATE changes values in rows, it does not change the structure.
ALTER TABLE ... ADD कॉलम_नाम डेटाटाइप से नया कॉलम जुड़ता है। UPDATE केवल पंक्तियों के मान बदलता है।
More Database Management & SQL questions
- In context of deadlock prevention in DBMS, wait-die and wound-wait schemes are ........ techniques.
- In context of databases consider set operations on relation R and S, and select a true statement :
- In context of 2-phase locking protocol in DBMS, a transaction issues lock requests in ......... phase and unlock requests in ........ phase.
- Choose the SQL commands to perform following operations on a relation R : I : Retain Relation R in database, but delete all tuples in R. II…
- If the following functional dependencies holds on a selection R : A → B, A → C, BC → D, C → F, B → E, then which of the following dependenc…
- The ........... of weak entity set distinguishes among all those entities in the weak entity set that depends upon one particular strong en…