Q1. When creating a part of a data model (such as creating a table) in a database, which category of SQL statement is used?

A. DML

B. DQL

C. DDL

D. DCL

Q2. In MySQL which of the following datatypes would allow 5.98 entered for a column?

A. INT

B. FLOAT(2,2)

C. DECIMAL(2,2)

D. DECIMAL(8,2)

E. FLOAT(8,0)

Q3. A "ONE-TO-ONE" relationship (optional or mandatory) can be enforced within the database by setting the Foreign Key to have which property?

A. UNIQUE

B. NOT NULL

C. ZERO FILLED

D. NULL

Q4. Which best describes a column with the CHAR(n) datatype in MySQL

A. The column stores strings of exactly "n" characters, right padded with spaces if needed, using a constant "n" bytes of disk storage to do so.

B. The column stores strings of length less than or equal to "n" characters using a constant "n" bytes of disk storage to do so.

C. The column stores strings of length less than or equal to "n" characters using a variable number of the bytes of disk storage to do so.

D. The column stores strings of exactly "n" characters, right padded with spaces if needed, using a variable number of the bytes of disk storage to do so.

Q5. When inserting data into a database, which category of SQL statement is used

A. DML

B. DQL

C. DDL

D. DCL