Articles for Oracle DBA9i PL/SQL 1Z0-147
Skills required for Oracle test 1Z0-147.
Oracle has specified around ninety objectives for 1Z0-147 (Oracle9i: Program with PL/SQL) test, which are grouped under eleven topics. Following are the important areas in which an individual should possess good knowledge before taking the test:
Writing PL/SQL programs.
Designing......
continue reading "Skills required for Oracle test 1Z0-147." »
Things to practice for Oracle test 1Z0-147.
The 1Z0-147 (Oracle9i: Program with PL/SQL) test focuses on a candidate's ability to develop applications by using the PL/SQL. It requires the candidate to have a good command over PL/SQL. One should be capable of understanding the requirements of an application and program accordingly. Before......
continue reading "Things to practice for Oracle test 1Z0-147." »
Developing an Oracle Application.
When writing a program to interact with the Oracle database, an application developer has the following choices:
Client/Server Model:
In a traditional client/server program, the code of an application runs on a computer other than the Oracle database server. Database calls are......
continue reading "Developing an Oracle Application." »
What is a trigger?
Trigger
A trigger is a kind of procedure that executes implicitly when a table or view is modified or some user actions or database system actions occur. Similar to a stored procedure, a trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can......
continue reading "What is a trigger?" »
What is PL/SQL?
PL/SQL is Oracle's procedural extension to SQL, which is the standard database access language. PL/SQL is an advanced fourth-generation programming language (4GL) and offers seamless SQL access, tight integration with the Oracle server and tools, portability, security, and modern software......
continue reading "What is PL/SQL?" »
What is the structure of a PL/SQL block?
Procedural Language/Structured Query Language (PL/SQL) is a procedural language extension to SQL, the standard data access language for relational databases. PL/SQL is not an Oracle product in its own right; rather, it is a technology used by Oracle server and certain Oracle tools.
PL/SQL......
continue reading "What is the structure of a PL/SQL block?" »
| Includes | Free | Buy |
|---|---|---|
| Version | 8.03.05 | |
| Practice Tests | 1 | 3 |
| 15 | 280 | |
| Quiz | 15 | 100 |
| Final Test | No | Yes |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 19 | 101 |
