[May-2026] Dumps Practice Exam Questions Study Guide for the 1Z0-149 Exam
1Z0-149 Dumps with Practice Exam Questions Answers
Passing the Oracle 1Z0-149 exam and obtaining the OCP certification for Oracle Database 19c can enhance a developer's career prospects and demonstrate their expertise in programming with PL/SQL. Oracle Database 19c: Program with PL/SQL certification is recognized globally and can lead to a variety of job opportunities in the field of database development.
Oracle Database 19c: Program with PL/SQL certification is highly valued in the industry, as it demonstrates a strong understanding of PL/SQL programming and Oracle Database 19c. Oracle Database 19c: Program with PL/SQL certification is ideal for professionals who want to advance their careers in database development, administration, or management. Additionally, Oracle Database 19c: Program with PL/SQL certification can help professionals increase their earning potential and job opportunities.
NEW QUESTION # 14
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 15
For which three SYSTEM EVENTS can triggers be created? (Choose three.)
- A. DDL
- B. STARTUP
- C. BEFORE ANALYZE
- D. BEFORE GRANT
- E. AFTER AUDIT
- F. SHUTDOWN
- G. SERVERERROR
Answer: B,F,G
NEW QUESTION # 16
Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:
What is true about the result?
- A. It returns an error in line 4.
- B. It returns an error in line 9.
- C. It returns an error in line 2.
- D. It executes and displays output.
Answer: A
NEW QUESTION # 17
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?
- A.
- B.
- C.
- D.
- E.
Answer: E
NEW QUESTION # 18
Which statement is true about user-defined records?
- A. Field names must match selected column names.
- B. Field types must match column types.
- C. They can be returned from a function.
- D. The number of fields must match the number of columns in a table.
Answer: D
NEW QUESTION # 19
Which is true about counter variables in a FOR loop?
- A. It must explicitly be declared.
- B. It can be modified in the body of the loop.
- C. It is accessible outside the body of the loop.
- D. It cannot be NULL.
Answer: D
NEW QUESTION # 20
Which is true about EXIT and CONTINUE statements?
- A. They can be used in any type of loop.
- B. They must use labels.
- C. They must have a WHEN condition.
- D. They have the same effect on the execution of a loop.
Answer: A
NEW QUESTION # 21
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. CBAC cannot be used to secure definer's rights.
- B. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- C. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
- D. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- E. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- F. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- G. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
Answer: B,E,F
NEW QUESTION # 22
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 record declared in an anonymous block
- B. an associative array indexed by PLS_INTEGER
- C. a record declared in a procedure
- D. an associative array indexed by VARCHAR2
- E. a record declared in a package specification
- F. a predefined PL/SQL-only data type like BOOLEAN
Answer: B,D,E
NEW QUESTION # 23
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: A,C
NEW QUESTION # 24
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. FETCH
- B. WHEN
- C. INTO
- D. OPEN
- E. DECLARE
- F. CLOSE
- G. OPEN-FOR
Answer: A,F,G
NEW QUESTION # 25
Which two blocks of code display a numerical zero? (Choose two.)
- A.
- B.
- C.
- D.
Answer: A,B
NEW QUESTION # 26
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
- A. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
- B. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
- C. Initialization of loan_amount can be done while using this packaged variable in another program.
- D. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
- E. This program unit will compile successfully.
- F. Initialization of min_bal can be done while using this packaged constant in another program.
- G. This will not compile successfully because the min_bal constant must be initialized.
Answer: A,B,G
NEW QUESTION # 27
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 run successfully producing a result of 4.
- B. DEP_VU must be manually recompiled to successfully run this code.
- C. It will run successfully producing a result of 5.
- D. It will result in an error because table depts has been altered.
Answer: A
NEW QUESTION # 28
Which two are true about packages? (Choose two.)
- A. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- B. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
- C. Package specifications can be compiled without their bodies.
- D. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- E. A package definition must have a specification and body.
Answer: C,D
NEW QUESTION # 29
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
- B. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
- C. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
- D. Implicit cursor returns only one record.
- E. %Isopen is always false in Explicit Cursor.
- F. Explicit cursor can return more than one record.
- G. %Isopen is always false in Implicit Cursor.
Answer: A,F,G
NEW QUESTION # 30
Which three are true about anonymous blocks and subprograms? (Choose three.)
- A. Anonymous blocks cannot use packaged variables.
- B. Anonymous blocks must always start with the Declare keyword.
- C. A FUNCTION subprogram must return one or more values.
- D. PROCEDURE subprograms can accept parameters.
- E. Named subprograms cannot be called from other packages.
- F. FUNCTION subprograms must be called and passed through one or more parameters.
- G. Named subprograms are stored in the database server.
Answer: C,D,G
NEW QUESTION # 31
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 32
......
Free Oracle Database PL/SQL Developer Certified Professional 1Z0-149 Exam Question: https://www.dumpsquestion.com/1Z0-149-exam-dumps-collection.html
1Z0-149 by Oracle Database PL/SQL Developer Certified Professional Actual Free Exam Practice Test: https://drive.google.com/open?id=1uggMFUsy_cyVRlo64SbvpYE55edPJfNW