Oracle Database 19c: Program with PL/SQL 1z0-149 Exam Questions with Experts Answers Updated Recently

A.  

RAW data types are always implicitly converted to a CLOB when used in a query.

B.  

Collections can be implicitly converted to records.

C.  

ROWIDS are always implicitly converted to a number when used in a query.

D.  

Comparison between character value and a number value always implicitly converts the character value to the number data type.

E.  

Implicit data type conversion can negatively impact performance.

A.  

Function based indexes remain usable when replacing the function on which the index depends.

B.  

Object privileges to execute a replaced function must be regranted to those users who had the privilege.

C.  

This clause can be used only for procedures and functions.

D.  

A function definition can be modified without dropping and re-creating it.

E.  

Object privileges to execute a replaced function are retained by those users who had the privileges.

A.  

B.  

C.  

D.  

A.  

Internally defined exceptions can be handled only by the OTHERS exception handler.

B.  

All declared exceptions are raised implicitly by the runtime system.

C.  

User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

D.  

Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

E.  

Predefined exceptions are globally declared in the standard package.