SQL Commands Part 1

An SQL command used to add record in a table.

• Insert

• Create

• Update

• Add

It is a DML command that is used to display record.

• DISPLAY

• STRUCTURE

• WHERE

• SELECT

This symbol is placed immediately after the SELECT command to display all the fields.

• $

• %

• =

• *

What is the meaning of DDL?

• Data Definition Language

• Database definition Language

• Data Definition Link

• Data Division Langauge

What is the commands that maintain and query a database

• DCL

• DDL

• DML

• SQL

The _____ command is used to modify columns in a table

• DROP

• INSERT

• ALTER

• CREATE

The _____ command is used to completely remove a table from the database.

• INSERT

• ALTER

• DROP

• CREATE

_________________ SQL command to view structure of the table named ‘STUDENT ‘.

A key which allows unique or null values.

• Unique

• Null key

• Primary key

• Alternate key

_________________ SQL command used to destroy the table named ‘STUDENT ‘.