[Nov 22, 2023] Valid 1z1-149 Test Answers Full-length Practice Certification Exams [Q22-Q39] : Exam for engine : http://blog.test4engine.com

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

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.

NO.23 Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

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

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

This clause can be used only for procedures and functions.

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

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

NO.24 Which three are true about anonymous blocks and subprograms? (Choose three.)

Named subprograms cannot be called from other packages.

PROCEDURE subprograms can accept parameters.

A FUNCTION subprogram must return one or more values.

Anonymous blocks cannot use packaged variables.

Named subprograms are stored in the database server.

Anonymous blocks must always start with the Declare keyword.

FUNCTION subprograms must be called and passed through one or more parameters.

NO.25 Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

The default value is NATIVE.

If set to NATIVE, programs are stored in platform dependent machine code.

It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

If set to NATIVE, programs are stored in a PL/SQL bytecode format.

NO.26 Which three are true about DDL triggers? (Choose three.)

They cannot include the WHEN clause.

They must be created in an enabled state.

They can be fired when a table is truncated.

They fire only when a DDL statement is executed by the owner of the trigger.

They can be fired either before or after a DDL statement executes.

They can be fired when a privilege is granted to a user.

They must be created in a disabled state.

NO.27 Which is true about the PLSCOPE_SETTINGS parameter?

It is deprecated in Oracle 12c.

It can be used to obtain information about all identifiers when compiling a procedure.

It can be used to control execution of specific portions of the PL/SQL code conditionally.

It can be used to control a user’s privileges on PL/SQL objects at run time.

NO.28 Which two blocks of code display a numerical zero? (Choose two.)

NO.29 Which three are true about user-defined functions? (Choose three.)

They can be used in ORDER BY and GROUP BY clauses.

They can be executed as standalone commands.

They must be defined with at least one parameter.

They need not return any values.

They can appear in the select list of a SELECT statement.

Functions can call only other functions.

They can be used in CONNECT BY and START WITH clauses.

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

The ACCESSIBLE BY clause can be used only for procedures.

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

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

Both can be invoked from within SQL statements.

In a procedure the RETURN statement cannot specify an expression.

In a function every RETURN statement must specify an expression.

NO.31 Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

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

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.

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

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

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.

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

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

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

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

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

NO.34 Which three statements are true about passing parameters to subprograms? (Choose three.)

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

NO.35 Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

It can be used in the declaration of object types.

It must be specified in the heading of a package specification.

The check is enforced by this clause for direct access and access through dynamic SQL.

It can be used for individual procedures and functions declared in a package specification.

It must be specified in the heading of a package body.

NO.36 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?

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

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

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

It executes successfully.

NO.37 Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

line 1

line 6

line 8

line 2

line 3

line 7

NO.38 Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

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

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

All declared exceptions are raised implicitly by the runtime system.

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

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

Predefined exceptions are globally declared in the standard package.