MySQL Multiple Choice Questions (MCQ) Online Test #18

MySQL MCQ #171:

Which SQL command is used to remove all rows from a table without deleting the table itself?

DELETE

REMOVE

DROP

TRUNCATE

About MySQL Multiple Choice Question (MCQ) #171:
This ICT Multiple Choice Question (ICT MCQ) #171 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the knowledge of the SQL command used to remove all rows from a table without deleting the table itself.

MySQL MCQ #172:

What is the purpose of the UNION operator in MySQL?

To join multiple tables into a single table

To combine the results of two or more SELECT queries into a single result set

To update multiple records in a table

To delete records from multiple tables

About MySQL Multiple Choice Question (MCQ) #172:
This ICT Multiple Choice Question (ICT MCQ) #172 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the understanding of the purpose of the UNION operator in MySQL.

MySQL MCQ #173:

What does the DISTINCT keyword do in a MySQL query?

Removes duplicate rows from the result set

Sorts the result set in ascending order

Groups rows with similar values

Limits the number of rows returned

About MySQL Multiple Choice Question (MCQ) #173:
This ICT Multiple Choice Question (ICT MCQ) #173 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the understanding of the function of the DISTINCT keyword in a MySQL query.

MySQL MCQ #174:

What is the purpose of the INDEX keyword in MySQL?

To back up a table's data

To encrypt data in a table

To compress the data in a table

To create a data structure that improves the speed of data retrieval

About MySQL Multiple Choice Question (MCQ) #174:
This ICT Multiple Choice Question (ICT MCQ) #174 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the knowledge of the purpose of the INDEX keyword in MySQL.

MySQL MCQ #175:

How does the JOIN clause differ from the UNION operator in MySQL?

JOIN combines rows from multiple tables, while UNION creates a new table

JOIN combines columns from multiple tables, while UNION combines rows from multiple SELECT queries

JOIN modifies existing tables, while UNION creates new tables

JOIN filters data, while UNION sorts data

About MySQL Multiple Choice Question (MCQ) #175:
This ICT Multiple Choice Question (ICT MCQ) #175 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the understanding of how the JOIN clause differs from the UNION operator in MySQL.

MySQL MCQ #176:

What is the function of the HAVING clause in MySQL?

To sort the results of a query

To filter records after grouping by a specified column

To join multiple tables

To create new records in a table

About MySQL Multiple Choice Question (MCQ) #176:
This ICT Multiple Choice Question (ICT MCQ) #176 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the knowledge of the function of the HAVING clause in MySQL.

MySQL MCQ #177:

What does the LIMIT clause do in a MySQL query?

Restricts the number of rows returned by the query

Sorts the results of the query

Joins multiple tables

Groups rows with similar values

About MySQL Multiple Choice Question (MCQ) #177:
This ICT Multiple Choice Question (ICT MCQ) #177 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the understanding of the purpose of the LIMIT clause in a MySQL query.

MySQL MCQ #178:

What is the AUTO_INCREMENT attribute used for in MySQL?

To delete records from a table

To increase the size of a table

To backup a column's data

To automatically generate unique values for a column

About MySQL Multiple Choice Question (MCQ) #178:
This ICT Multiple Choice Question (ICT MCQ) #178 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the knowledge of the AUTO_INCREMENT attribute in MySQL.

MySQL MCQ #179:

Which MySQL function is used to retrieve the current date and time?

CURRENT_TIMESTAMP()

DATE()

TIME()

NOW()

About MySQL Multiple Choice Question (MCQ) #179:
This ICT Multiple Choice Question (ICT MCQ) #179 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the understanding of which MySQL function retrieves the current date and time.

MySQL MCQ #180:

What does the SHOW TABLES command do in MySQL?

Deletes a table from the database

Displays the structure of a table

Lists all the tables in the current database

Creates a new table in the database

About MySQL Multiple Choice Question (MCQ) #180:
This ICT Multiple Choice Question (ICT MCQ) #180 focuses on MySQL within the "Intermediate ICT MCQ" category. This question tests the knowledge of what the SHOW TABLES command does in MySQL.

This page was last modified on Dec 30, 2024 by ICT MCQ Hub.

< Previous Next >

MySQL Multiple Choice Questions (MCQ) Online Test #18

Find Your Next MCQ Challenge!

Sharpen Your Skills with More Tests!