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 86 of 95 Select SAL from EMP E1 where 3 > ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve a] 3500,5000,2500 b] 5000,2850 c] 2850,5750 d] 5000,5750 Ans : A 72. Is it possible to modify a Datatype of a column when column contains data ? a] Yes b] No Ans B 73. Which of the following is not correct about a View ? a] To protect some of the columns of a table from other users b] Ocuupies data storage space c] To hide complexity of a query d] To hide complexity of a calculations Ans : B 74. Which is not part of the Data Definiton Language ? a] CREATE b] ALTER c] ALTER SESSION Ans : C 75. The Data Manipulation Language statements are a] INSERT b] UPDATE c] SELECT d] All of the above Ans : D 76. EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH A500 BALAJI 5750 Using the above data Select count(sal) from Emp will retrieve a] 1 b] 0 c] 3 d] None of the above