Use Free 1Z0-149 Exam Questions that Stimulates Actual EXAM [Q40-Q56]

1Z0-149 Oracle

admin • October 16, 2023

Use Free 1Z0-149 Exam Questions that Stimulates Actual EXAM [Q40-Q56]

Rate this post

Use Free 1Z0-149 Exam Questions that Stimulates Actual EXAM

Get 100% Real 1Z0-149 Free Online Practice Test

Oracle 1z1-149 exam is an excellent opportunity for IT professionals to demonstrate their expertise in PL/SQL programming and earn a valuable certification that can boost their career prospects. With the right preparation and dedication, candidates can successfully pass the exam and validate their skills in this critical area of database development.

Q40. Examine this DECLARE section:

Which line will cause an error upon execution?

line 5

line 3

line 2

line 4

line 6

Q41. 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

Q42. Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

Q43. 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.

Q44. Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

DISABLE

ENABLE

ERROR

ALL

SEVERE

Q45. In which type of trigger can :OLD and :NEW identifiers be used?

ROW

AFTER SUSPEND

AFTER STATEMENT

BEFORE STATEMENT

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

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

Q47. Which is the correct method to implement a local subprogram in an anonymous block?

Q48. 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.

Q49. 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.

Q50. Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

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

Q51. 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.

Q52. For which three SYSTEM EVENTS can triggers be created? (Choose three.)

DDL

AFTER AUDIT

BEFORE ANALYZE

SHUTDOWN

SERVERERROR

STARTUP

BEFORE GRANT

Q53. 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.

Q54. Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

The actual parameters must be specified in the same order as the formal parameters are declared.

Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

Only trailing optional parameters can be omitted in the invocation call.

The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

Any optional parameters can be omitted in the invocation call.

Q55. 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?