MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Pl/Sql
Quiz 3
1
2
3
4
5
6
7
8
9
10
Q.1
Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?
Syntax error
Runtime error
Both A & B
None of the above
Q.2
Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?
PLS_INTEGER
NUMBER
Both A & B
None of the above
Q.3
PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?
Procedure
Function
Both A & B
None of the above
Q.4
________ does not correlate with an oracle error, instead, user_defineexceptions usually enforce business rules in situationsin which an oracle error would not necessarily occur
Predefined Exception
Internal Exception
User defined Exception
None of the above
Q.5
For a user-defined exception, SQLCODE returnsand SQLERRM returns ___________.
“User-defined Exception”
SQLCODE
0
Both A & B
Q.6
Which of the following is handled with the help of exception-handling section in an PL/SQL block.For eg, SELECT INTO statement, which does not return any rows.
A runtime error
A syntax error
Both A & B
None of the above
Q.7
To handle raised exceptions, you write separate routines called exception handlers.
Yes
No
Q.8
Which keyword is used instead of the assignment operator to initialize variables?
NOT NULL
DEFAULT
%TYPE
%ROWTYPE
Q.9
Which statements execute a sequence of statements multiple times?
EXIT
LOOP
Both A & B
None of the above
Q.10
Which of the following returns the current error message text?
SQLERRM
SQLCODE
Both A & B
None of the above
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page