Question: Which of the following SELECT statements returns 30 as the result? a. SELECT ROUND (24.37, 2) FROM dual; b. SELECT TRUNC (29.99, 2) FROM dual;

Which of the following SELECT statements returns 30 as the result?

a. SELECT ROUND (24.37, 2) FROM dual;

b. SELECT TRUNC (29.99, 2) FROM dual;

c. SELECT ROUND (29.01, -1) FROM dual;

d. SELECT TRUNC (29.99, -1) FROM dual;

Step by Step Solution

★★★★★

3.33 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c SELE... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12128b24_716591.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12128b24_716591.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!

Q:

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...

Q:

Which of the following SELECT statements lists the highest retail price of all books in the Family category? a. SELECT MAX (retail) FROM books WHERE category = 'FAMILY'; b. SELECT MAX (retail) FROM...

Q:

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,...

Q:

Anyone got complete answers to this quiz? 1. 5a_39 In technical analysis, what is a support level for a stock? A. Demand exceeds supply. B. Supply exceeds demand. C. Volume sold equals volume...

Q:

accounting help Calculating Select Ratios using Excel's ROUND and Basic Math Functions Games Galore has provided its condensed financial statements for the year ended December 31, 2016. The...

Q:

ars ess The Brod Tools the properto entreprise en troductory The better with pore The masse smyyn, omstret In maleng capital structure decision, matargers must manage the following leverage for...

Q:

All questioned must be answered as a formula 3 Ints Games Galore has provided its condensed financial statements for the year ended December 31, 2016. The Controller has asked you to calculate...

Q:

7. (Expected return, standard deviation, and capital asset pricing model) The following are the end-of-month prices for both the Standard & Poor's 500 Index and Nike's common stock. a. Using the data...

Q:

A) What are the results of the following queries (Based on Employee Table)? 1) SELECT CONCAT(CONCAT(CONCAT(name, ' is from '),country), '. ') "phrase" FROM employee WHERE gender= 'Female'; 2) SELECT...

Q:

PLEASE BE ACCURATE with answers COMP- XM question ...statement information below in attachment It is January 2nd and senior management of Chester meets to determine their investment plan for the...

Q:

1. The initial data on inventory, purchases and sales of tennis rackets are as follows: April 3 Inventory 21 units @ $17 11 Purchase 12 units @ $17 14 Sale 16 units 21 Purchase 14 units @ $19 25 Sale...

Q:

Identify three personal characteristics that might serve as indicators or red flags of fraudulent activity. Briefly discuss each.

Q:

The Supplies account had a $570 debit balance at the beginning of the year, and $2,680 of supplies were purchased during the year. The December 31 physical count showed $673 of supplies available....

Q:

10 It's increasingly clear that many postings on blogs and product reviews on Web sites are fake or are posted there to manipulate consumers' opinions. For example a miniscandal erupted in 2007 when...

Q:

Which of the following data units is encapsulated in a frame? a. A user datagram b. A datagram c. A segment

Q:

Which of the following data units is decapsulated from a user datagram? a. A datagram b. A segment c. A message

Q:

Which of the following data units has an application-layer message plus the header from layer 4? a. A frame b. A user datagram c. A bit

Q:

Roth Corp. wants to raise $4.5 million via a rights offering. The company currently has 550,000 shares of common stock outstanding that sell for $80 per share. Its underwriter has set a subscription...

Q:

Accounting statements represent a company's earnings, but this is not the real cash that a company generates. Earnings data can be manipulated and can be deceiving. Thus, corporate decision makers...

Q:

(d) (1 pt) Use R to run N = 10, 000 Monte Carlo Simulations of obtain the MLE of a size 100 random sample. Namely, you will obtain 10, 000 realizations of the MLE. These realizations provide you an...