MySQL

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

Which SQL statement is used to extract data from a database?

Answer 2

SELECT

Question 3

Which SQL statement is used to update data in a database?

Answer 3

UPDATE

Question 4

Which SQL statement is used to delete data from a database?

Answer 4

DELETE

Question 5

Which SQL statement is used to insert new data in a database?

Answer 5

INSERT INTO

Question 6

With SQL, how do you select a column named “FirstName” from a table named “Persons”?

Answer 6

SELECT FirstName FROM Persons

Question 7

With SQL, how do you select all the columns from a table named “Persons”?

Answer 7

SELECT * FROM Persons

Question 8

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?

Answer 8

SELECT * FROM Persons WHERE FirstName=’Peter’

Question 9

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a”?

Answer 9

SELECT * FROM Persons WHERE FirstName LIKE ‘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

Answer 10

True

Question 11

With SQL, how do you select all the records from a table named “Persons” where the “FirstName” is “Peter” and the “LastName” is “Jackson”?

Answer 11

SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’

Question 12

With SQL, how do you select all the records from a table named “Persons” where the “LastName” is alphabetically between (and including) “Hansen” and “Pettersen”?

Answer 12

SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’

Question 13

Which SQL statement is used to return only different values?

Answer 13

SELECT DISTINCT

Question 14

Which SQL keyword is used to sort the result-set?

Answer 14

ORDER BY

Question 15

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

Answer 15

SELECT * FROM Persons ORDER BY FirstName DESC

Question 16

With SQL, how can you insert a new record into the “Persons” table?

Answer 16

INSERT INTO Persons VALUES (‘Jimmy’, ‘Jackson’)

Question 17

With SQL, how can you insert “Olsen” as the “LastName” in the “Persons” table?

Answer 17

INSERT INTO Persons (LastName) VALUES (‘Olsen’)

Question 18

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

Answer 18

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Question 19

With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table?

Answer 19

DELETE FROM Persons WHERE FirstName = ‘Peter’

Question 20

With SQL, how can you return the number of records in the “Persons” table?

Answer 20

SELECT COUNT(*) FROM Persons