MySQL Practice

Which command is used to open an existing database?

Command to view structure of the table named ‘STUDENT ‘.

Command to view structure of the table named ‘STUDENT ‘.

A key which allows unique or null values.

• Unique

• Null key

• Primary key

• Alternate key

To destroy the table named ‘STUDENT ‘.

Delete * from empl;

• Deletes all tuples.

• updates the table emp with null.

• Destroys the table.

TCL commands are:-

• DEFAULT

• GRANT

• REVOKE

• ROLLBACK

Pattered matching in SELECT command can be done using:-

• @

• &

• _

• %

Examples of DBMS software are:-

• MySQL

• ORACLE

• JAVA

• FOXPRO