What does the GROUP BY clause do in MySQL?

Groups rows based on a specific column

In MySQL, what does the ROLLBACK command do?

Cancels the current transaction

Commits the current transaction

Which of the following is true about Cursors in MySQL?

They are used to iterate over result sets row by row

They automatically close when the SELECT query finishes

They are used to update multiple rows in a table simultaneously

They are not supported in MySQL

Which of the following is the correct syntax to create an index on a column in MySQL?

CREATE INDEX idx_name ON table_name (column_name);

CREATE INDEX (column_name) ON table_name;

INDEX idx_name ON table_name (column_name);

CREATE COLUMN INDEX ON table_name (column_name);

What is the purpose of the DISTINCT keyword in a SELECT query?

To eliminate duplicate rows from the result

To remove NULL values from the result

To sort the result in ascending order

To group the result based on columns

Which of the following is a correct property of a transaction in MySQL that follows the ACID principles?

It can be committed or rolled back after execution

It can only be rolled back, not committed

It runs in a single query and doesn't need commit or rollback

It doesn't guarantee data consistency

What happens when you try to insert a record that violates a unique constraint on a column in MySQL?

The record is rejected and an error is thrown

The record is inserted with a warning

The record is inserted but the unique constraint is ignored

The record is automatically modified to make the value unique

In MySQL, how does a CROSS JOIN behave when applied to two tables?

It combines each row of the first table with every row of the second table

It combines rows that have matching values in specified columns

It returns rows from the first table where no matching row exists in the second table

It only returns rows where the join condition is true

Which of the following options would improve performance when running queries on large tables in MySQL?

Optimizing queries by reducing the number of subqueries

Using GROUP BY with an unindexed column

Using SELECT * to retrieve all columns from a table

What is the correct way to implement foreign key constraints between two tables in MySQL?

By defining a column with REFERENCES to another table's primary key

By creating a unique index on the foreign key column

By using JOIN to enforce referential integrity

By defining a CHECK constraint on the foreign key column

Which of the following is the correct syntax for creating a trigger in MySQL that is executed after an UPDATE operation on a table?

CREATE TRIGGER trigger_name AFTER UPDATE ON table_name FOR EACH ROW

CREATE TRIGGER trigger_name BEFORE UPDATE ON table_name

CREATE AFTER TRIGGER trigger_name ON table_name UPDATE

CREATE TRIGGER AFTER UPDATE ON table_name FOR EACH ROW

Which of the following best describes the AUTO_INCREMENT attribute in MySQL?

It automatically generates a unique value for the column for every new row

It automatically updates a column with the current timestamp

It allows multiple null values in a column

It automatically increments the value of a column every time the table is updated

Which of the following MySQL operations can automatically trigger a stored procedure or trigger?

INSERT, UPDATE, or DELETE operations

MySQL Quiz

Authored by Niveditha Kani

Other

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

35 questions

Show all answers

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

DML

DDL

DQL

TCL

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which SQL command is used to modify the structure of an existing table?

MODIFY

UPDATE

ALTER

CHANGE

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following keywords is used to restrict data modification privileges in MySQL?

GRANT

REVOKE

COMMIT

ROLLBACK

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which clause is used in SQL to filter results after grouping them?

HAVING

WHERE

ORDER BY

GROUP BY

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which SQL clause is used to sort results in MySQL?

ORDER BY

SORT BY

GROUP BY

FILTER BY

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What type of join returns all rows from the left table, and matching rows from the right table?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What does the JOIN operation do in MySQL?

Combines rows from two or more tables

Deletes rows from a table

Modifies data in multiple tables

Creates new tables

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

30 questions

Вхідне/вихідне тестування

Quiz

•

University

40 questions

Kuis Robotika

Quiz

•

University

30 questions

HCT CB Level 1 List 3 ADWC

Quiz

•

4th Grade - University

30 questions

What is System Administration?

Quiz

•

University

30 questions

MICROTOUR Quiz No. 1 - Finals

Quiz

•

University

30 questions

PTS BASA SUNDA KELAS XI OTKP & MM 2020

Quiz

•

University

35 questions

Midterm Andragogy

Quiz

•

University

40 questions

FUTUROS CACHIMBOS

Quiz

•

University

Popular Resources on Wayground

11 questions

Hallway & Bathroom Expectations

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Assessment 2

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

12 questions

2026 TAP Technology in the Classroom

Presentation

•

Professional Development

15 questions

HCS SCI 05 Summer School Assessment 2 Review

Quiz

•

5th Grade

15 questions

HCS SCI 04 Summer School Review 2

Quiz

•

4th Grade

59 questions

Geometry Unit 3 Review

Quiz

•

9th - 12th Grade

14 questions

FAST ELA READING SMAPLE TEST MATERIALS

Passage

•

3rd Grade

MySQL Quiz

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

Which SQL command is used to modify the structure of an existing table?

Which of the following keywords is used to restrict data modification privileges in MySQL?

Which clause is used in SQL to filter results after grouping them?

Which SQL clause is used to sort results in MySQL?

What type of join returns all rows from the left table, and matching rows from the right table?

What does the JOIN operation do in MySQL?

Which aggregate function is used to count the number of rows in MySQL?

What does the GROUP BY clause do in MySQL?

Which SQL command is used to permanently remove a table and all its data from MySQL?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground