[Nov 17, 2023] Prepare For The 1Z0-149 Question Papers In Advance [Q20-Q37]

Rate this post

[Nov 17, 2023] Prepare For The 1Z0-149 Question Papers In Advance

1Z0-149 PDF Dumps Real 2023 Recently Updated Questions

Oracle 1z1-149 exam covers a wide range of topics related to Oracle Database 19c and PL/SQL programming. These topics include fundamental concepts of database management, data modeling, SQL programming, and PL/SQL programming. 1Z0-149 exam also tests the candidate’s ability to create and manage database objects, write and execute PL/SQL code, and troubleshoot common issues related to database programming.

QUESTION 20
Which is true about counter variables in a FOR loop?

It is accessible outside the body of the loop.

It cannot be NULL.

It must explicitly be declared.

It can be modified in the body of the loop.

QUESTION 21
Examine these statements:

Which two are true? (Choose two.)

Neither table will have a row inserted and committed.

Both tables will have a row inserted and committed.

The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

The bank_activity_proc will not compile because of the commit.

Only one table will have a row inserted and committed.

QUESTION 22
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.

QUESTION 23
Which two are true about INDEX-BY tables? (Choose two.)

The index can be integer or string.

The index can be integer only.

INDEX-BY table types can be created in PL/SQL blocks only.

INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

INDEX-BY table types can be created with the CREATE TYPE statement.

QUESTION 24
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.

QUESTION 25
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.

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

QUESTION 27
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

QUESTION 28
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.

https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

QUESTION 29
Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

5000

15000

2500

10000

QUESTION 30
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.

QUESTION 31
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

The NOCOPY hint asks the compiler to pass the actual parameters by reference.

A deterministic function’s results always depend on the state of session variables.

The NOCOPY hint asks the compiler to pass the actual parameters by value.

A function is deterministic if it always returns the same result for a specific combination of input values.

The PARALLEL_ENABLE clause can be specified for a nested function.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

QUESTION 32
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.

QUESTION 33
Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

It will return an error at line 2.

It will return an error at line 3.

It will return an error at line 8.

It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

QUESTION 34
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

It will fail at lines 6 and 7.

It will fail only at line 7.

QUESTION 35
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.

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

DISABLE

ENABLE

ERROR

ALL

SEVERE

QUESTION 37
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.

Loading …

Oracle 1Z0-149 certification exam is designed for individuals who want to demonstrate their knowledge and skills in programming with PL/SQL using Oracle Database 19c. PL/SQL is a procedural language used in Oracle Database to develop efficient and powerful database applications. Oracle Database 19c: Program with PL/SQL certification exam is intended for developers, database administrators, and anyone interested in learning how to use PL/SQL to build robust database applications.

1Z0-149 Dumps and Practice Test (67 Exam Questions): https://www.examstorrent.com/1Z0-149-exam-dumps-torrent.html

admin

You May Also Like

Leave a Reply Cancel reply