1Z0-149 Online Practice Questions and Answers

Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

A. In line 1, change IN OUT mode to IN mode.

B. In line 2, change IN OUT mode to IN mode.

C. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

D. In line 1, add the default parameter DEFAULT 2000.

E. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

F. In line 2, add the default parameter DEFAULT 2000.

Which three are true about functions and procedures? (Choose three.)

A. The ACCESSIBLE BY clause can be used only for procedures.

B. In a function, every execution path must lead to a RETURN statement.

C. Both can have only constants as actual parameters for IN mode parameters.

D. Both can be invoked from within SQL statements.

E. In a procedure the RETURN statement cannot specify an expression.

F. In a function every RETURN statement must specify an expression.

Which two are true about lexical units? (Choose two.)

A. Character literals are case-sensitive.

B. Spaces can be embedded in delimiters.

C. Identifiers include labels.

D. A character literal with zero characters has the BOOLEAN value NULL.

E. All user-defined identifiers must start with an alphabet.

Which three are true about PL/SQL subprograms? (Choose three.)

A. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

B. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.

C. Subprograms are cached by default and shared among users, thereby reducing memory requirements.

D. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

E. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.

F. Host variables can be referenced inside any PL/SQL subprogram.

G. A PL/SQL procedure can invoke an external code block written in a different programming language.

In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.

A row exists with EMPLOYEE_ID 201.

Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.

Which two will execute successfully? (Choose two.)

A. Call HR.HELPER.H1 from the HR schema.

B. Call HR.HELPER.H1 from the SH schema.

C. Call HR.API.P1 from the HR schema.

D. Call HR.API.P1 from the SH schema.

E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Which two are true about packages? (Choose two.)

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

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

C. Package specifications can be compiled without their bodies.

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

E. A package definition must have a specification and body.

Which two are true about collections and RECORD types? (Choose two.)

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

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

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

D. Collections and RECORD types are always dense.

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

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

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000. With which option must "---placeholder" be replaced?

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

Examine these facts:

Table EMP exists in schema USERA with columns SALARY and EMP_ID.

EMP_ID is the primary key with values ranging from 1 to 100.

USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.

USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.

USERB now executes these statements:

conn userB/userB@pdb1

execute userA.myproc;

Which is true?

A. It results in an error because Authid Current_User is missing from MYPROC.

B. It results in an error because Authid Definer is missing from MYPROC.

C. It results in an error because USERB doesn't have select privilege on USERA.EMP.

D. It executes successfully.

Which two are true about exception handling? (Choose two.)

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.