-
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
Freshersworld.com
-
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
Freshersworld.com
-
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
Freshersworld.com
-
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
Freshersworld.com
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
Freshersworld.com
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