×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In a PL/SQL block, when a query returns an entire row of a table, which of the following attributes is used to declare a 'TYPE' variable?
2.
In PL/SQL, which of these composite data types should you use if a query returns columns from different tables?
3.
In PL/SQL, the cursor is declared as _________.
4.
How does the cursor declare the %ROWTYPE attribute in PL/SQL?
5.
In PL/SQL, which of the following features is included in database triggers?
6.
What value will the variable a hold in the following PLSQL code:
declare
a number;
begin
update Books set status = 'fired'
where name like '%Blogs';
a: = sql % rowcount;
end;
a number;
begin
update Books set status = 'fired'
where name like '%Blogs';
a: = sql % rowcount;
end;
7.
Which of the following is a user-defined exception in PL/SQL?
8.
Which of the following is the correct way to call a function in a PL/SQL block?
9.
In PL/SQL, when a DML is issued in Oracle, which type of cursor is associated with the query in?
10.
What does the EXTEND method do in PL/SQL?