Question:
Give output of:
Select Round (765.3895, 2)
will return:
Give output of:
Select Round (765.3895, 2)
will return:
Select Round (765.3895, 2)
will return:
Show Hint
Pay close attention to the digit following the rounding precision—it determines the final value.
Updated On: Apr 28, 2025
- 765.38
- 765.30
- 765.00
- 765.39
Hide Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The SQL `ROUND()` function rounds a numeric field to the number of decimal places specified. `ROUND(765.3895, 2)` rounds the number to two decimal places. Since the third decimal digit is 9 (greater than 5), it rounds up from 765.38 to 765.39.
Was this answer helpful?
0
0
Top Questions on SQL Functions
- Vardan was asked by his teacher the meaning of the following command. He is not able to decide on the correct answer. Help him in selecting the correct answer.
Select * from stud where admn like '\%5\%5\%';- CUET (UG) - 2023
- Computer Science
- SQL Functions
- Match List I with List II:
LIST I LIST II A. Alter I. Change the name of the column B. Update II. Update existing information in a table C. Delete III. Delete an existing row from table D. Create IV. Create a database
Choose the correct answer from the options given below:- CUET (UG) - 2023
- Computer Science
- SQL Functions
- Single row or scalar functions are applied on a single value and return a single value.
Which of the following is NOT a Date Function?- CUET (UG) - 2023
- Computer Science
- SQL Functions
- Match List I with List II
LIST I LIST II A. SELECT LOWER('COMPUTER'); IV. 'computer' B. SELECT LEFT('COMPUTER', 3); I. 'COM' C. SELECT RIGHT('COMPUTER', 4); II. 'UTER' D. SELECT MID('COMPUTER', 2, 3); III. 'OMP' - CUET (UG) - 2023
- Computer Science
- SQL Functions
- Which SQL function will return the following output:
mysql> Select __?__ (53, 10);output __3- CUET (UG) - 2023
- Computer Science
- SQL Functions
Questions Asked in CUET exam
- For fixed values of radii of curvature of lens, power of the lens will be ____.
Fill in the blank with the correct answer from the options given below - Find out which of the answer figures completes the figure matrix :
- CUET (UG) - 2024
- Image Based
- Match List-I with List-II:
List-I (Centre of Handicraft) List-II (State) A Mon (I) Arunachal Pradesh B Nalbari (II) Assam C Pasighat (III) Meghalaya D Tura (IV) Nagaland - CUET (UG) - 2024
- Static GK
- In the figure given below, APB is a curved surface of radius of curvature 10 cm separating air and a transparent material \((μ = \frac{4}{3} ).\) A point object O is placed in air on the principal axis of the surface 20 cm from P. The distance of the image of O from P will be _____.
Fill in the blank with the correct answer from the options given below - Match the words in List-I with their definitions in List-II :
List-I (Words) List-II (Definitions) (A) Theocracy (I) One who keeps drugs for sale and puts up prescriptions (B) Megalomania (II) One who collects and studies objects or artistic works from the distant past (C) Apothecary (III) A government by divine guidance or religious leaders (D) Antiquarian (IV) A morbid delusion of one’s power, importance or godliness Choose the correct answer from the options given below :- CUET (UG) - 2024
- Vocabulary
View More Questions