MySQL revision tour

Which command is used to open an existing database?

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.

DML commands are:-

• INSERT

• UPDATE

• DELETE

• GRANT

TCL commands are:-

• DEFAULT

• GRANT

• REVOKE

• ROLLBACK

DDL commands are:-

• UPDATE

• CREATE

• DROP

• DELETE

Pattered matching in SELECT command can be done using:-

• @

• &

• _

• %

Examples of DBMS software are:-

• MySQL

• ORACLE

• JAVA

• FOXPRO