Oracle Interview Questions And Answers

Computer Tutorials Earn Money From Internet Cheap Freelancers Ask An Expert Register Cheap Domain Data Recovery Best Mutual Funds Trading Forex Online Cheap Web Hosting Ajax Tutorials Cheap Cell Phone Plans Free Mobile Learning Job Portal Photoshop Tutorials Cheap Jewelry Cheapest Air Travel

Oracle Interview Questions And Answers Page 85 of 95 b] VIK RAM c] VIKRAM d] NULL Ans : C 66. Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a < c then a := c * a; end if; End; What will be the value of 'a' after execution ? a] 50 b] NULL c] 5 d] None of the above Ans : C 67. Does the Database trigger will fire when the table is TRUNCATED ? a] Yes b] No Ans : B 68. SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return a] ALWAY b} S ALWA c] ALWAYS Ans : C 69. REPLACE('JACK AND JUE','J','BL') will return a] JACK AND BLUE b] BLACK AND JACK c] BLACK AND BLUE d] None of the above Ans : C 70. TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return a] 333234 b] 333333 c] 234333 d] None of the above Ans : A 71. EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH 2850 A500 BALAJI 5750 Use these data for the following Questions