Patni Technical - Database

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

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

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

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