PCS (Patni) Paper

Paper Type : Technical - Database
Posted By : admin


Sample Test Paper

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

Related Articles :