PL/SQL Assessment Test! Trivia Quiz
(93).jpg "PL/SQL Assessment Test! Trivia Quiz - Quiz")
PL/SQL assessment test trivia quiz! We have a questionnaire designed for system developers who want to test out just how much they know about the system query languages and how to carry them out. If you feel like you are up to the challenge, take up the quiz and share it with others to see how smart you are compared to them on the topic. All the best!
- 1.
What is the meaning of PL?- A.
Project language
- B.
Procedural language
- C.
Purpose language
- D.
Programming language
- 2.
What is an exception in PL/SQL?
- A.
The error handling part of PL/SQL
- B.
The role part of PL/SQL
- C.
The joint part of PL/SQL
- D.
The column part of PL/SQLl
- 3.
What are the two types of exceptions?
- A.
Username and password
- B.
Admin and user
- C.
System and user
- D.
User_defined and predefined
- 4.
Which of these is called a statement in PL/SQL?
- A.
Function
- B.
Table
- C.
Procedure
- D.
Exception
- 5.
All of these rules applies to nulls while making comparisons except...
- A.
Null cannot be equal or unequal to other values
- B.
If a value is null then the expression itself is null
- C.
Null can only be false
- D.
Null can only be true
- 6.
How many data types are available in PL/SQL?
- A.
3
- B.
8
- C.
4
- D.
5
- 7.
What are the two types of cursor in PL/SQL?
- A.
Open and Close cursor
- B.
Implicit and Explicit cursor
- C.
In and Out cursor
- D.
Entry and Exit cursor
- 8.
Which of these activities all rows in a table when enabled?
- A.
Trigger
- B.
Constraints
- C.
Block
- D.
Functions
- 9.
A table which is currently being changed by DML is called a...
- A.
Constraining table
- B.
Cursive table
- C.
Moving table
- D.
Mutating table
- 10.
Variables which are declared in procedure headings and referenced in the procedure body are called...
- A.
Variables
- B.
Procedural variables
- C.
Actual parameters
- D.
Formal parameters
Questions: 35 | Attempts: 16493 | Last updated: Mar 22, 2022
-
Sample QuestionWhich of the following statements contains an error?
Questions: 10 | Attempts: 4397 | Last updated: Apr 20, 2022
-
Sample QuestionHow many tables may be included with a join?
Questions: 40 | Attempts: 4396 | Last updated: Aug 22, 2022
-
Sample QuestionExamine this function: CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which statement will successfully invoke this function in SQL *Plus?
Back to top