Skip to content Oracle
1Z0-149
90 Minutes
65
Oracle Database 19c: Program with PL/SQL
A: They can be returned from a function.
B: Field types must match column types.
C: The number of fields must match the number of columns in a table.
D: Field names must match selected column names.
A: PACKAGES
B: VARIABLES
C: ANONYMOUS BLOCK
D: TRIGGER BODY
E: DATABASE LINKS
A: Implicit cursor returns only one record.
B: Explicit cursor can return more than one record.
C: %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
D: %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
E: %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
F: %Isopen is always false in Explicit Cursor.
G: %Isopen is always false in Implicit Cursor.
A: They can be used in ORDER BY and GROUP BY clauses.
B: They can be executed as standalone commands.
C: They must be defined with at least one parameter.
D: They need not return any values.
E: They can appear in the select list of a SELECT statement.
F: Functions can call only other functions.
G: They can be used in CONNECT BY and START WITH clauses.
