×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In PL/SQL, which of the following keywords is used to create a user defined cursor?
2.
In PL/SQL, what type of cursor is declared by Oracle?
3.
Which of the following clauses is used to modify an existing function in PL/SQL?
4.
How is an anonymous PL/SQL block created?
5.
Which of these is not represented by an identifier in PL/SQL?
6.
In PL/SQL, which of the following queries will produce an error?
7.
What does the following PL/SQL query do:
DECLARE
Books VARCHAR2(64);
BEGIN
SELECT title INTO Books
FROM
TABLE(SELECT courses FROM Library WHERE name = 'chetan')
WHERE name LIKE '%2 States%';
END;
Books VARCHAR2(64);
BEGIN
SELECT title INTO Books
FROM
TABLE(SELECT courses FROM Library WHERE name = 'chetan')
WHERE name LIKE '%2 States%';
END;
8.
Which of the following is a collection method in PL/SQL?
9.
In PL/SQL, which of the following methods can not be called from SQL statements?
10.
Which of the following methods can not be used with associative arrays in PL/SQL?