Mysql revision

Name the command that will display the structure of table.

• Select

• Describe

• Alter

• Update

Char data type is of a fixed length.

• True

• False

A table FLIGHT has 4 rows and 2 columns. What is the degree of the table?

• 4

• 42

• 2

• 24

What is the command that will open an already existing database "Games"?

• Use games;

• Select * from games;

• Open games;

• Insert into games;

Name the key that has the ability to become a primary key.

• Candidate key

• Transaction key

• Foreign key

• Alternate key

Update command will modify the structure of a table.

• True

• False

Abhay wants to remove the entire content of a table "BOOKS" along with its structure. What command is to be used?

• Delete from books;

• Drop books;

• Drop table books;

• Remove books;

Which operator performs pattern matching?

• between

• in

• and

• like

The FROM clause is used to -

• specify what table we are selecting or deleting data from

• specify range for search condition

• specifies which database we have to search in

• None of these

Which keyword will sort a result set?

• Order

• order by

• sort

• sort by