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

[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. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint
     a Yes
     b No
     Ans : B

2. A column defined as PRIMARY KEY can have NULL's
    a TRUE
    b FALSE
    Ans : B

3. A Transaction ends
     a Only when it is Committed
     b Only when it is Rolledback
     c When it is Committed or Rolledback
     d None of the above
     Ans : C

4. A Database Procedure is stored in the Database                                
    a In compiled form
    b As source code
    c Both A & B
    d Not stored
    Ans : C

5. A database trigger doesnot apply to data loaded before the definition of the trigger
     a TRUE
     b FALSE
     Ans : A

6.  Dedicated server configuration is
     a One server process - Many user processes
     b Many server processes - One user process
     c One server process - One user process
     d Many server processes - Many user processes
     Ans : C

7. Which of the following does not affect the size of the SGA
     a Database buffer
     b Redolog buffer
     c Stored procedure
     d Shared pool
     Ans : C

8. What does a COMMIT statement do to a CURSOR
     a Open the Cursor
     b Fetch the Cursor
     c Close the Cursor
     d None of the above
    Ans : D

9. Which of the following is TRUE
     1 Host variables are declared anywhere in the program  
     2 Host variables are declared in the DECLARE section
     a Only 1 is TRUE
     b Only 2 is TRUE
     c Both 1 & 2are TRUE
     d Both are FALSE
     Ans : B

10. Which of the following is NOT VALID is PL/SQL
     a Bool boolean;
     b NUM1, NUM2 number;
     c deptname dept.dname%type;
     d date1 date := sysdate
     Ans : B

11  Declare
     fvar number := null; svar number := 5
     Begin
     goto << fproc>>
     if fvar is null then
     << fproc>>
     svar := svar + 5
     end if;
     End;
     What will be the value of svar after the execution ?
     a Error
     b 10
     c 5
     d None of the above
     Ans : A

12. Which of the following is not correct about an Exception ?
    a Raised automatically / Explicitly in response to an ORACLE_ERROR
    b An exception will be raised when an error occurs in that block
    c Process terminates after completion of error sequence.
    d A Procedure or Sequence of statements may be processed.
   Ans : C

13. Which of the following is not correct about User_Defined Exceptions ?            
     a  Must be declared
     b  Must be raised explicitly
     c   Raised automatically in response to an Oracle error
     d   None of the above
     Ans : C

14. A Stored Procedure is a
     a Sequence of SQL or PL/SQL statements to perform specific function
     b Stored in compiled form in the database
     c Can be called from all client environmets
     d All of the above
     Ans : D

15. Which of the following statement is false
     a Any procedure can raise an error and return an user message and error number
     b Error number ranging from 20000 to 20999 are reserved for user defined messages
     c Oracle checks Uniqueness of User defined errors
     d Raise_Application_error is used for raising an user defined error.
     Ans : C

16. Is it possible to open a cursor which is in a Package in another procedure ?
     a Yes
     b No
     Ans : A

17.  Is it possible to use Transactional control statements in Database Triggers?          
     a Yes
     b No
     Ans : B

18.  Is it possible to Enable or Disable a Database trigger ?
     a Yes
     b No
     Ans : A

19.  PL/SQL supports datatype(s)
      a Scalar datatype
      b Composite datatype
      c All of the above
      d None of the above
      Ans C

20.  Find the ODD datatype out
     a VARCHAR2
     b RECORD
     c BOOLEAN
     d RAW
     Ans : B

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