Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 2, Problem 15MC
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following will select the State and Sales fields from the Stores table? a. SELECT State AND Sales FROM Stores b. SELECT State OR Sales FROM Stores c. SELECT State, Sales FROM Stores d. SELECT ONLY State, Sales FROM Stores
Which of the following is not a valid INSERT statement?
a. INSERT INTO table_name VALUES (val1, val2);
b. INSERT INTO table_name (column1, column2) VALUES (val1, val2);
c. INSERT INTO table_name1 SELECT col1, col2 FROM table_name2;
d. INSERT INTO table_name1 VALUES (SELECT col1, col2 FROM table_name2);
e. All of the above
f. None of the above
53. Which SELECT statement retrieves the customer name for those that have a salesperson number of 137?
A: SELECT CUSTNAME
FROM CUSTOMER
WHERE SPNUM 137;
B: SELECT*
FROM CUSTNAME
WHERE SPNUM=137;
C: SELECT CUSTOMER
FROM CUSTNAME
WHERE SPNUM=137;
D:SELECT*
FROM CUSTOMER
WHERE SPNUM=137
Chapter 2 Solutions
Oracle 12c: SQL
Ch. 2 - Prob. 1RQCh. 2 - What are the two required clauses for a SELECT...Ch. 2 - What is the purpose of the SELECT statement?
Ch. 2 - What does an asterisk () in the SELECT clause of a...Ch. 2 - What is the purpose of a column alias?Ch. 2 - How do you indicate that a column alias should be...Ch. 2 - When is it appropriate to use a column alias?
Ch. 2 - What are the guidelines to keep in mind when using...Ch. 2 - Prob. 9RQCh. 2 - What is a NULL value?
Ch. 2 - Which of the following SELECT statements displays...Ch. 2 - Which clause is required in a SELECT...Ch. 2 - Which of the following is not a valid SELECT...Ch. 2 - Which of the following symbols represents...Ch. 2 - Prob. 5MCCh. 2 - Prob. 6MCCh. 2 - Which of the following is a valid SELECT...Ch. 2 - Which of the following symbols is used in a SELECT...Ch. 2 - Prob. 9MCCh. 2 - When must a comma be used in the SELECT clause of...Ch. 2 - Prob. 11MCCh. 2 - Which clause is not required in a SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Prob. 1HOACh. 2 - Prob. 2HOACh. 2 - Prob. 3HOACh. 2 - Prob. 4HOACh. 2 - Prob. 5HOACh. 2 - Prob. 6HOACh. 2 - Prob. 7HOACh. 2 - Create a list of each book title stored in the...Ch. 2 - Prob. 9HOACh. 2 - List all information for each order item. Include...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Which of the following lines of the SELECT statement contains an error? 1 SELECT name, contact 2 "Person to Call", phone 3 FROM publisher; a. line 1 b. line 2 c. line 3 d. There are no errors.arrow_forwardWhich 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.arrow_forwardWhich of the following lines of the SELECT statement contains an error? 1 SELECT * 2 FROM publishers; line 1 line 2 There are no errors.arrow_forward
- Which of the following lines of the SELECT statement contains an error? 1 SELECT title, category 2 FORM books; line 1 line 2 There are no errors.arrow_forwardWhich of the following lines of the SELECT statement contains an error? 1 SELECT ISBN, || 'is the ISBN for the book named' || 2 title 3 FROM books; line 1 line 2 line 3 There are no errors.arrow_forwardWhich of the following is not a valid SELECT statement? SELECT lastname, firstname FROM customers; SELECT * FROM orders; Select FirstName NAME from CUSTOMERS; SELECT lastname Last Name FROM customers;arrow_forward
- Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;arrow_forwardWhich 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.arrow_forwardWhich 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 abovearrow_forward
- Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? Me.CompanyDataSet.Fill(Me.Sales) Me.SalesBindingSource.Fill(Me.CompanyDataSet) Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)arrow_forwardWhich of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? a. Me.CompanyDataSet.Fill(Me.Sales) b. Me.SalesBindingSource.Fill(Me.CompanyDataSet) c. Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) d. Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)arrow_forwardWhich one of the following statement will display the data value of the head_ptr of section 5.1? Group of answer choices (head_ptr->data)( ); *head_ptr; *head_ptr.data( ); head_ptr.data( ); (*head_ptr).data( );arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License