MySQL Quiz-3

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

MySQL Quiz-3

Email *

Which of these operators does not perform relative-value comparisons? *

1 point

Which keyword is the synonym for DATABASE? *

1 point

TABLE

OBJECT

SCHEMA

The join where all possible row combinations are produced is called _________ *

1 point

INNER JOIN

OUTER

NATURAL

CARTESIAN

Which keyword is used to create a database? *

1 point

CREATE

SET

SETUP

LINK

Which statement makes changes to the database’s global attributes? *

1 point

CHANGE

ALTER

ALTERNATE

UPDATE

The clause that filters JOIN results is called _________ *

1 point

WHERE

SORT

GROUP

GROUP BY

It is possible to drop multiple tables in the same statement. State True or False. *

1 point

True

False

Usage of aggregates in WHERE clause is allowed. State True or False. *

1 point

True

False

In inner join, result is produced by matching rows in one table with rows in another table. State True or False. *

1 point

True

False

The left and right joins are also known as __________ *

1 point

INNER JOIN

NATURAL JOIN

OUTER JOIN

CARTESIAN JOIN

What is joining a table to itself called? *

1 point

COMPLETE

SELF

OBSOLETE

CROSS

SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? *

1 point

select_list

table_list

row_constraint

grouping_columns

Which statement is used to select a default database? *

1 point

USE

CREATE

DROP

SCHEMA

Which statement is used to see the definition for an existing database? *

1 point

SHOW CREATE DATABASE

SHOW DATABASE

SHOW CREATE

SHOW CREATE DATABASE TABLE

The statement to change the table name is __________ *

1 point

CHANGE

CHANGENAME

CHANGENM

RENAME

Submit

Clear form

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms