Oracle - World's largest enterprise software company - Part -V

[VelMurugan]

ORACLE

Company Profile

Oracle's leadership, vision, and commitment to customers have made the company the world's largest enterprise software company, providing software and services to enterprises around the globe.

Placement Papers

DATABASE

1. 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

2. Find the ODD one out of the following    
    a OPEN
    b CLOSE
    c INSERT
    d FETCH
    Ans C

3. 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

4. Which of the following is NOT VALID in PL/SQL ?
     a Select ... into
     b Update
     c Create
     d Delete
     Ans : C

5. What is the Result of the following 'VIK'||NULL||'RAM' ?              
     a Error  
     b VIK RAM
     c VIKRAM
     d NULL  
     Ans : C

6. 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

7. Does the Database trigger will fire when the table is TRUNCATED ?
     a Yes
     b No
     Ans : B

8. SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return                  
    a ALWAY
    b S ALWA
    c ALWAYS
   Ans : C

9. 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

10. TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return
     a 333234
     b 333333
     c 234333
     d None of the above
     Ans : A

11. EMPNO    ENAME       SAL
     A822 RAMASWAMY  3500
     A812 NARAYAN       5000
     A973 UMESH           2850
     A500 BALAJI           5750
   Use these data for the following Questions
    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

12. Is it possible to modify a Datatype of a column when column contains data ?
     a Yes
     b No
     Ans B

13. 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

14. Which is not part of the Data Definiton Language ?
     a CREATE
     b ALTER
     c ALTER SESSION
     Ans : C

15. The Data Manipulation Language statements are
     a  INSERT
     b  UPDATE
     c  SELECT
     d  All of the above
     Ans : D

16. 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
      Ans : C

17.  If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE ?
      a Will
      b Won't
      Ans : B

18.  What are the different events in Triggers ?
      a Define, Create
      b Drop, Comment
      c Insert, Update, Delete
      d All of the above
      Ans : C

19.  What built-in subprogram is used to manipulate images in image items ?
      a Zoom_out
      b Zoom_in'
      c Image_zoom
      d Zoom_image
      Ans : C

20.  Can we pass RECORD GROUP between FORMS ?
      a Yes
      b No
      Ans : A

21.  SHOW_ALERT function returns
      a Boolean
      b Number
      c Character
      d None of the above
      Ans : B

22. What SYSTEM VARIABLE is used to refer DATABASE TIME ?          
     a $$dbtime$$
     b $$time$$
     c $$datetime$$
     d None of the above
     Ans : A

23. SYSTEM.EFFECTIVE.DATE varaible is
     a Read only
     b Read & Write
     c Write only
     d None of the above
     Ans : C

24.  How can you CALL Reports from Forms4.0 ?
      a Run_Report built_in
      b Call_Report built_in
      c Run_Product built_in
      d Call_Product built_in
     Ans : C

25. When do you get a .PLL extension ?
     a Save Library file
     b Generate Library file
     c Run Library file
     d None of the above
     Ans  : A

Download : http://www.itacumens.com/profiles/pp/pp_oracle.doc