Class-11th IP Ch-8 SQL Commands

choose the correct option: The command used to delete a particular column in a relation is ----------------

• UPDATE TABLE

• TRUNCATE COLUMN

• COLUMN DROP

• DELETE COLUMN

What is the full from of DDL?

• Dynamic data language

• Detailed data language

• Data definition language

• Data derivation language

Which statement in SQL allows us to change the definition of a table is?

• ALTER

• UPDATE

• CREATE

• SELECT

In SQL which commands is used to SELECT only one copy of each set of duplicable.

• SELECT DISTINCT

• SELECT UNIQE

• SELECT DIFFERENT

• All of the mentioned

A command that lest you change one or more fields in a record is:

• Insert

• modify

• Look up

• All of the mentioned

Which datatype can store unstructured data in a column?

• CHAR

• RAW

• UMERIC

• VARCHAR

Which command is used to change the definition of a table in SQL?

• CREATE

• UPDATE

• ALTER

• SELECT

Which of the following SQL commands can be used to add data to database table?

• ADD

• UPDATE

• APPEND

• INSERT

Which of the following SQL commands is used to retrieve data?

• DELETE

• INSERT

• SELECT

• JOIN

Which SQL statements is used to delete from a database?

• COLLAPSE

• REMOVE

• ALETER

• DELETE