Exam: 1Z0-149

Format: Multiple Choice
Duration: 90 Minutes
Number of Questions: 65
Passing Score: 66%
Validation: Exam has been validated for product version Oracle Database 19c

Earn associated certifications
Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.

Prepare to pass exam: 1Z0-149
Oracle Advanced PL/SQL Developer Certified Professionals demonstrate expertise in database-centric Internet applications for Oracle Database 10g, 11g and 12c.

Review exam topics

Declaring PL/SQL Variables
Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE and %ROWTYPE attributes

Writing Executable Statements
Identify lexical units in a PL/SQL block
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describe when implicit conversions take place and when explicit conversions have to be dealt with
Write nested blocks and qualify variables with labels
Write readable code with appropriate indentation

Writing SQL in PL/SQL
Create PL/SQL executable blocks using DML and transaction control statements
Make use of the INTO clause to hold the values returned by a SQL statement

Writing Control Structures
Identify the uses and types of control structures (IF, CASE statements and expressions)
Construct and identify loop statements
Use EXIT and CONTINUE statements inside loops

Working with Composite Data Types
Create user-defined PL/SQL records
Create a record with the %ROWTYPE attribute
Create an INDEX BY table and INDEX BY table of records
Describe the differences among records, collections, and collections of records
Initialize collections and records

Using Explicit Cursors
Distinguish between implicit and explicit cursors and use SQL cursor attributes
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
Declare and use cursors with parameters
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause

Handling Exceptions
Define PL/SQL exceptions
Recognize unhandled exceptions
Handle different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)
Propagate exceptions

Using PL/SQL Subprograms
Differentiate between anonymous blocks and subprograms
Create a simple procedure and invoke it from an anonymous block
Identify benefits of subprograms

Creating Procedures and Using Parameters
Create a procedure with parameterrs
Use named notation
Work with procedures (create, invoke and remove procedures)
Handle exceptions in procedures and display a procedure's information

Creating Functions
Differentiate between a procedure and a function
Describe the uses of functions
Work with functions (create, invoke and remove functions)

Creating Packages
Identify the benefits and the components of packages
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Overload package subprograms and use forward declarations

Working with Packages
Use package types and variables
Use packaged constants and functions in SQL
Use ACCESSIBLE BY to restrict access to package subprograms

Using Dynamic SQL
Describe the execution flow of SQL statements
Use Native Dynamic SQL (NDS)
Bind PL/SQL types in SQL statements

Design Considerations for PL/SQL Code
Create standard constants and exceptions
Write and call local subprograms
Control the run-time privileges of a subprogram
Perform autonomous transactions
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Use bulk binding and the RETURNING clause with DML

Creating Compound, DDL, and Event Database Triggers
Create triggers on DDL statements
Create triggers on system events
Describe different types of triggers and their uses

Using the PL/SQL Compiler
Describe the PL/SQL compiler and features
Use the PL/SQL compiler initialization parameters
Use the PL/SQL compile time warnings

Managing PL/SQL Code
Describe and use conditional compilation
Code-based access control: granting roles to program units
Whitelist code access with the ACCESSIBLE BY clause
Mark code as deprecated

Managing Dependencies
Track and manage procedural dependencies

Acquiring the 1Z0-149 certification can open up new doors for your professional growth and career advancement. By preparing for this exam with Certkingdom's training resources, you can feel confident in your ability to pass the exam and attain this coveted credential. Their hands-on tasks and real-world scenarios help you develop the practical skills and knowledge necessary to succeed on the exam. With flexible online resources and events, you can learn at your own pace and on your own schedule. And with the constantly updated study materials, you can stay current with the latest technology standards. By using Certkingdom's 1Z0-149 Brain Dumps exam training materials, you can be sure that you're receiving the best education and preparation for the exam. Get ready to take your skills and expertise to the next level with Certkingdom's 1Z0-149 exam resources.

1Z0-149 Brain Dumps Exam + Online / Offline and Android Testing Engine & 4500+ other exams included
$50 - $25 (you save $25)
Buy Now

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

