×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In which other best possible way can the following query be rewritten:
Select name, book_id from books, teaches where books_ID = teaches_ID;
2.
Consider the following SQL code:
The exception accounting.ex_overbooked is a ______________________.
PACKAGE accounting AS
ex_overbooked EXCEPTION;
END accounting;
ex_overbooked EXCEPTION;
END accounting;
The exception accounting.ex_overbooked is a ______________________.
3.
You have created an SQL procedure with the following header:
Assuming that the referenced variable is declared correctly, which of the following is a valid call to the procedure?
Procedure ASSIGNMENT(ASSIGNMENT_DATE OUT DATE);
Assuming that the referenced variable is declared correctly, which of the following is a valid call to the procedure?
4.
In PL/SQL, what is the output of func(21) for the following:
CREATE OR REPLACE FUNCTION func(f VARCHAR2)
RETURN PLS_INTEGER
IS
BEGIN
IF NVL(LENGTH(f), 1) = 1
THEN
RETURN INSTR('0123456789ABCDEF', f) - 1;
ELSE
RETURN 16 * func(SUBSTR(f, 1, LENGTH(f) - 1)) + INSTR('0123456789ABCDEF', SUBSTR(f, -1)) - 1;
END IF;
END func;
RETURN PLS_INTEGER
IS
BEGIN
IF NVL(LENGTH(f), 1) = 1
THEN
RETURN INSTR('0123456789ABCDEF', f) - 1;
ELSE
RETURN 16 * func(SUBSTR(f, 1, LENGTH(f) - 1)) + INSTR('0123456789ABCDEF', SUBSTR(f, -1)) - 1;
END IF;
END func;
5.
Which of the following is not a predefined exception in PL/SQL?
6.
What does the EXTEND(n,i) method do in PL/SQL?
7.
What does the TO_DSINTERVAL(x) function do in PL/SQL?
8.
In PL/SQL, which of the following processes is used to advance the cursor to the next row in the active set when a fetch command is executed?
9.
Which of the following definitions describesstring literals in PL/SQL?
10.
What is the substitute for objects and units in a PL/SQL program?