Patni Placement Paper III

Patni Placement Paper Technical(PL/SQL) 2008 @ Chennai

Technical Questions:

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

Patni Placement Paper II

Patni Placement Paper Technical 2008 @ Gujarat

1) PMON command is used for__________
 

2) Can an inbuilt exception be redifined by a user(T/F)ans:F
 

3) Raise_application_error is used for……….
4) In SQL SGA area the parser tree and exceptions are stored which are used for multipleapplications (T/F)
ans:F
 

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

Patni Placement Paper I

Patni Placement Paper Technical 2009 @ Orissa

1. An index is automatically generated with the following constraints.
a. Check
b. Not null
c. Primary key
d. Foreign key
 

2. Select mod(16,3) from emp;
a. 1
b. 2
c. 3
d. Error in the stmt