[Q36-Q61] Ensure Success With Updated Verified 1Z0-149 Exam Dumps [2026]

Ensure Success With Updated Verified 1Z0-149 Exam Dumps [2026]

Exam Materials for You to Prepare & Pass 1Z0-149 Exam.

Oracle 1Z0-149 certification exam is designed for individuals who want to validate their skills and knowledge in programming with PL/SQL using the Oracle Database 19c. Oracle Database 19c: Program with PL/SQL certification exam tests your ability to write efficient and effective PL/SQL code, manage program units, and use built-in packages and dynamic SQL. It is an advanced-level certification exam that requires significant experience and expertise in PL/SQL programming.

Oracle 1z1-149 exam is designed for professionals who want to demonstrate their expertise in programming with PL/SQL in Oracle Database 19c. 1Z0-149 exam is intended for developers who have a strong understanding of SQL and PL/SQL and who can apply their knowledge to develop robust and efficient database applications. Passing 1Z0-149 exam validates the skills and knowledge required to develop and maintain PL/SQL programs in Oracle Database 19c.

 

NEW QUESTION # 36
Which statement is true about user-defined records?

• A. They can be returned from a function.
• B. The number of fields must match the number of columns in a table.
• C. Field types must match column types.
• D. Field names must match selected column names.

Answer: B

NEW QUESTION # 37
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.)

• A. Call HR.API.P1 from the HR schema.
• B. Call HR.HELPER.H1 from the HR schema.
• C. Call HR.HELPER.H1 from the SH schema.
• D. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
• E. Call HR.API.P1 from the SH schema.

Answer: C,E

NEW QUESTION # 38
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. a predefined PL/SQL-only data type like BOOLEAN
• B. a record declared in a procedure
• C. a record declared in an anonymous block
• D. an associative array indexed by PLS_INTEGER
• E. an associative array indexed by VARCHAR2
• F. a record declared in a package specification

Answer: D,E,F

NEW QUESTION # 39
Which is true about counter variables in a FOR loop?

• A. It can be modified in the body of the loop.
• B. It is accessible outside the body of the loop.
• C. It must explicitly be declared.
• D. It cannot be NULL.

Answer: D

NEW QUESTION # 40
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

• A. This clause can be used only for procedures and functions.
• B. Function based indexes remain usable when replacing the function on which the index depends.
• C. Object privileges to execute a replaced function are retained by those users who had the privileges.
• D. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
• E. A function definition can be modified without dropping and re-creating it.

Answer: C,E

NEW QUESTION # 41
Which three statements can process a dynamic multi-row query? (Choose three.)

• A. DECLARE
• B. INTO
• C. FETCH
• D. CLOSE
• E. OPEN-FOR
• F. OPEN
• G. WHEN

Answer: C,D,E

NEW QUESTION # 42
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?

• A. It will fail only at line 7.
• B. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
• C. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
• D. It will fail at lines 6 and 7.

Answer: A

NEW QUESTION # 43
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

• A. It will set all salaries to NULL if it executes successfully.
• B. It will always automatically initialize v_raise.
• C. It will always return a compile time error because it lacks an EXCEPTION section.
• D. It might return a run time error depending on who invokes it.
• E. It will always return a run time error because v_raise is not initialized.
• F. It will set all salaries to 0 if it executes successfully.

Answer: A,B

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

• A. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
• B. The PL/SQL compiler can conditionally include selected parts of a program.
• C. PL/SQL code can be compiled and executed based on different versions of the operating system.
• D. PL/SQL code can be compiled and executed based on different versions of Oracle.
• E. Conditional compilation is disabled by default.

Answer: B,D

NEW QUESTION # 45
Which block of code displays the error message "Incorrect price value"?

• A.
• B.
• C.
• D.

Answer: D

NEW QUESTION # 46
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.)

• A. line 1
• B. line 8
• C. line 3
• D. line 6
• E. line 2
• F. line 7

Answer: A,D

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

• A. ENABLE
• B. DISABLE
• C. SEVERE
• D. ALL
• E. ERROR

