NEW
Font size
WorksheetsMySQL Webinar
Total questions: 10
Worksheet time: 5mins
The ______ keyword returns all records from the right table (table2), and the matching records (if any) from the left table (table1).
INNER JOIN
RIGHT JOIN
EQUI JOIN
NATURAL JOIN
The ______ keyword selects records that have matching values in both tables.
RIGHT JOIN
INNER JOIN
CROSS JOIN
NONE
The _______ JOIN is structured in such a way that, columns with the same name of associate tables will appear once only
EQUI JOIN
NATURAL JOIN
INNER JOIN
CROSS JOIN
Identify the command for its proper category GRANT
TCL
DDL
DCL
DQL
Identify the command for its proper category COMMIT
DDL
TCL
DCL
DML
Identify the command for its proper category ALTER
DQL
DML
DDL
DCL
SQL Script file name extention is _______.
.txt
.sol
.sql
.mysql
MySQL was initially developed by ________ company.
MySQL AB
Sun Microsystems
Oracle Corporation
Github
MySQL suitable datatype to store images is _______.
Boolean
BLOB
LONGTEXT
SET
Which image is associated with MySQL Logo?
