SQL For Actuaries
- 1.
How do you select a column named "RiskClass" from a table named "Accidents"?
- A.
SELECT * FROM Accidents
- B.
SELECT RiskClass FROM Accidents
- C.
SELECT Accidents.RiskClass
- D.
SELECT * FROM Accidents WHERE RiskClass
Correct Answer
B. SELECT RiskClass FROM Accidents -
- 2.
How do you select all columns from a table Accidents where the Gender is Male?
- A.
SELECT * FROM Accidents WHERE Gender "Male"
- B.
SELECT * FROM Accidents WHERE Gender LIKE "Male"
- C.
SELECT * FROM Accidents WHERE Gender "Female"
- D.
SELECT * FROM Accidents WHERE Gender = "Male"
Correct Answer
D. SELECT * FROM Accidents WHERE Gender = "Male" -
- 3.
The character '%' in SQL is equivalent to '*' in MS Access. These are known as wildcards. How would you select all the fields from the table Accidents where LastName ends with "son" ?
- A.
SELECT * FROM Accidents WHERE LastName = '%son%'
- B.
SELECT * FROM Accidents WHERE LastName LIKE '%son'
- C.
SELECT * FROM Accidents WHERE LastName LIKE 'son%'
- D.
SELECT * FROM Accidents WHERE LastName = 'son'
Correct Answer
B. SELECT * FROM Accidents WHERE LastName LIKE '%son' -
- 4.
How do you select all records from table Accidents where Gender is "Male" and RiskClass = "C"
- A.
SELECT Gender, RiskClass WHERE Gender = "Male" and RiskClass = "C"
- B.
SELECT * WHERE Gender = "Male" and RiskClass = "C"
- C.
SELECT * FROM Accidents WHERE Gender = "Male" and RiskClass = "C"
- D.
SELECT * FROM Accidents WHERE Gender = "Mal" and RiskClas =
Correct Answer
C. SELECT * FROM Accidents WHERE Gender = "Male" and RiskClass = "C" -
- 5.
Which SQL Keyword(s) is used to sort data?
- A.
ORDER
- B.
SORT BY
- C.
SORT
- D.
ORDER BY
Correct Answer
D. ORDER BY -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 11, 2013Quiz Edited by
ProProfs Editorial Team -
Mar 03, 2013Quiz Created by
Actuwaiter
Back to top