[Q36-Q59] 2023 Updated 1Z0-149 Tests Engine pdf – All Free Dumps Guaranteed!

5/5 - (3 votes)

2023 Updated 1Z0-149 Tests Engine pdf – All Free Dumps Guaranteed!

Latest Oracle Database PL/SQL Developer Certified Professional 1Z0-149 Actual Free Exam Questions

Oracle 1z1-149 certification exam consists of 70 multiple-choice questions and has a duration of 105 minutes. 1Z0-149 exam covers a broad range of topics, such as PL/SQL program structure, data manipulation, and advanced PL/SQL concepts. Candidates are required to demonstrate their ability to write efficient and effective PL/SQL code, as well as to troubleshoot and debug PL/SQL programs. Additionally, the exam evaluates the candidate’s knowledge of security and performance issues related to PL/SQL.

NO.36 Which is true about EXIT and CONTINUE statements?

They can be used in any type of loop.

They must have a WHEN condition.

They have the same effect on the execution of a loop.

They must use labels.

NO.37 Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

Implicit cursor returns only one record.

Explicit cursor can return more than one record.

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

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

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

%Isopen is always false in Explicit Cursor.

%Isopen is always false in Implicit Cursor.

NO.38 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.39 Which three are valid PL/SQL variable names? (Choose three.)

printer_name#

1to7number

yesterday’s_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

NO.40 Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

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.

NO.41 Which three are true about the procedure overloading feature? (Choose three.)

Each procedure can be a nested subprogram.

Each procedure’s formal parameters can differ in data type or name.

Each procedure must use named notation to specify the corresponding actual parameters.

Each procedure’s formal parameters must differ in name.

Each procedure can be a packaged subprogram.

Each procedure must use positional notation to specify the corresponding actual parameters.

Each procedure can be a standalone subprogram.

NO.42 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.43 Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

NO.44 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.45 Examine this code:
ALTER SESSION SET plsql_warnings=’ENABLE:ALL’;
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to ‘ENABLE: ALL’?

It fails compilation.

There are no compilation warnings or errors.

A severe compilation warning is generated.

A performance compilation warning is generated.

An information compilation warning is generated.

NO.46 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.)

Call HR.HELPER.H1 from the HR schema.

Call HR.HELPER.H1 from the SH schema.

Call HR.API.P1 from the HR schema.

Call HR.API.P1 from the SH schema.

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

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

DDL

AFTER AUDIT

BEFORE ANALYZE

SHUTDOWN

SERVERERROR

STARTUP

BEFORE GRANT

NO.48 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.)

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

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

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

In line 1, add the default parameter DEFAULT 2000.

In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

In line 2, add the default parameter DEFAULT 2000.

NO.49 SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

NO.50 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.51 Examine these statements from a block of code:

Which two are true? (Choose two.)

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.

NO.52 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.53 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?

NO.54 Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?