Answer: C,D

NEW QUESTION # 48
Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

• A.
• B.
• C.
• D.

Answer: C,D

NEW QUESTION # 49
Examine these statements:

Which two are true? (Choose two.)

• A. Both tables will have a row inserted and committed.
• B. Only one table will have a row inserted and committed.
• C. Neither table will have a row inserted and committed.
• D. The bank_activity_proc will not compile because of the commit.
• E. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

Answer: B,E

NEW QUESTION # 50
Which three are true about PL/SQL subprograms? (Choose three.)

• A. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
• B. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
• C. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
• D. Host variables can be referenced inside any PL/SQL subprogram.
• E. 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.
• F. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
• G. A PL/SQL procedure can invoke an external code block written in a different programming language.

Answer: B,F,G

NEW QUESTION # 51
In which type of trigger can :OLD and :NEW identifiers be used?

• A. BEFORE STATEMENT
• B. AFTER SUSPEND
• C. ROW
• D. AFTER STATEMENT

Answer: C

NEW QUESTION # 52
Which three statements are true about passing parameters to subprograms? (Choose three.)

• A. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
• B. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
• C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
• D. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
• E. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
• F. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
• G. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

Answer: C,F,G

NEW QUESTION # 53
Which is the correct method to implement a local subprogram in an anonymous block?

• A.
• B.
• C.
• D.

Answer: B

NEW QUESTION # 54
Which three are true about functions and procedures? (Choose three.)

• A. In a function every RETURN statement must specify an expression.
• B. The ACCESSIBLE BY clause can be used only for procedures.
• C. Both can have only constants as actual parameters for IN mode parameters.
• D. In a procedure the RETURN statement cannot specify an expression.
• E. In a function, every execution path must lead to a RETURN statement.
• F. Both can be invoked from within SQL statements.

Answer: A,D,E

NEW QUESTION # 55
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?

• A. It will result in an error because table depts has been altered.
• B. It will run successfully producing a result of 5.
• C. It will run successfully producing a result of 4.
• D. DEP_VU must be manually recompiled to successfully run this code.

Answer: C

NEW QUESTION # 56
Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

• A. Initialization of min_bal can be done while using this packaged constant in another program.
• B. Initialization of loan_amount can be done while using this packaged variable in another program.
• C. This will not compile successfully because the min_bal constant must be initialized.
• D. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
• E. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
• F. This program unit will compile successfully.
• G. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

Answer: C,D,G

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

• A. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
• B. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
• C. The PARALLEL_ENABLE clause can be specified for a nested function.
• D. A function is deterministic if it always returns the same result for a specific combination of input values.
• E. The NOCOPY hint asks the compiler to pass the actual parameters by value.
• F. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
• G. A deterministic function's results always depend on the state of session variables.

Answer: A,D,F

NEW QUESTION # 58
Examine this DECLARE section:

Which line will cause an error upon execution?

• A. line 5
• B. line 3
• C. line 4
• D. line 6
• E. line 2

Answer: D

NEW QUESTION # 59
Examine these statements which execute successfully:

Which anonymous block executes successfully?

• A.
• B.
• C.
• D.

Answer: B

NEW QUESTION # 60
Which three are true about anonymous blocks and subprograms? (Choose three.)

• A. Anonymous blocks cannot use packaged variables.
• B. Named subprograms cannot be called from other packages.
• C. Anonymous blocks must always start with the Declare keyword.
• D. FUNCTION subprograms must be called and passed through one or more parameters.
• E. Named subprograms are stored in the database server.
• F. A FUNCTION subprogram must return one or more values.
• G. PROCEDURE subprograms can accept parameters.

Answer: E,F,G

NEW QUESTION # 61
......

Updated 1Z0-149 Certification Exam Sample Questions: https://www.dumps4pdf.com/1Z0-149-valid-braindumps.html

Pass Your 1Z0-149 Exam at the First Try with 100% Real Exam: https://drive.google.com/open?id=1MGyChZRA3jyYzz-1KX89YTGyIaJ0X2xM