MySQL -Grade 8 Revision

Which of the following fields is not suitable for a primary key?

• An autonumber field

• A student's registration number

• Bank account number

• Date of birth

RDBMS is an acronym for______

Every table should have one ___________ key.

The _____________ datatype can have year, month, day, hour, minute, and second values.

DCL stands for __________________.

List down the commands available in MySQL.

List down the commands that come under DML.

• Create,Alter,Drop

• Insert,Update,Delete

• Grant,Revoke

• Select

List down the commands that come under DDL.

• Create,Alter,Drop

• Insert,Update,Delete

• Grant,Revoke

• Select

Write the names of the field that contain numeric data.

• Product,Date of sales,qtysold,Amount

• Date of sales,qtysold,Amount

• qtysold and Amount

• Product name

Identify the primary key field in the database.

• Product code

• Date of sales,qtysold,Amount

• qtysold and Amount

• Product name