Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle
Next »
In the following query, which expression is evaluated first?
SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory
Options
- 100 / 0.15
- quantity – 100
- 35*20
- 0.15-35
CORRECT ANSWER : 100 / 0.15
Discussion Board
Correct answer is 100 / 0.15
According to the precedence of expression as in BODMAS (Brackets, Order, Division, Multiplication, Addition, Subtraction) the expression is evaluated, which ensures the equation steps are completed in the right order. So, the correct answer is 100 / 0.15.
Prajakta Pandit 02-2-2017 02:06 AM
PEMDAS rule
P - Parentheses first
E - Exponents (ie Powers and Square Roots, etc.)
MD - Multiplication and Division (left-to-right)
AS - Addition and Subtraction (left-to-right)
career 09-18-2014 12:33 AM
Correction
35*20 Using the formular PEMDAS.
P-parenthesis
E-exoponents
M-multiplication
D-division
A-additiion
S-substraction
Victor Newton 09-17-2014 02:38 PM
Ans
depende upon operator priority
Arun 08-10-2014 09:28 AM
Answer
35*20
Neela 05-22-2014 05:33 AM
orcl
nothing
sree 07-17-2013 12:56 AM
Next »
Write your comments
Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