SQL QUIZ
1 .
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Reddy"?

Correct Answer : Option (D)

SELECT * FROM Persons WHERE FirstName='Reddy' 
  Show Answer
2 .
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"?

Correct Answer : Option (D)

SELECT * FROM Persons WHERE FirstName LIKE 'a%'
  Show Answer
3 .
What type of query gets information from a database?

Correct Answer : Option (C)

SELECT
  Show Answer
4 .
What type of query removes information from a database?

Correct Answer : Option (B)

DELETE
  Show Answer
5 .
In the query “SELECT address FROM users”, what is the column being selected?

Correct Answer : Option (C)

address
  Show Answer
6 .
What keyword wraps the data that you would like to insert in an INSERT query?

Correct Answer : Option (D)

VALUES()
  Show Answer
7 .
If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?

Correct Answer : Option (A)

AND
  Show Answer
8 .
To sort your results by a column name, what keyword would you use before the column name?

Correct Answer : Option (D)

 
ORDER BY
  Show Answer
9 .
What function would you use to round all numbers down?

Correct Answer : Option (B)

FLOOR
  Show Answer
10 .
What function would you use to round all values up?

Correct Answer : Option (C)

CEILING
  Show Answer