Scribd
Upload
169 views2 pages

DP 1 3 Practice

The document contains 10 multiple choice questions about SQL queries. It covers concepts like projection, selection, joins, and returning all rows from a table. The questions test understanding of basic SQL syntax and keywords.

Uploaded by

Dana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
169 views2 pages

DP 1 3 Practice

The document contains 10 multiple choice questions about SQL queries. It covers concepts like projection, selection, joins, and returning all rows from a table. The questions test understanding of basic SQL syntax and keywords.

Uploaded by

Dana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1. Write a SQL statement that demonstrates projection.

2. Write a query that displays the last_name and email addresses for all the
people in the DJs on Demand d_client table. The column headings should
appear as Client and Email Address.

3. The manager of Global Fast Foods decided to give all employees at 5%/hour raise
+ a $.50 bonus/hour. However, when he looked at the results, he couldn't figure
out why the new raises were not as he predicted. Ms. Doe should have a new
salary of $7.59, Mr. Miller's salary should be $11.00, and Monique Tuttle should
be $63.50. He used the following query. What should he have done?
SELECT last_name, salary *.05 +.50
FROM f_staffs;

4. Which of the following would be the easiest way to see all rows in the
d_songs table? JAWABAN C

a.
b.
c.
d.

SELECT id, title, duration, artist, type_code


SELECT columns
SELECT *
SELECT all

5. If tax = 8.5% * car_cost and license = car_cost * .01%, which value will
produce the largest car payment? JAWABAN B
a. Payment = (car_cost * 1.25) + 5.00 - (tax) - (license)
b. Payment = car_cost * 1.25 + 5.00 - (tax - license)
6.

In the example below, identify the keywords, the clause(s), and the
statement(s): TAMBAHKAN ; UNTUK MENUTUP STATEMENT
QUERY
SELECT employee_id, last_name
FROM employees ;

7. Label each example as SELECTION, PROJECTION, or JOIN.


JAWABAN B
a. Please give me Mary Adam's email address.
b. I will need each customer's name and the order_total for their order.
c. I would like only the manager_id column, and none of the other columns
8. Which of the following statements are true? JAWABAN C
a. null * 25 = 0;
b. null * 6.00 = 6.00
c. null * .05 = null
d. (null + 1.00) + 5.00 = 5.00
9. How will the column headings be labeled in the following example?
JAWABAN B
SELECT bear_id bears, color AS Color, age age
FROM animals;
a. bears, color, age
b. BEARS, COLOR, AGE
c. BEARS, COLOR, age
d. Bears, Color, Age
10. Which of the following words must be in a SELECT statement in order to
return all rows? JAWABAN B
a. SELECT only
b. SELECT and FROM
c. FROM only
d. SELECT * only

You might also like