Articles for Oracle OCP DBA9i PL/SQL 1Z0-001
Skills required for Oracle test 1Z0-001.
Oracle has specified more than twenty objectives for 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test. Following are some important areas over which one should have good command before taking the test:
Overview of relational databases, SQL, and PL/SQL.
Writing basic SQL statements.......
continue reading "Skills required for Oracle test 1Z0-001." »
Things to practice for Oracle test 1Z0-001.
One should have a good knowledge about RDBMS concepts, SQL, and PL/SQL before taking the 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test, as this test focuses on one's capability to design relational databases and write various types of SQL and PL/SQL statements to interact with databases.......
continue reading "Things to practice for Oracle test 1Z0-001." »
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.01.05 | |
| Practice Tests | 1 | 3 |
| 15 | 301 | |
| Quiz | 15 | 100 |
| Final Test | No | Yes |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 19 | 105 |
