Search

Take Quizzes
- - Animal
  - Nutrition
  - Love
  - Relationship
  - Computer
  - Sports
  - Society
  - Business
  - Geography
  - Language
- - Personality
  - Harry Potter
  - Movie
  - Television
  - Music
  - Online Exam
  - Health
  - Country
  - Art
  - Entertainment
- - Celebrity
  - Math
  - Game
  - Book
  - Fun
  - Science
  - Food
  - History
  - Education
  - All Topics
Create a Quiz

Search

Create A Quiz
- Animal
- Nutrition
- Love
- Relationship
- Computer
- Sports
- Society
- Business
- Geography
- Language
- Personality
- Harry Potter
- Movie
- Television
- Music
- Online Exam
- Health
- Country
- Art
- Entertainment
- Celebrity
- Math
- Game
- Book
- Fun
- Science
- Food
- History
- Education
- All Topics

Quizzes › Computer › Database › SQL

SQL For Actuaries

5 Questions | By Actuwaiter | Updated: Mar 11, 2013 | Attempts: 151

Share

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Question 1 / 5

0 %

0/100

Score 0/100

1. 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 =

Submit

About This Quiz

SQL Quizzes & Trivia

What's your name? Tell us your name to personalize your report, certificate & get on the leaderboard!

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"

Submit

3. Which SQL Keyword(s) is used to sort data?

ORDER

SORT BY

SORT

ORDER BY

Submit

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'

Submit

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

Submit

View My Results

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, 2013

Quiz Edited by
ProProfs Editorial Team
Mar 03, 2013

Quiz Created by
Actuwaiter

Related Quizzes

The Ultimate Server Query Language Quiz The Ultimate Server Query Language Quiz

SQL Multiple Choice Questions With Answers SQL Multiple Choice Questions With Answers

Test Your Ddl And Dml Knowledge Test Your Ddl And Dml Knowledge

Basic SQL Quiz For School Learners! Basic SQL Quiz For School Learners!

Introduction To SQL True Or False Quiz Introduction To SQL True Or False Quiz

SQL MCQ Exam: Trivia Quiz! SQL MCQ Exam: Trivia Quiz!

Saved

Thank you for your feedback!

Would you like to edit this question to improve it?

Name:

Email:

Oops! Give us more information:

Incorrect Question

Incorrect Answer

Typos

I have a feedback

Please provide name and email to proceed. Please provide correct email to proceed. Please provide feedback. Please select the option.

Cancel

All (5)
Unanswered ()
Answered ()

How do you select all records from table Accidents where Gender is...

How do you select all columns from a table Accidents where the Gender...

Which SQL Keyword(s) is used to sort data?

The character '%' in SQL is equivalent to '*' in MS...

How do you select a column named "RiskClass" from a table...

Alert!

Advertisement