Technical - Database Paper - 20

Sample Test Paper

A package without body is possible.(T/F)ans:T

Subprograms have equal scope as variables.(T/F)

Can a cursor be closed for two times(T/F)ans:F

Transaction function can be used in trigger(T/F)ans:F

DDL can be used in trigger(T/F)ans:T

A trigger name can have the same name as that of its base table name(T/F)ans:T

In a PL/SQL block a variable and a table name both are same then which will get highest precedence.

Is PL/SQL reserved words can be used in SQL Ans:It can be used with quotation.

How to write a single quote in SQL
i)"" ii),,, iii),,

Can a labeled go to statement goto the inner loop(T/F)ans:F

Which are the mandatory parts of PL/SQL procedure.

SQL%ISOPEN for implicit cursor is always evaluateto false(T/F)ans:T

Any variable not declared in the declare part assigns value ......

For cursor %NOTFOUND and for PL/SQL
NO_DATA_FOUND(exception)gives the same result.(T/F)ans:T

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

PMON command is used for__________

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

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

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

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

can a function overloaded differed by
i)the no of parameters and its type only
ii)their return type
iii)
iv)

Raise_application_error is used for.........

In SQL SGA area the parser tree and exceptions are stored which
are used for multiple applications(T/F)ans:F

PRAGMA_EXCEPTION_INIT(mssge,code no)......

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

When a subprocedure will be declared within a procedure?
i)at the end of the declaration
ii).......
iii)....

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

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

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

Rowid is a pseudo column of every oracle table(T/F)

Lpad and Rpad have default pad character is space(T/F)

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