0 of 10 Questions completed
Questions:
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:
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)
What does SQL stand for?
Which clause in a SELECT statement allows you to filter the results? For example, to limit your results to a particular city.
Which of the following queries would return all fields from the CUSTOMER table?
The ORDER BY clause must always be at the end of your query.
In the query below, which of the following would be returned? SELECT BOOKTITLE, PRICE, COST FROM BOOKS WHERE PRICE > 30 AND COST > 20
What does SQL call the relationship between two tables based on a common field?
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
What is it called when you give a shorter name to a table in your SQL query?
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?
What does the TRIM function do?