Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle 1Z0-149 Exam

Certification Provider: Oracle
Exam Name: Oracle Database 19c: Program with PL/SQL
Number of questions in our database: 65
Exam Version: Mar. 17, 2023
1Z0-149 Exam Official Topics:
  • Topic 1: Use ACCESSIBLE BY to restrict access to package subprograms/ Create a record with the %ROWTYPE attribute
  • Topic 2: Use the PL/SQL compiler initialization parameters/ Working with Composite Data Types
  • Topic 3: Describe the differences among records, collections, and collections of records/ Declaring PL/SQL Variables
  • Topic 4: Handle exceptions in procedures and display a procedure's information/ Recognize valid and invalid identifiers
  • Topic 5: Use bulk binding and the RETURNING clause with DML/ Create PL/SQL executable blocks using DML and transaction control statements
  • Topic 6: Control the run-time privileges of a subprogram/ List the uses of variables, declare and initialize variables, use bind variables
  • Topic 7: Identify the benefits and the components of packages/ List and describe various data types using the %TYPE and %ROWTYPE attributes
  • Topic 8: Identify the uses and types of control structures/ Make use of the INTO clause to hold the values returned by a SQL statement
  • Topic 9: Describe when implicit conversions take place and when explicit conversions have to be dealt with/ Create user-defined PL/SQL records
  • Topic 10: Whitelist code access with the ACCESSIBLE BY clause/ Create an INDEX BY table and INDEX BY table of records
  • Topic 11: Overload package subprograms and use forward declarations/ Initialize collections and records
  • Topic 12: Describe different types of triggers and their uses/ Describe the execution flow of SQL statements
  • Topic 13: Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions/ Creating Procedures and Using Parameters
  • Topic 14: Create triggers on DDL statements/ Create a procedure with parameterrs/ Bind PL/SQL types in SQL statements
  • Topic 15: Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause/ Recognize unhandled exceptions
  • Topic 16: Describe and use conditional compilation/ Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data

Free Oracle 1Z0-149 Exam Actual Questions

The questions for 1Z0-149 were last updated On Mar. 17, 2023

Question #1

Examine this code:



You compile this function:

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

Reveal Solution Hide Solution
Correct Answer: D

Question #2

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

Reveal Solution Hide Solution
Correct Answer: B, E, F

Question #3

Which two are true about packages? (Choose two.)

Reveal Solution Hide Solution
Correct Answer: A, C

Question #4

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

Reveal Solution Hide Solution
Correct Answer: C, E

Question #5

Examine this statement which executes successfully:


Now, examine this code which is executed:

What is true about the result?

Reveal Solution Hide Solution
Correct Answer: B

Unlock all 1Z0-149 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now
Disscuss Oracle 1Z0-149 Topics, Questions or Ask Anything Related

Save Cancel