Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table?
a. SELECT customer names FROM customers;
b. SELECT "Names" FROM customers;
c. SELECT firstname, lastname FROM customers;
d. SELECT firstname, lastname, FROM customers;
e. SELECT firstname,...
Which of the following SELECT statements displays a list of customer names from the CUSTOMERS
table?
a. SELECT customer names FROM customers;
b. SELECT "Names" FROM customers;
c. SELECT firstname, lastname FROM customers;
d. SELECT firstname, lastname, FROM customers;
e. SELECT firstname, lastname, "Customer Names" FROM customers; - correct answer
C
Which clause is required in a SELECT statement? a. WHERE b. ORDER BY c. GROUP BY d. FROM e. all of
the above - correct answer D
Which of the following is not a valid SELECT statement? a. SELECT lastname, firstname FROM customers;
b. SELECT * FROM orders; c. Select FirstName NAME from CUSTOMERS; d. SELECT lastname Last Name
FROM customers; - correct answer D
Which of the following symbols represents concatenation? a. * b. || c. [] d. '' - correct answer
B
Which of the following SELECT statements returns all fields in the ORDERS table? a. SELECT customer#,
order#, orderdate, shipped, address FROM orders; b. SELECT * FROM orders; c. SELECT ? FROM orders;
d. SELECT ALL FROM orders; - correct answer B
Which of the following symbols is used for a column alias containing spaces? a. '' b. || c. "" d. // - correct
answer C
Which of the following is a valid SELECT statement? a. SELECT TITLES * TITLE! FROM BOOKS; b. SELECT
"customer#" FROM books; c. SELECT title AS "Book Title" from books; d. all of the above - correct answer
C
, Which of the following symbols is used in a SELECT clause to display all columns from a table? a. / b. & c.
* d. " - correct answer C
Which of the following is not a valid SELECT statement? a. SELECT cost-retail FROM books; b. SELECT
retail+cost FROM books; c. SELECT retail * retail * retail FROM books; d. SELECT retail^3 from books; -
correct answer D
When must a comma be used in the SELECT clause of a query? a. when a field name is followed by a
column alias b. to separate the SELECT clause and the FROM clause when only one field is selected c. It's
never used in the SELECT clause. d. when listing more than one field name and the fields aren't
concatenated e. when an arithmetic expression is included in the SELECT clause - correct answer
D
Which of the following commands displays a listing of the category for each book in the BOOKS table? a.
SELECT title books, category FROM books; b. SELECT title, books, and category FROM books; c. SELECT
title, cat FROM books; d. SELECT books, | | category "Categories" FROM books - correct answer
A
Which clause is not required in a SELECT statement? a. SELECT b. FROM c. WHERE d. All of the above
clauses are required. - correct answer C
Which of the following lines of the SELECT statement contains an error? 1 SELECT title, isbn, 2 Pubdate
"Date of Publication" 3 FROM books; a. line 1 b. line 2 c. line 3 d. There are no errors. - correct answer
D
Which of the following lines of the SELECT statement contains an error? 1 SELECT ISBN, 2 retail-cost 3
FROM books; a. line 1 b. line 2 c. line 3 d. There are no errors. - correct answer
D
Which of the following lines of the SELECT statement contains an error? 1 SELECT title, cost, 2 cost*2 3
'With 200% Markup' 4 FROM books; a. line 1 b. line 2 c. line 3 d. line 4 e. There are no errors. - correct
answer C
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller RealGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
