SQL for Non-Technical Users

SQL for Non-Technical Users

Time limit: 0

Quiz Summary

0 of 10 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10

Current
Review
Answered
Correct
Incorrect

Question 1 of 10

1. Question

What does SQL stand for?

Simple Query Language

Structured Question Language

Standard Query Language

Structured Query Language

Correct

Incorrect
Question 2 of 10

2. Question

Which clause in a SELECT statement allows you to filter the results? For example, to limit your results to a particular city.

SELECT

FROM

WHERE

GROUP BY

Correct

Incorrect
Question 3 of 10

3. Question

Which of the following queries would return all fields from the CUSTOMER table?

SELECT * FROM CUSTOMER

SELECT all FROM CUSTOMER

SELECT FROM CUSTOMER

Correct

Incorrect
Question 4 of 10

4. Question

The ORDER BY clause must always be at the end of your query.

True

False

Correct

Incorrect
Question 5 of 10

5. Question

In the query below, which of the following would be returned? SELECT BOOKTITLE, PRICE, COST FROM BOOKS WHERE PRICE > 30 AND COST > 20

A book with price $30 and cost $20

A book with price $35 and cost $25

A book with price $35 and cost $15

A book with price $25 and cost $25

Correct

Incorrect
Question 6 of 10

6. Question

What does SQL call the relationship between two tables based on a common field?

Connection

Relationship

Integration

Join

Correct

Incorrect
Question 7 of 10

7. Question

Let’s assume the CUSTOMER table and the ORDER table have a common field: CUSTOMERID. In the following SQL query, you would get an error. Which of the SELECT clauses corrects the error? SELECT CUSTOMERID, CUSTOMERNAME, ORDERID FROM CUSTOMER C JOIN ORDER O ON C.CUSTOMERID = O.CUSTOMERID

SELECT C.CUSTOMERID, CUSTOMERNAME, ORDERID

SELECT CUSTOMERNAME, ORDERID

SELECT CUSTOMERID FROM CUSTOMER, CUSTOMERNAME, ORDERID

SELECT CUSTOMERID, C.CUSTOMERNAME, ORDER ID

Correct

Incorrect
Question 8 of 10

8. Question

What is it called when you give a shorter name to a table in your SQL query?

Nickname

Short name

Alias

Rename

Correct

Incorrect
Question 9 of 10

9. Question

Let’s assume the ORDER table has a field for ORDERDATE, which contains a specific day. Which of the following SELECT statements correctly returns just the year from ORDERDATE?

SELECT DATENAME(YEAR, ORDERDATE)

SELECT DATE(YEAR, ORDERDATE)

SELECT ORDERDATE(DATEPART, YEAR)

SELECT DATEPART(YEAR, ORDERDATE)

Correct

Incorrect
Question 10 of 10

10. Question

What does the TRIM function do?

Removes spaces at the end of a string

Removes spaces at the beginning and end of a string

Removes spaces at the beginning of a string

Removes spaces in the middle of a string

Correct

Incorrect

ATS eLearning

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.