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)
 

6)When a subprocedure will be declared within a procedure?
 

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

8)  Trigger syntax declaration without the option for each row is legal(T/F)
ans:T
 

9) Tablespace contains physical data(T/F)
ans:T
 

10) Rowid is a pseudo column of every oracle table (T/F)
11) Lpad and Rpad have default pad character is space (T/F)
 

12) when %ROWCOUNT is 0 what will happen
i)NO_DAT_FOUND exception will raise
ii)%FOUND will be false