MySQL Quiz Results [w3schools.

com]
Score: 25 of 25

100% Correct:

Question 1:
What is MySQL?

All the options are correct    Your answer  

A relational database management system

Developed, distributed, and supported by Oracle Corporation

Cross-platform, open-source and free

Question 2:
Which MySQL statement is used to select data from a database?

SELECT    Your answer  

EXTRACT

GET

OPEN

Question 3:
Which MySQL statement is used to update data in a database?

UPDATE    Your answer  

MODIFY
INSERT

SAVE

Question 4:
Which MySQL statement is used to delete data from a database?

DELETE    Your answer  

REMOVE

COLLAPSE

Question 5:
Which MYSQL statement is used to insert new data in a database?

INSERT INTO    Your answer  

INSERT NEW

ADD NEW

ADD RECORD

Question 6:
With MySQL, how do you select a column named "FirstName" from a table named "Persons"?

SELECT FirstName FROM Persons    Your answer  

EXTRACT FirstName FROM Persons

SELECT Persons.FirstName

Question 7:
With MySQL, how do you select all the columns from a table named "Persons"?

SELECT * FROM Persons    Your answer  

SELECT *.Persons

SELECT [all] FROM Persons

SELECT Persons

Question 8:
With MySQL, how do you select all the records from a table named "Persons" where the value of the column
"FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter'    Your answer  

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

Question 9:
With MySQL, how do you select all the records from a table named "Persons" where the value of the column
"FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%'    Your answer  

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName='%a%'

Question 10:
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of
the conditions listed are true
True    Your answer  

False

Question 11:
With MySQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and
the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'    Your answer  

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

Question 12:
With MySQL, how do you select all the records from a table named "Persons" where the "LastName" is
alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'    Your answer  

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

Question 13:
Which MySQL statement is used to return only different values?

SELECT DISTINCT    Your answer  

SELECT DIFFERENT

SELECT UNIQUE

Question 14:
Which MySQL keyword is used to sort the result-set?

ORDER BY    Your answer  

SORT BY

ORDER

SORT

Question 15:
With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER BY FirstName DESC    Your answer  

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

Question 16:
With MySQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')    Your answer  

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

Question 17:
With MySQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons (LastName) VALUES ('Olsen')    Your answer  

INSERT ('Olsen') INTO Persons (LastName)

Question 18:
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'    Your answer  

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Question 19:
With MySQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

DELETE FROM Persons WHERE FirstName = 'Peter'    Your answer  

DELETE ROW FirstName='Peter' FROM Persons

DELETE FirstName='Peter' FROM Persons

Question 20:
With MySQL, how can you return the number of records in the "Persons" table?

SELECT COUNT(*) FROM Persons    Your answer  

SELECT NO(*) FROM Persons

SELECT LEN(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

Question 21:
What are the supported types of joins in MySQL?

INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN    Your answer  

INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN

Question 22:
Which operator is used to select values within a given range?

BETWEEN    Your answer  

UNION

IN

RANGE

Question 23:
The NOT NULL constraint enforces a column to not accept NULL values.

True    Your answer  

False

Question 24:
Which operator is used to search for a specified pattern in a column?

LIKE    Your answer  

GET

FROM

Question 25:
Which MySQL statement is used to create a database table called 'Customers'?

CREATE TABLE Customers    Your answer  

CREATE DATABASE TAB Customers

CREATE DB Customers

CREATE DATABASE TABLE Customers