SQL Commands -Pretest

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

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 ‘.

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

select all DDL commands are:-

• UPDATE

• ALTER

• DROP

• DELETE

Examples of DBMS software are:-

• MySQL

• ORACLE

• JAVA

• FOXPRO

Write SQL command to create the given table.