Question

Match List I with List II:

LIST I	LIST II
A. Alter	I. Change the name of the column
B. Update	II. Update existing information in a table
C. Delete	III. Delete an existing row from table
D. Create	IV. Create a database

Choose the correct answer from the options given below:

• A. A-III, B-II, C-I, D-IV
• B. A-II, B-III, C-I, D-IV
• C. A-I, B-III, C-II, D-IV
• D. A-I, B-III, C-IV, D-II

Hint:

Match SQL commands based on their function keywords: alter (structure), update (data), delete (rows), create (objects).

Answer 1

The Correct Option is D

- ALTER is used to modify the structure of a table, such as renaming a column → I. - UPDATE is for changing values in existing records → III. - DELETE removes records (rows) from a table → IV. - CREATE initializes new objects like tables or databases → II.