Skip to main content

oracle certification

 


Exam NameOracle Database 11g - Program with PL/SQL
Exam Code1Z0-144
Exam PriceUSD $245 (Price may vary by country or by localized currency)
Duration90 minutes
Number of Questions63
Passing Score65%
FormatMultiple Choice Questions (MCQ)



Oracle 1Z0-144 Syllabus Topics:
- Creating Procedures
- Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms
- Create a simple procedure and invoke it from an anonymous block
- Work with procedures
- Handle exceptions in procedures, remove a procedure, 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)
- Working with Packages
- Overload package subprograms, use forward declarations
- Create an initialization block in a package body
- Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages
- Using Oracle-Supplied Packages in Application Development
- Describe how the DBMS_OUTPUT package works
- Use UTL_FILE to direct output to operating system files
- Describe the main features of UTL_MAIL
- Using Dynamic SQL
- Describe the execution flow of SQL statements
- Use Native Dynamic SQL (NDS)
- Use the DBMS_SQL package
- 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 Triggers
- Describe different types of triggers and their uses
- Create database triggers
- Manage triggers
- Creating Compound, DDL, and Event Database Triggers
- Create triggers on DDL statements
- Create triggers on system events
- Using the PL/SQL Compiler
- Describe the new PL/SQL compiler and features
- Use the new PL/SQL compiler initialization parameters
- Use the new PL/SQL compile time warnings
- Managing PL/SQL Code
- Describe and use conditional compilation
- Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
- Managing Dependencies







x

Comments

Post a Comment

Popular posts from this blog

Oracle Merge Statement Delta Detection

The MERGE Syntax by Ajay Nerumati Delta Detection in Oracle SQL Posted on  8. October 2016 Delta detection is a common task in every Data Warehouse. It compares new data from a source system with the last versions in the Data Warehouse to find out whether a new version has to be created. There are several ways to implement this in Oracle. Your source system delivers a full extraction every night, and you have to load only the changed rows into your Core Data Warehouse? You receive incremental loads from another source system every few minutes, but only a few columns are loaded into the Data Warehouse. In all these situations, you need a delta detection mechanism to identify the rows that have to be inserted or updated in your Data Warehouse tables. In this blog post, I want to show different methods in Oracle SQL that provide the subset of rows of a source table that were changed since the last load. All these methods are set-based, i.e. they can be executed in one SQL sta...
189 comments
Read more

RDBMS MINI PROJECT

  Capgemini class room training.   RDBMS MINI PROJECT ( SPRINT ) LIBRARY MANAGEMENT SYSTEM   Table of Contents Serial No. Topic Name Content Page No. 1.   Introduction 1.1 Setup checklist for mini project 3     1.2 Instructions 3 2.   Problem statement   2.1 Objective 4     2.2 Abstract of the project 4     2.3 Functional components of the project 4     2.4 Technology used 5 3.   Implementation in RDBMS LOT 3.1 Guidelines on the functionality to be built 6 4.   Evaluation 4.1 Evaluation 7   ...
1 comment
Read more

PL / SQL practice programs

  PL / SQL  practice programs 1. Write a program to print the following format WELCOME TO PL/SQL PROGRAMMING   BEGIN   DBMS_OUTPUT.PUT_LINE('WELCOME   TO   PL/SQL   PROGRAMMING'); END; /   2. Write a program to print the numbers from 1 to 100   DECLARE N NUMBER(3):=1; V VARCHAR2(1000); BEGIN WHILE N <=1000 LOOP V:=V||''||N; N:=N+1; END LOOP; DBMS_OUTPUT.PUT_LINE(V); END; / 3. write a program to print the even numbers from 1 to 100 DECLARE N NUMBER(3):=0; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 4. Write a program to print the odd numbers from 1 to 100 DECLARE N NUMBER(3):=1; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 5. write a program for multiplication table DECLARE A NUMBER(2):=&A; B   NUMBER(2):=1; C ...
5 comments
Read more