SQL For Actuaries
-
How do you select all records from table Accidents where Gender is "Male" and RiskClass = "C"
-
SELECT Gender, RiskClass WHERE Gender = "Male" and RiskClass = "C"
-
SELECT * WHERE Gender = "Male" and RiskClass = "C"
-
SELECT * FROM Accidents WHERE Gender = "Male" and RiskClass = "C"
-
SELECT * FROM Accidents WHERE Gender = "Mal" and RiskClas =
-
Quiz Preview
- 2.
How do you select all columns from a table Accidents where the Gender is Male?
-
SELECT * FROM Accidents WHERE Gender "Male"
-
SELECT * FROM Accidents WHERE Gender LIKE "Male"
-
SELECT * FROM Accidents WHERE Gender "Female"
-
SELECT * FROM Accidents WHERE Gender = "Male"
Correct Answer
A. SELECT * FROM Accidents WHERE Gender = "Male" -
- 3.
Which SQL Keyword(s) is used to sort data?
-
ORDER
-
SORT BY
-
SORT
-
ORDER BY
Correct Answer
A. ORDER BY -
- 4.
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" ?
-
SELECT * FROM Accidents WHERE LastName = '%son%'
-
SELECT * FROM Accidents WHERE LastName LIKE '%son'
-
SELECT * FROM Accidents WHERE LastName LIKE 'son%'
-
SELECT * FROM Accidents WHERE LastName = 'son'
Correct Answer
A. SELECT * FROM Accidents WHERE LastName LIKE '%son' -
- 5.
How do you select a column named "RiskClass" from a table named "Accidents"?
-
SELECT * FROM Accidents
-
SELECT RiskClass FROM Accidents
-
SELECT Accidents.RiskClass
-
SELECT * FROM Accidents WHERE RiskClass
Correct Answer
A. SELECT RiskClass FROM Accidents -
Quiz Review Timeline (Updated): Mar 11, 2013 +
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