Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 8MC
Which of the following symbols is used in a SELECT clause to display all columns from a table?
- a. /
- b. &
- c. *
- d. "
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The HAVING clause applies to columns and expressions for individual rows, while the WHERE clause is applied to the output of a GROUP BY operation.
True or False ?
You have been instructed to add a new student information to the students table. Because the student is new, he has no
marks before, you should not add an amount to the CGPA.
The Students table contains these columns:
Student_id NUMBER(10)
Student_name VARCHAR2(30)
Student phone NUMBER(10)
CGPA NUMBER(2,2)
Which INSERT statements will accomplish your objective?
O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 )
O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' )
O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL )
O d. INSERT INTO students VALUES (365, 'Khalil',99554721)
Which line of code has an error?
1. CREATE TABLE FRUITS VEGETABLES
2. FRUIT TYPE VARCHAR2,
3. FRUIT NAME CHAR (20),
4. QUANTITY NUMBER (4));
O a. 1
O b. 2
O c. 3
Q1. Write a SELECT statement that returns these columns from the Invoices table: The invoice
_total column A column that uses the ROUND function to return the invoice_total column with
1 decimal digit A column that uses the ROUND function to return the invoice_total column
with no decimal digits
Q1. Write a SELECT statement that returns these columns from the Invoices table:
• The invoice_total column
• A column that uses the ROUND function to return the invoice_total column with 1
decimal digit
• A column that uses the ROUND function to return the invoice_total column with no
decimal digits
invoice_total one digit
3813.33
3813.3
zero_digits
3813
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 operators is used when the subquery returns at least one row? Select one: a.All b.IN c.Any d.Exists Jump to...arrow_forward7. Use the UNION operator to generate a result set consisting of three columns from the Products table: Discount status A calculated column that contains a value of DISCOUNTED or FULL PRICE Product_name The product_name column discount_percent The discount_percent column If the product has a discount_percent greater than 0, the Discount_status column should contain a value of DISCOUNTED. Otherwise, it should contain a value of FULL PRICE. Sort the final result set by product_name.arrow_forward9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.arrow_forward
- Which of the following is not a correct statement?a. A table can be modified only if it doesn’t contain any rows of data.b. The maximum number of characters in a table name is 30.c. You can add more than one column at a time to a table.d. You can’t recover data contained in a table that has been truncated.arrow_forwardQ1. Write a SELECT statement that returns these columns from the Invoices table: ⚫ The invoice_total column • A column that uses the ROUND function to return the invoice_total column with 1 decimal digit • A column that uses the ROUND function to return the invoice_total column with no decimal digits invoice_total one_digit 3813.33 zero_digits 3813.3 3813arrow_forwardComplete the following statement to create a table named Country. Choose data types based on the following requirements: • ISOCode3 stores the country's code, consisting of one to three letters. Name stores the country's name up to 52 characters. /* Your code goes here */ ( ISOCode 3 /* Your code goes here */ /* Your code goes here */ ); Name Enter a statement to delete the above table. /* Your code goes here */ ;arrow_forward
- 5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum of Percentage" value. Do not select the Grand Total range in the function.6. Using the MATCH function only, write a formula in cell G7 of Top10_Pivot Sheet to find the Row Number of Maximum Sum of percentage.7. Using the INDEX function only, write a formula in cell H7 to find the state name having the maximum "Sum of Percentage". The formula should include the value(row number) that is calculated in G7.arrow_forwardQUESTION 2 Exercise: Create a statement that will show the sum of all the payments received on or after 2018-08-01. The new column should be titled recent payments_received Hint: If you did this correctly, you will have one column (and one row) showing the following amount 59755.88arrow_forwardWhich of the following statements is correct to display all the columns from the weather table but only for whose humidity is in the range of 40 to 65? O a. SELECT * FROM weather WHERE humidity IN (40 ,65); 1 O b. SELECT * FROM weather WHERE humidity NOT IN (40 AND 65); O c. SELECT * FROM weather WHERE humidity NOT BETWEEN 40 AND 65; O d. SELECT * FROM weather WHERE humidity BETWEEN 40 AND 65; Different employees joined a company on same date. You want to display the hire date and count of the employees in each hire date group. Query 1: Select hiredate, count(*) from employee group by hiredate; Query 2: Select hiredate , count(hiredate) from employee order by hiredate; Which among the above two queries is valid? a. Both Query1 and Query2 are invalid O b. Query1 is valid O c. Both Query 1 and Query2 are valid d. Query2 is valid If a table PRODUCT has 2 columns namely PRODUCTID, PRODUCTNAME and a table ORDER has 3 columns namely ORDERID, ORDERAMOUNT and PRODUCTID. Which column can join…arrow_forward
- Which of the following characters can be used in a table name?a. –b. (c. %d. !arrow_forwardHow do you indicate that a column alias should be used?arrow_forwardPlease written by computer source 11 1. (Use AP) Write a SELECT statement that returns six columns from three tables, all using alias names: VendorName column named Vendor, InvoiceDate column named Date of Invoice (include the spaces), InvoiceNumber column named Number, InvoiceSequence column named #, InvoiceLineItemAmount column named Line Item Amount (include the spaces), and Tax (which is the line item amount multiplied by 6%). Also, assign the following table alias names to the tables: Vendors table named v, Invoices table named i, InvoiceLineItems table named ili. List only data for the Line Item Amounts greater than or equal to $50 but less than $1200 and Vendornames that begin with C-D or K-S. Sort the final result set by Vendor name ascending, and Line Item Amount descending,. 2. (Use AP) Create a query listing all of the vendors (show only vendorid, vendorname) from the state of Wisconsin (WI) or New Jersey (NJ) or Pennsylvania (PA) who have never been invoiced…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
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