SQL QUIZ
1 .
What does SQL stand for?

Correct Answer : Option (A)

Structured Query Language
  Show Answer
2 .
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "FreeTime" and the "LastName" is "FreeTime"?

Correct Answer : Option (C)

SELECT * FROM Persons WHERE FirstName='FreeTime' AND LastName='Learning'
  Show Answer
3 .
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "FreeTime" and "Learning"?

Correct Answer : Option (A)

SELECT * FROM Persons WHERE LastName BETWEEN 'FreeTime' AND 'Learning'
  Show Answer
4 .
Which SQL statement is used to extract data from a database?

Correct Answer : Option (D)

SELECT
  Show Answer
5 .
Which SQL statement is used to update data in a database?

Correct Answer : Option (A)

UPDATE
  Show Answer
6 .
Which SQL statement is used to delete data from a database?

Correct Answer : Option (B)

DELETE
  Show Answer
7 .
Which SQL statement is used to return only different values?

Correct Answer : Option (B)

SELECT DISTINCT
  Show Answer
8 .
Which SQL keyword is used to sort the result-set?

Correct Answer : Option (D)

ORDER BY  
  Show Answer
9 .
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

Correct Answer : Option (A)

SELECT * FROM Persons ORDER BY FirstName DESC
  Show Answer
10 .
Which SQL statement is used to insert new data in a database?

Correct Answer : Option (C)

INSERT INTO
  Show Answer