Handsome Savings - Limited Time Offer 30% OFF - Ends In 0d 0h 0m 0s Coupon code: 30OFF
Trusted Worldwide Questions & Answers
Oracle 1Z0-149 Exam
Oracle Database 19c: Program with PL/SQL
Last Updated: Jul 3, 2024
65
65 Questions and Answers for the Oracle 1Z0-149 exam
480
Students Passed the "Oracle 1Z0-149" exam
95.1%
Average score during Real Exams at the Testing Centre
Oracle Database 19c: Program with PL/SQL Syllabus
- Use ACCESSIBLE BY to restrict access to package subprograms/ Create a record with the %ROWTYPE attribute
- Use the PL/SQL compiler initialization parameters/ Working with Composite Data Types
- Describe the differences among records, collections, and collections of records/ Declaring PL/SQL Variables
- Handle exceptions in procedures and display a procedure's information/ Recognize valid and invalid identifiers
- Use bulk binding and the RETURNING clause with DML/ Create PL/SQL executable blocks using DML and transaction control statements
- Control the run-time privileges of a subprogram/ List the uses of variables, declare and initialize variables, use bind variables
- Identify the benefits and the components of packages/ List and describe various data types using the %TYPE and %ROWTYPE attributes
- Identify the uses and types of control structures/ Make use of the INTO clause to hold the values returned by a SQL statement
- Describe when implicit conversions take place and when explicit conversions have to be dealt with/ Create user-defined PL/SQL records
- Whitelist code access with the ACCESSIBLE BY clause/ Create an INDEX BY table and INDEX BY table of records
- Overload package subprograms and use forward declarations/ Initialize collections and records
- Describe different types of triggers and their uses/ Describe the execution flow of SQL statements
- Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions/ Creating Procedures and Using Parameters
- Create triggers on DDL statements/ Create a procedure with parameterrs/ Bind PL/SQL types in SQL statements
- Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause/ Recognize unhandled exceptions
- Describe and use conditional compilation/ Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data