MySQL Database Quiz Questions

Course Name:MySQL

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

Lesson Content Link:ROWs and COLUMNs

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

Multiple Choice

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

VARCHAR INT BOOLEANDATE

MySQL supports various data types for columns, including VARCHAR for strings, INT for integers, BOOLEAN for true/false values, and DATE for date values.

Multiple Choice

Which statement is used to retrieve rows from a MySQL table?

SELECT FETCH RETRIEVEGET

The SELECT statement is used to retrieve rows from a table in MySQL.

Multiple Choice

Which of the following are valid MySQL column constraints?

PRIMARY KEY NOT NULL UNIQUEDEFAULT

MySQL supports several column constraints, including PRIMARY KEY, NOT NULL, UNIQUE, and DEFAULT, to enforce rules on data.

Multiple Choice

How can you insert multiple rows into a MySQL table in a single query?

Using multiple INSERT statements Using a single INSERT statement with multiple VALUES clauses Using INSERT INTO ... SELECT statementUsing a loop structure

In MySQL, multiple rows can be inserted using a single INSERT statement with multiple VALUES clauses or using an INSERT INTO ... SELECT statement to insert rows from another table.

Multiple Choice

Which functions can be used to manipulate column values in MySQL?

CONCAT() LOWER() UPPER()SUBSTRING()

MySQL provides various functions to manipulate column values, such as CONCAT() for string concatenation, LOWER() and UPPER() for case conversion, and SUBSTRING() for extracting substrings.

Multiple Choice

Which clauses can be used to filter rows in a MySQL query?

WHERE HAVING GROUP BYORDER BY

The WHERE clause is used to filter rows based on conditions before grouping, and the HAVING clause is used to filter groups of rows after aggregation in MySQL.

Multiple Choice

Which statements can be used to update rows in a MySQL table?

UPDATE MODIFY REPLACEMERGE

The UPDATE statement is used to modify existing rows in a table, and the REPLACE statement can be used to insert or replace rows in MySQL.

Multiple Choice

Which keywords are used to define relationships between columns in different MySQL tables?

FOREIGN KEY REFERENCES JOINON DELETE CASCADE

FOREIGN KEY and REFERENCES are used to define relationships between columns in different tables, and ON DELETE CASCADE specifies the behavior when a related row is deleted.

Multiple Choice

How can you retrieve a specific number of rows from a MySQL table?

LIMIT TOP FETCH FIRSTOFFSET

The LIMIT clause is used to specify the number of rows to retrieve, and OFFSET can be used to skip a specific number of rows in MySQL.

Q10

Multiple Choice

Which MySQL index types can be used to improve the performance of queries on columns?

PRIMARY KEY UNIQUE FULLTEXTSPATIAL

MySQL supports various index types such as PRIMARY KEY, UNIQUE for unique column values, FULLTEXT for text searching, and SPATIAL for spatial data types to improve query performance.

Q11

Single Choice

What is the maximum length of a VARCHAR column in MySQL?

255 65535 327671024

In MySQL, a VARCHAR column can store up to 65,535 characters.

Q12

Single Choice

Which MySQL statement is used to insert a new row into a table?

INSERT INTO UPDATE SELECTDELETE

The INSERT INTO statement is used to add a new row to a table in MySQL.

Q13

Single Choice

What keyword is used to select all columns from a table in MySQL?

* ALL EACHNull

In MySQL, the asterisk (*) is used to select all columns from a table.

Q14

Single Choice

How can you add a new column to an existing table in MySQL?

ADD COLUMN INSERT COLUMN NEW COLUMNALTER COLUMN

The ADD COLUMN clause of the ALTER TABLE statement is used to add a new column to an existing table in MySQL.

Q15

Single Choice

Which function is used to get the number of rows in a table in MySQL?

COUNT() VARCHAR BLOBCSV

The COUNT() function in MySQL is used to get the number of rows in a table or result set.

Q16

Single Choice

What is the maximum number of rows a MySQL table can have?

2^32 2^64 Unlimited1,000,000,000

A MySQL table can have a maximum of 2^64 rows, which is a very large number, effectively making it almost unlimited for practical purposes.

Q17

Single Choice

In MySQL, which storage engine supports row-level locking?

MyISAM InnoDB MEMORYCSV

The InnoDB storage engine supports row-level locking, which allows for better concurrency and performance in multi-user environments.

Q18

Single Choice

Which MySQL statement is used to modify the data of an existing row?

INSERT INTO UPDATE ALTERCHANGE

The UPDATE statement in MySQL is used to modify the data of an existing row in a table.

Q19

Single Choice

What is the purpose of the AUTO_INCREMENT attribute in MySQL?

Automatically increases the column width Automatically generates a unique value for each row Automatically sorts the rowsAutomatically creates an index

The AUTO_INCREMENT attribute in MySQL is used to generate a unique value for each row, typically used for primary keys.

Q20

Single Choice

Which MySQL command is used to delete specific rows from a table based on a condition?

DROP DELETE REMOVETRUNCATE

The DELETE command in MySQL is used to remove specific rows from a table based on a condition provided in the WHERE clause.

Q21

True / False

In MySQL, a row is also known as a record.

True False

In MySQL, a row represents a single record in a table.

Q22

True / False

In MySQL, a column is also referred to as a field.

True False

In MySQL, a column is an individual data element within a record, and it is often referred to as a field.

Q23

True / False

In MySQL, the ORDER BY clause can only sort rows in ascending order.

True False

In MySQL, the ORDER BY clause can sort rows in both ascending (ASC) and descending (DESC) order.

Q24

True / False

In MySQL, each column in a table must have a unique name.

True False

Each column in a MySQL table must have a unique name to avoid ambiguity when querying the table.

Q25

True / False

In MySQL, the ALTER TABLE statement can be used to add a new row to an existing table.

True False

The ALTER TABLE statement is used to modify the structure of a table, such as adding or deleting columns, not rows. To add a new row, the INSERT INTO statement is used.

Q26

True / False

In MySQL, the SELECT statement is used to retrieve specific columns from a table.

True False

The SELECT statement in MySQL is used to retrieve specific columns from a table by specifying the column names after the SELECT keyword.

Q27

True / False

In MySQL, the HAVING clause is used to filter rows after the GROUP BY clause has been applied.

True False

The HAVING clause in MySQL is used to filter groups of rows that meet a certain condition, and it is applied after the GROUP BY clause.

Q28

True / False

In MySQL, you can use subqueries to select columns from multiple rows in another table.

True False

In MySQL, subqueries can be used within a SELECT statement to retrieve columns from multiple rows in another table.

Q29

True / False

In MySQL, a column with a UNIQUE constraint can have multiple NULL values.

True False

In MySQL, a column with a UNIQUE constraint can have multiple NULL values because NULL is not considered equal to any other value, including another NULL.

Q30

True / False

In MySQL, the ROW_NUMBER() function assigns a unique sequential integer to rows within a result set.

True False

In MySQL, the ROW_NUMBER() window function assigns a unique sequential integer to rows within a partition of a result set, which can be useful for various ranking and sorting tasks.