S2_NIGHT CLASS

Which SQL keyword is used to create a new database in MySQL?

• CREATE

• MAKE

• NEW

• DATABASE

Which statement is used to create a new table in MySQL?

• CREATE TABLE

• ADD TABLE

• INSERT TABLE

• MAKE TABLE

Which data type would you use to store a date in MySQL?

• INT

• VARCHAR

• DATE

• FLOAT

To define a primary key in MySQL, you would use which constraint?

• PRIMARY KEY

• UNIQUE

• INDEX

• CONSTRAINT

Which clause is used to specify a foreign key constraint in MySQL?

• FOREIGN KEY

• CONSTRAINT

• REFERENCES

• FOREIGN CONSTRAINT

In MySQL, which relationship type ensures that a foreign key can be NULL?

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

Which keyword is used to remove a table in MySQL?

• REMOVE TABLE

• DROP TABLE

• DELETE TABLE

• REMOVE

Which clause is used to specify the data type and length of a column in MySQL?

• TYPE

• LENGTH

• SIZE

• VARCHAR

In MySQL, which type of relationship exists when each row in one table has one related row in another table?

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

Which keyword is used to specify the default value for a column in MySQL? _______