Search Header Logo

MySQL Quiz

Authored by Niveditha Kani

Other

University

Used 1+ times

MySQL Quiz
AI

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

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

DML

DDL

DQL

TCL

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

MODIFY

UPDATE

ALTER

CHANGE

3.

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

4.

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

5.

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

6.

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

7.

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?