Patni Computer Services(PCS) Sample Paper Paper - 35

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
    

---

What is the angle between teo hands of a clock when time is 8-30 ans:75(appro) A student is ranked 13th from right and 8th from left.how many are there(similer) a,b,c,d,e,f are arranged in a circle b is to right of c and so on(rs aggrewal) chain rule(workamp;time) Puzzle test.some data is given and he asked three qustions below.based on data we have to answer. six questions on venn diagrams 5 years ago sum of ages of father and son ans:40,10 8.assertion and reasoning 1.cloudsnbsp; 2.capital city of dweloped corentiranbsp; ans for both is :a Man walks east amp; from turns to right amp; from to left amp;then 45degrees to right.in which direction he went ans:north west aa-b-bb-aaa- 96,85,....(a series with diff 11),3,15,45,....,total 3 questions are given on series A student got 70% in one subject,80% in other.to get overall 75% how much he should get in third subject. A news pwper must have a.news b.advertizements 3.editor 4.date 5.paper If clouds are air, air are water and so on where birds fly? press,cinema,tv ans:mass media qustions on rs aggrewal relations i.e first few chapters ofnbsp; aggrewal(english) A man showed to a woman sitting in a pack amp; told to his friend.she is the daughter of my grand mother only son ans:daughter nbsp; Group Disscussion Topic If you become muncipal corporater what steps you take to develop your area. If you become administrative officer of this university what steps you take to improve standards. Tell what are the seven problems in calcutta and solutions to problems? Abortion is legal or illegal