Sample papers >>  
                                                                
   PCS(Patini Computers)- Question paper - 02   Conducted On -- -2003   
  1. A package without body is possible.(T/F)ans:T

  2. Subprograms have equal scope as variables.(T/F)

  3. Can a cursor be closed for two times(T/F)ans:F

  4. Transaction function can be used in trigger(T/F)ans:F

  5. DDL can be used in trigger(T/F)ans:T

  6. A trigger name can have the same name as that of its base table name(T/F)ans:T           Freshersworld.com

  7. In a PL/SQL block a variable and a table name both are same then which will get highest precedence.

  8. Is PL/SQL reserved words can be used in SQL Ans:It can be used with quotation.

  9. How to write a single quote in SQL
    i)"" ii)''' iii)''

  10. Can a labeled go to statement goto the inner loop(T/F)ans:F

  11. Which are the mandatory parts of PL/SQL procedure.

  12. SQL%ISOPEN for implicit cursor is always evaluateto false(T/F)ans:T

  13. Any variable not declared in the declare part assigns value ......

  14. For cursor %NOTFOUND and for PL/SQL 
    NO_DATA_FOUND(exception)gives the same result.(T/F)ans:T                         Freshersworld.com

  15. If exception occured in the exception then it will
    i)raise in the same block
    ii)raise in the outer block
    iii)not raise in the same block

  16. PMON command is used for__________

  17. Select * from emp where emp_no=1;
    If exist then dbms_output_putline(".....")
    else dbms_output_putline("error")
    end if;
    what will be the output choices are there

  18. If for Update lock is absent then will there any error in the 
    following statement
    select * from emp;
    choices are there.ans is there will no error

  19. Can a inbuilt exception be redifined by a user(T/F)ans:F                                     Freshersworld.com

  20. var table.value%type;
    var=5;
    insert into table(value) values(var);
    for var in reverse 4..6
    loop
    insert into table(value) values(var);
    end loop;
    insert into table(value) values(var);
    i)56545
    ii)56544(ans)
    iii)56555
    iv)65445

  21. can a function overloaded differed by
    i)the no of parameters and its type only
    ii)their return type
    iii)
    iv)

  22. Raise_application_error is used for.........

  23. In SQL SGA area the parser tree and exceptions are stored which                      Freshersworld.com
    are used for multiple applications(T/F)ans:F

  24. PRAGMA_EXCEPTION_INIT(mssge,code no)......

  25. exceptions are executed at
    i)compile time
    ii)runtime(ans)

  26. When a subprocedure will be declared within a procedure?
    i)at the end of the declaration
    ii).......
    iii)....

  27. Record1 and record2 are declared.each record has two fields 
    with same datatypes.
    i)Record1:=Record2;
    ii)Record1.field1:=Record2.field1;
    iii)Record1.field2:=Record2.field2;
    a)only i is legal
    b)only ii and iii are legal
    c)all are legal
    d)none is legal

  28. Trigger syntax declaration without the option for each row is                                   Freshersworld.com
    legal(T/F)ans:T

  29. Tablespace contains physical data(T/F)ans:T

  30. Rowid is a pseudo column of every oracle table(T/F)

  31. Lpad and Rpad have default pad character is space(T/F)

  32. When %ROWCOUNT is 0 what will happen
    i)NO_DAT_FOUND exception will raise
    ii)%FOUND will be false

Google
 
Web freshersworld.com

 Copyright © 2004 Freshersworld.com, All rights reserved.