1z0-149 Practice Exam Questions with Answers Oracle Database 19c: Program with PL/SQL Certification

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

Collections can be implicitly converted to records.

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

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

Implicit data type conversion can negatively impact performance.

The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

Only the PRICE column can be updated in the PRODUCTS table.

The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

A variable of RECORD type can contain fields of another RECORD type or any collection type.

Only associative arrays and nested tables can have elements of RECORD type.

All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

Collections and RECORD types are always dense.

All collections and RECORD types can be stored in table columns.

VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Error in inner block

Error in inner block Error in outer block

Error in inner block Error in calling block

Error in inner block Error in outer block Error in calling block

a record declared in an anonymous block

a record declared in a procedure

an associative array indexed by PLS_INTEGER

a record declared in a package specification

a predefined PL/SQL-only data type like BOOLEAN

an associative array indexed by VARCHAR2

Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

Package specifications can be compiled without their bodies.

Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

A package definition must have a specification and body.

DECLARE

OPEN

INTO

OPEN-FOR

FETCH

WHEN

CLOSE

printer_name#

1to7number

yesterday's_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

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

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

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

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

ROW

AFTER SUSPEND

AFTER STATEMENT

BEFORE STATEMENT

DISABLE

ENABLE

ERROR

ALL

SEVERE

This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

This program unit will compile successfully.

Initialization of min_bal can be done while using this packaged constant in another program.

Initialization of loan_amount can be done while using this packaged variable in another program.

This will not compile successfully because the min_bal constant must be initialized.

This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.