A. PACKAGES
B. VARIABLES
C. ANONYMOUS BLOCK
D. TRIGGER BODY
E. DATABASE LINKS

Answer: A, E

QUESTION 2
Which three are true about functions and procedures? (Choose three.)

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

Answer: B, E, F

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

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

Answer: B, E

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

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

Answer: B, E, G

QUESTION 5
Which two are true about INDEX-BY tables? (Choose two.)

A. The index can be integer or string.
B. The index can be integer only.
C. INDEX-BY table types can be created in PL/SQL blocks only.
D. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
E. INDEX-BY table types can be created with the CREATE TYPE statement.

Answer: A, C

QUESTION 6
Which three are true about anonymous blocks and subprograms? (Choose three.)

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

Answer: B, C, E

1Z0-149 Brain Dumps Exam + Online / Offline and Android Testing Engine & 4500+ other exams included
$50 - $25 (you save $25)
Buy Complete

This is what our customers are saying about CertKingdom.com.
These are real testimonials.

Jsaon
I always enjoy Scott Duffy training videos. I like how this followed the skills outline from Oracle.

It was a great course which helped me to clear 1Z0-149, I had previous experience in QnA Maker and Bot services but other major areas are very well covered by Scott. In the practice test I scored 70% in the first attempt.. but it gave proper understanding and logic building thrust.

Jessica
This course is a great walkthrough Azure Cognitive Services, but definitely not prep material for 1Z0-149 exam.

Scott: cleard my exam in one week
Despite being recently updated this course feels out of date, for example there are 31 minutes of videos on QnA maker, but this service does not appear on the current study guide and its not clear from the course content how this differs from its replacement (Azure Cognitive Service for Language).

Furthermore, 10 minutes of videos on knowledge mining feels low for an area that makes up 15-20% of the exam

Richel
I have cleared exam today with 900!, these mock tests were very helpful to me and highly recommended. Thank you

David
Successfully cleared 1Z0-149 exam today with 960 marks. All the questions similar and came from this Mock tests. Thanks a lot certkingdom.

Hillary - CANADA

Oct 26, 2022
Rating: 4.3 / 5.0

I studied and pass my exams using cerkingdom material carefully and took every question seriously. At last, I passed the exam with high score. Prepare well and study much more.

Certkingdom Offline Testing Engine Simulator Download

Prepare with yourself how CertKingdom Offline Exam Simulator it is designed specifically for any exam preparation. It allows you to create, edit, and take practice tests in an environment very similar to an actual exam.


Supported Platforms: Windows-7 64bit or later - EULA | How to Install?


FAQ's: Windows-8 / Windows 10 if you face any issue kinldy uninstall and reinstall the Simulator again.



Download Offline Simulator-Beta

Certkingdom Testing Engine Features

• Certkingdom Testing Engine simulates the real exam environment.
• Interactive Testing Engine Included
• Live Web App Testing Engine
• Offline Downloadable Desktop App Testing Engine
• Testing Engine App for Android
• Testing Engine App for iPhone
• Testing Engine App for iPad
• Working with the Certkingdom Testing Engine is just like taking the real tests, except we also give you the correct answers.
• More importantly, we also give you detailed explanations to ensure you fully understand how and why the answers are correct.

Certkingdom Android Testing Engine Simulator Download

Take your learning mobile android device with all the features as desktop offline testing engine. All android devices are supported.
Supported Platforms: All Android OS EULA

Install the Android Testing Engine from google play store and download the app.ck from certkingdom website android testing engine download

Certkingdom Android Testing Engine Features

• CertKingdom Offline Android Testing Engine
• Make sure to enable Root check in Playstore
• Live Realistic practice tests
• Live Virtual test environment
• Live Practice test environment
• Mark unanswered Q&A
• Free Updates
• Save your tests results
• Re-examine the unanswered Q & A
• Make your own test scenario (settings)
• Just like the real tests: multiple choice questions
• Updated regularly, always current