Free Data Warehousing on AWS: SQL Questions and Answers

Question 1

What exactly does SQL mean?

Accepted Answer

Structured Query Language

Answer

Structured Question Language

Answer

Strong Question Language

Question 2

Which SQL command is employed to retrieve data from a database?

Accepted Answer

Answer

GET

Question 3

How does one update data in a database using SQL?

Accepted Answer

UPDATE

Answer

SAVE

Answer

SAVE AS

Answer

MODIFY

Question 4

How do you delete data from a database using SQL?

Accepted Answer

DELETE

Answer

COLLAPSE

Answer

REMOVE

Question 5

Which SQL statement is employed when fresh data is to be added to a database?

Accepted Answer

INSERT INTO

Answer

INSERT NEW

Answer

ADD NEW

Answer

ADD RECORD

Question 6

How do you use SQL to choose the "FirstName" column from the "Persons" table?

Accepted Answer

SELECT FirstName FROM Persons

Answer

EXTRACT FirstName FROM Persons

Answer

SELECT Persons.FirstName

Question 7

How do you use SQL to select every column from the "Persons" table?

Accepted Answer

SELECT * FROM Persons

Answer

SELECT Persons

Answer

SELECT *.Persons

Answer

SELECT [all] FROM Persons

Question 8

How do you use SQL to retrieve every record from the "Persons" table when "Peter" is the value of the "FirstName" column?

Accepted Answer

SELECT * FROM Persons WHERE FirstName='Peter'

Answer

SELECT * FROM Persons WHERE FirstName<>'Peter'

Answer

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

Answer

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

Question 9

How do you use SQL to pick every record from the "Persons" table where the value of the "FirstName" column begins with a "a"?

Accepted Answer

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Answer

SELECT * FROM Persons WHERE FirstName LIKE '%a'

Answer

SELECT * FROM Persons WHERE FirstName='a'

Answer

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

Question 10

If ANY of the listed conditions are true, the OR operator displays a record. If ALL of the specified criteria are true, the AND operator displays a record.

Accepted Answer

True

Answer

False