CBSE Class 11 Informatics Practices Question 59 of 87

Structured Query Language (SQL) — Question 20

Back to all questions
20
Question

Question 14

Match the following clauses with their respective functions.

ALTERInsert the values in the table
UPDATERestrictions on columns
DELETETable definition
INSERT INTOChange the name of a column
CONSTRAINTSUpdate existing information in a table
DESCRIBEDelete an existing row from a table
CREATECreate a database
Answer
Column 1Column 2
ALTERChange the name of a column
UPDATEUpdate existing information in a table
DELETEDelete an existing row from a table
INSERT INTOInsert the values in a table
CONSTRAINTSRestrictions on columns
DESCRIBETable definition
CREATECreate a database