SQL QUIZ
1 .
What function can you use to compare dates?

Correct Answer : Option (A)

DATEDIFF
  Show Answer
2 .
Which of the following is NOT true about the SQL transaction control statements?

Correct Answer : Option (A)

Each DML statement is automatically committed.
  Show Answer
3 .
With SQL, how can you delete the records where the "FirstName" is "Reddy" in the Persons Table?

Correct Answer : Option (B)

DELETE FROM Persons WHERE FirstName = 'Reddy'
  Show Answer
4 .
With SQL, how can you return the number of records in the "Persons" table?

Correct Answer : Option (D)

SELECT COUNT(*) FROM Persons
  Show Answer
5 .
What function would you use to return the highest value of a column?

Correct Answer : Option (B)

MAX
  Show Answer
6 .
What function can you use to add all of a column’s values together?

Correct Answer : Option (D)

SUM
  Show Answer
7 .
What keyword can you use to merge two tables based on a matching column?

Correct Answer : Option (A)

JOIN
  Show Answer
8 .
What is the most common type of join?

Correct Answer : Option (D)

INNER JOIN  
  Show Answer
9 .
What keyword can you use to search for a string in a column?

Correct Answer : Option (B)

LIKE
  Show Answer
10 .
If you are only retrieving one column’s values, what keyword can you add before the column name to only return unique values?

Correct Answer : Option (C)

DISTINCT
  Show Answer