Revision 1 ( Basic SQL)

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

Less than or equal to?

• >=

• =>

• =<

• <=

What does the ALTER TABLE clause do?

• The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

• The SQL ALTER TABLE clause is used to insert data into database table

• THE SQL ALTER TABLE deletes data from database table

• The SQL ALTER TABLE clause is used to delete a database table

DDL means

Where does the CREATE Command belong?

• DML

• DDL

• DCL

Which command is used for removing a table and all its data from the database:

• Create command

• Drop table command

• Alter table command

• All of the mentioned

Correct syntax query syntax to drop a column from a table is

• DELETE COLUMN column_name;

• DROP COLUMN column_name;

• ALTER TABLE table_name DROP COLUMN column_name;

• None is correct.

Which is not a DDL Command?

• CREATE

• ALTER

• DROP

• UPDATE

Which clause of Alter command can change the size of the Column?

• ADD

• MODIFY

• CHANGE

• COLUMN SIZE

Which command will delete all the records of table with its structure?

• Delete Table <Table Name>;

• Drop Table;

• Drop Table <Table Name>;

• Drop <Table Name>;