8. SQL statement:SELECT ROUND (554.356, 2), ROUND (554.356, -1), ROUND (554.356, -2)FROM DUAL;will produce the following output respectively.А.ROUND (554.356, 2)ROUND (554.356, -1)ROUND (554.356, -2)554.36550600В.ROUND (554.356, 2)ROUND (554.356, -1)ROUND (554.356, -2)554.35550600С.ROUND (554.356, 2)ROUND (554.356, -1)ROUND (554.356, -2)554.36554500D.ROUND (554.356, 2)ROUND (554.356, -1)ROUND (554.356, -2)554.36550.356600.356

ROUND (expression, [decimal place])where [decimal place] indicates the number of decimal points…

8. SQL statement: SELECT ROUND (554.356, 2), ROUND (554.356, -1), ROUND (554.356, 2) FROM DUAL; will produce the following output respectively. А. ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.36 550 600 ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.35 550 600 С. ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.36 554 500 D. ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.36 550.356 600.356 B.

8. SQL statement: SELECT ROUND (554.356, 2), ROUND (554.356, -1), ROUND (554.356, 2) FROM DUAL; will produce the following output respectively. А. ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.36 550 600 ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.35 550 600 С. ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.36 554 500 D. ROUND (554.356, 2) ROUND (554.356, -1) ROUND (554.356, -2) 554.36 550.356 600.356 B.

C++ for Engineers and Scientists

4th Edition

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Bronson, Gary J.

Chapter4: Selection Structures

Section4.1: Selection Criteria

Problem 3E

See similar textbooks

Similar questions

Write a SQL statement that display the emp id , dep id, dep name Output show
Can you Write the SQL statements to do the following please : 1. Display the artist's name from the Artist table in uppercase.2. Display the person's Key, First Name, Last Name and Area Code (first 3 digits of the phone number) from the Person table and label the output as such. 3. Display the current date and five days from that date.4. Display the difference between the current date and the PurchaseDate of the Inventory.5. Display the day of the week, in words, on which the Purchases were place. (Hint: Use datepart dw.)6. Display the minimum, maximum, sum, average, count fields, count records for the SaleDetailPrice from the SaleDetail table. Appropriately label the output.7. Display the count of phone numbers in the Person table.8. Display the record count of the Person table.
9.use the data which is given as shown bwlow to Write a SQL statement to display the most expensive and the cheapest product (list price). Display product ID, product name, and the list price.
1. Write a SQL function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula: ? = ?( ? + (? /((1+?)^? ( −1 )) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts (as large as in the millions of dollars) and APRs (down to the sixth decimal place will be sufficient).
In what circumstances does it make sense to assume that two select statements from the same database are consistent with one another?
Saira owns a small business and she frequently makes transactions. Sometimes she makes payments and other times payments are credited in her account. One of her customer Tania purchased a product and credited payment while another payment by Saira was in progress. Now the sequence of transaction is as follows:1. Tania’s account read amount in saira’s account2. Saira’s account read amount in saira’s account3. Tania added Rs. 500/- in original amount (that was lets suppose Rs. 60,000/ 4. Saira’s account subtracted Rs. 2000/- that she debited in someone else’s account form the original amount (that was Rs. 60,000) 5. Tania’s account committed the transaction 6. Saira’s account committed the transaction Draw the above-mentioned sequence in form of a table and see if there is a problem. What this problem is called and how can we avoid such kind of problem? Propose some solutions (at least two) and then explain which one is better and why?
Create a SQL program where a user can check all the books online. They can also order a book online, in which case the inventory will get updated, and the book count will reduce.
Write a SQL function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula: ? = ? ? + ? (1+?) ? ( −1 ) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts (as large as in
Write a SQL function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula: ? = ? ? + ? (1+?) ? ( −1 ) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts (as large as in the millions of dollars) and APRs (down to the sixth decimal place will be sufficient). You must name your function: __monthlyPayment Where is your last name and is the day of the month you were born. This naming convention is merely meant to make the grading process easier, so that all of the functions, procedures, and triggers have unique names. How would I invoke this function? Below is an example of my function…
Why would you assume that two select statements from the same database are consistent?
Use My Guitar Shop Database Use Microsoft SQL Server Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2019', 4); SET @OrderID = @@IDENTITY; INSERT OrderItems VALUES (@OrderID, 6, '415.00', '161.85', 1); INSERT OrderItems VALUES (@OrderID, 1, '699.00', '209.70', 1); Here, the @@IDENTITY variable is used to get the order ID value that’s automatically generated when the first INSERT statement inserts an order. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.
Execute the following statements using MYSQL: 1.Create a Trigger "trigger regno" for the salesman table (Before INSERT) set the value as O for the experience > 7 and evaluate it. Also write the syntax to drop the Trigger "trigger regno* 2. Insert a value for Customer table (#Last 3 digit of your register no, #Your name, Vellore, 55, 010). Insert a value for salesman table ("10", #Your name, 5, 4000). 3. List out the number of customers in each city by arranging them from low to high. ( 4. Select all the salesman who's work experience is between 4 and 8.