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 16MC
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following SQL statements is valid?
a. INSERT INTO table_name (val1, val2);
b. ALTER COLUMN column_name SET PRIMARY KEY;
c. INSERT INTO table_name1 SELECT col1, col2 FROM table_name2;
d. SLTER TABLE table_name SET col1 PRIMARY KEY;
e. All of the above.
f. None of the above.
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
Which 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( );
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 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 title, cost, 2 cost2 3 'With 200% Markup' 4 FROM books; a. line 1 b. line 2 c. line 3 d. line 4 e. 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_forward
- Which 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_forwardWhich 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 symbols is used in a SELECT clause to display all columns from a table? / & * "arrow_forward
- Which clause is required in a SELECT statement? WHERE ORDER BY GROUP BY FROM all of the abovearrow_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_forwardWrite a SELECT statement returns these columns from the orders table: The invoice_id column as Invoice_ID The invoice_date column as Invoice_Date The invoice_due_date column as Invoice_Due_Date The payment_date column in the format 'Mon/DD/YY' as Formatted_Payment_Date The invoice_due_date column in the format 'Weekday, Month Day of month with suffix, YYYY' (ex: 'Tuesday, April 23rd, 2019') as Long_Invoice_Due_Date The invoice_due_date plus 60 days as Expected_Payment_Date (Column must remain a date type) The number of days between the invoice_due_date and the payment_date as Time_To_Payarrow_forward
- 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=137arrow_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_forwardFill in the blank to complete the CREATE TABLE command below so that the type for customerzip would be fixed length 5-character string. CREATE TABLE customer ( customerid CHAR(7) NOT NULL, customername VARCHAR(15) NOT NULL, customerzip _______ NOT NULL, PRIMARY KEY (customerid) );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