Current 1Z0-149 Exam Dumps [2023] Complete Oracle Exam Smoothly [Q40-Q58]

4.1/5 - (8 votes)

Current 1Z0-149 Exam Dumps [2023] Complete Oracle Exam Smoothly

1Z0-149 Premium PDF & Test Engine Files with 67 Questions & Answers

Oracle 1Z0-149 exam consists of 80 multiple-choice questions that must be completed within 105 minutes. 1Z0-149 exam covers a wide range of topics, including PL/SQL program units, collections, error handling, and security. To pass the exam, you need to score at least 63% or higher. Oracle Database 19c: Program with PL/SQL certification can help you demonstrate your expertise in PL/SQL programming and enhance your career opportunities.

What is the prerequisite for taking the Oracle 1Z0-149 Certification Exam:

The prerequisites for the 1Z0-149 Exam are:

Familiarity with SQL and PL/SQL is very helpful
Experience in the IT industry
Working knowledge of the Oracle Database

QUESTION 40
Examine these statements and output:

The procedure is created successfully.

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

QUESTION 41
Which block of code displays the error message “Incorrect price value”?

QUESTION 42
Examine this code:

What will be the outcome?

It will execute successfully and will display the user-defined error message.

It will result in an error as the range of the error code can only be from “-20000 to -20999.”

It will result in an error as the range of the error code can only be from “-1000 to -2000.”

It will result in an error as the range of the error code can only be from “-2000 to -2999.”

QUESTION 43
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 44
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 45
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 46
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

DEP_VU must be manually recompiled to successfully run this code.

It will run successfully producing a result of 4.

It will result in an error because table depts has been altered.

It will run successfully producing a result of 5.

QUESTION 47
Examine these statements which execute successfully:

Which anonymous block executes successfully?

QUESTION 48
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 49
Which two are true about implicit data type conversion? (Choose two.)

RAW data types are always implicitly converted to a CLOB when used in a query.

Collections can be implicitly converted to records.

ROWIDS are always implicitly converted to a number when used in a query.

Comparison between character value and a number value always implicitly converts the character value to the number data type.

Implicit data type conversion can negatively impact performance.

QUESTION 50
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 51
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.

QUESTION 52
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 53
Which two are true about lexical units? (Choose two.)

Character literals are case-sensitive.

Spaces can be embedded in delimiters.

Identifiers include labels.

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

All user-defined identifiers must start with an alphabet.

QUESTION 54
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

PL/SQL code can be compiled and executed based on different versions of the operating system.

PL/SQL code can be compiled and executed based on different versions of Oracle.

It is newer syntax that works the same way as ‘IF , ELSEIF , ELSE, and END IF’.

Conditional compilation is disabled by default.

The PL/SQL compiler can conditionally include selected parts of a program.

QUESTION 55
Examine this DECLARE section:

Which line will cause an error upon execution?

line 5

line 3

line 2

line 4

line 6

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

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

QUESTION 57
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?