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 84 of 95 Ans : A 59. PL/SQL supports datatype(s) a] Scalar datatype b] Composite datatype c] All of the above d] None of the above Ans C 60. Find the ODD datatype out a] VARCHAR2 b] RECORD c] BOOLEAN d] RAW Ans : B 61. Which of the following is not correct about the "TABLE" datatype ? a] Can contain any no of columns b] Simulates a One-dimensional array of unlimited size c] Column datatype of any Scalar type d] None of the above Ans : A 62. Find the ODD one out of the following a] OPEN b] CLOSE c] INSERT d] FETCH Ans C 63. Which of the following is not correct about Cursor ? a] Cursor is a named Private SQL area b] Cursor holds temporary results c] Cursor is used for retrieving multiple rows d] SQL uses implicit Cursors to retrieve rows Ans : B 64. Which of the following is NOT VALID in PL/SQL ? a] Select ... into b] Update c] Create d] Delete Ans : C 65. What is the Result of the following 'VIK'||NULL||'RAM' ? a] Error