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

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

C.Collections can be implicitly converted to records.

D.Implicit data type conversion can negatively impact performance.

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

A.%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

B.%Isopen is always false in Implicit Cursor.

C.%Isopen is always false in Explicit Cursor.

D.Implicit cursor returns only one record.

E.Explicit cursor can return more than one record.

F.%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

G.%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

A.It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

B.It will result in a compilation error for protected_proc because calling_proc does not exist.

C.It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

D.With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

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

B.This clause can be used only for procedures and functions.

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

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

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

A.The number of fields must match the number of columns in a table.

B.They can be returned from a function.

C.Field types must match column types.

D.Field names must match selected column names.