CBSE Class 12 Informatics Practices Question 79 of 103

Review of Database Concepts & SQL — Question 28

Back to all questions
28
Question

Question 17

Match the following clauses with their respective functions.

Column 1Column 2
ALTERInsert the values in a 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