Mock Oracle Test -DBMS SQL,PL/SQL
5 Questions
|
By Pras027 | Updated: Mar 22, 2022
| Attempts: 3278

Settings
1.
A record is a collection of individual fields that represents a row in the table.
2.
What is the correct order for steps of initialing the cursor?
a.FETCH
b.OPEN
C.Declare
d.close
A. 
B. 
C. 
D. 
3.
User-defined SUBTYPES are subtypes based on an existing type.
4.
%ROWTYPE is used to declare a variable with the same datatype as a column of a specific table
5.
While using FOR loop,Upper_Bound and Lower_Bound must be integers.
Back to top