MySQL Database Quiz Questions

Course Name:MySQL

Chapter Name:Chapter 3 - Database Tables, Columns and Rows

Lesson Content Link:Database Table

Current Quiz Count:30

To gain complete access, login with gmail or outlook. click here

< Go back

Note: Please login to submit your answers.

0/0Score

Correct: 0

Wrong: 0

Progress

True / False

In MySQL, each table must have a primary key.

True False

While it is a good practice for each table to have a primary key, it is not mandatory in MySQL.

True / False

In MySQL, a table can have only one unique constraint.

True False

MySQL allows a table to have multiple unique constraints to ensure that the data in specified columns is unique.

True / False

In MySQL, the CREATE TABLE statement is used to create a new table in the database.

True False

The CREATE TABLE statement is the SQL command used to create a new table in a MySQL database.

True / False

In MySQL, a table can have multiple foreign keys.

True False

A MySQL table can have multiple foreign keys, each pointing to a primary key in another table, establishing relationships between tables.

True / False

In MySQL, the DROP TABLE statement can be used to remove a table along with its data.

True False

The DROP TABLE statement in MySQL permanently deletes a table and all its data from the database.

True / False

In MySQL, the ALTER TABLE statement can only be used to add columns to an existing table.

True False

The ALTER TABLE statement in MySQL can be used to add, modify, or drop columns, as well as to add or drop constraints on the table.

True / False

In MySQL, the TRUNCATE TABLE statement removes all rows from a table but retains the table structure for future use.

True False

The TRUNCATE TABLE statement in MySQL removes all rows from a table, effectively resetting it, but the table structure and its dependencies remain intact.

True / False

In MySQL, you can create a table with the same name as an existing table in the same database.

True False

In MySQL, table names must be unique within a database. You cannot create a table with a name that already exists in the same database.

True / False

In MySQL, you can use the PARTITION BY clause to create a partitioned table to manage large datasets more efficiently.

True False

MySQL supports table partitioning using the PARTITION BY clause, which allows for efficient management and querying of large datasets by dividing the table into smaller, more manageable pieces.

Q10

True / False

In MySQL, a table can have a maximum of 4096 columns.

True False

In MySQL, the maximum number of columns that a table can have is 1017. This is due to limitations in the underlying storage format and the data types used for columns.

Q11

Single Choice

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

CREATE TABLE ADD TABLE INSERT TABLENEW TABLE

The CREATE TABLE statement is used to create a new table in MySQL.

Q12

Single Choice

Which keyword is used to delete a table in MySQL?

REMOVE TABLE DELETE TABLE DROP TABLEERASE TABLE

The DROP TABLE statement is used to delete a table and its data from a MySQL database.

Q13

Single Choice

What is the correct SQL keyword to add a column to an existing table in MySQL?

INSERT ADD MODIFYALTER

The ALTER TABLE statement is used to add, delete, or modify columns in an existing MySQL table.

Q14

Single Choice

Which statement is used to change the structure of an existing table in MySQL?

CHANGE TABLE UPDATE TABLE ALTER TABLEMODIFY TABLE

The ALTER TABLE statement in MySQL is used to change the structure of an existing table, such as adding or dropping columns.

Q15

Single Choice

How do you ensure a column in a MySQL table will only accept unique values?

SET UNIQUE ADD CONSTRAINT UNIQUE UNIQUE KEYUNIQUE CONSTRAINT

The UNIQUE KEY constraint ensures that all values in a column are unique.

Q16

Single Choice

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

SET DEFAULT DEFAULT VALUE DEFAULTSET VALUE

The DEFAULT keyword is used to specify a default value for a column in MySQL.

Q17

Single Choice

Which of the following statements is used to rename a table in MySQL?

ALTER TABLE RENAME TO RENAME TABLE TO RENAME TOALTER TABLE RENAME

The ALTER TABLE RENAME statement is used to rename a table in MySQL.

Q18

Single Choice

In MySQL, what is the maximum number of columns a table can have?

256 512 10174096

In MySQL, the maximum number of columns that a table can have is 1017.

Q19

Single Choice

Which of the following commands is used to partition a table in MySQL?

PARTITION BY CREATE PARTITION ALTER PARTITIONADD PARTITION

The PARTITION BY clause is used in MySQL to partition a table for managing large datasets more efficiently.

Q20

Single Choice

What is the purpose of the FOREIGN KEY constraint in a MySQL table?

To ensure that the column values are unique To ensure that the column values are not NULL To establish a link between data in two tablesNone of the above

The FOREIGN KEY constraint is used to link records in two different tables, ensuring referential integrity between the tables.

Q21

Multiple Choice

Which of the following statements are used to create a new table in MySQL?

CREATE TABLE ADD TABLE UPDATE TABLENEW TABLE

The CREATE TABLE statement is the correct SQL command to create a new table in MySQL. The other options are incorrect.

Q22

Multiple Choice

Which of the following statements are true about primary keys in MySQL?

Each table must have a primary key Primary keys must be unique Primary keys can be NULLPrimary keys can consist of multiple columns

Primary keys must be unique and can consist of multiple columns (composite key). However, a table is not required to have a primary key, and primary keys cannot be NULL.

Q23

Multiple Choice

Which of the following are valid MySQL data types for creating table columns?

INT VARCHAR STRINGBOOLEAN

In MySQL, INT, VARCHAR, and BOOLEAN are valid data types. STRING is not a valid MySQL data type.

Q24

Multiple Choice

Which of the following statements can be used to modify an existing table in MySQL?

ALTER TABLE MODIFY TABLE UPDATE TABLECHANGE TABLE

The ALTER TABLE statement is used to modify the structure of an existing table. The other options are incorrect or not valid SQL syntax.

Q25

Multiple Choice

Which of the following constraints can be added to a MySQL table column?

NOT NULL UNIQUE DEFAULTCHECK

All listed constraints (NOT NULL, UNIQUE, DEFAULT, CHECK) can be applied to table columns in MySQL to enforce rules on the data.

Q26

Multiple Choice

What is the purpose of the FOREIGN KEY constraint in MySQL?

To ensure referential integrity between tables To enforce uniqueness of the column To link records in different tablesTo prevent NULL values in the column

The FOREIGN KEY constraint is used to ensure referential integrity between tables and to link records in different tables. It does not enforce uniqueness or prevent NULL values by itself.

Q27

Multiple Choice

Which of the following operations can be performed using the ALTER TABLE statement in MySQL?

Add a column Drop a column Rename a columnNone of the above

The ALTER TABLE statement can add, drop, and rename columns in an existing table. It cannot be used to delete data from the table.

Q28

Multiple Choice

Which of the following are true about partitioning tables in MySQL?

Partitioning can improve query performance Partitioning can only be done on numeric columns MySQL supports several partitioning methods, including RANGE and LISTPartitioned tables cannot have primary keys

Partitioning can improve query performance and MySQL supports several partitioning methods. Partitioning is not limited to numeric columns and partitioned tables can have primary keys.

Q29

Multiple Choice

In MySQL, which of the following are valid storage engines for tables?

InnoDB MyISAM CSVMemory

MySQL supports several storage engines, including InnoDB, MyISAM, CSV, and Memory, each with different characteristics and use cases.

Q30

Multiple Choice

Which of the following are true about MySQL table indexes?

Indexes can improve the speed of data retrieval Indexes slow down data insertion, updates, and deletions A table can have only one indexIndexes can be created on multiple columns

Indexes improve data retrieval speed but can slow down data insertion, updates, and deletions. A table can have multiple indexes, and indexes can be created on multiple columns.