Articles for MCSE, MCSD, MCAD, CIW, CompTIA, Oracle, SCJP Certifications
All articles for OCA DBA 9i certification
Tips and How Tos for OCA DBA 9i certification
Skills required for Oracle 1Z0-007 test.
in OCA DBA 9i
Oracle has specified more than forty objectives for 1Z0-007 (Introduction to Oracle9i: SQL) test, which are covered under thirteen topics. Following are some important areas over which one should have good command before taking the test:
Executing a basic SELECT statement.
Limiting the...
continue reading "Skills required for Oracle 1Z0-007 test." »
Skills required for Oracle test 1Z0-001.
in OCA DBA 9i
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." »
Skills required for Oracle test 1Z0-031.
in OCA DBA 9i
Oracle has specified more than seventy-five objectives for 1Z0-031 (Oracle9i Database: Fundamentals I) test, which are grouped under eighteen topics. Before taking the test, one should have good command over the following areas:
Setting up password file authentication for administrative...
continue reading "Skills required for Oracle test 1Z0-031." »
Things to practice for Oracle test 1Z0-001.
in OCA DBA 9i
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." »
Things to practice for Oracle test 1Z0-007.
in OCA DBA 9i
The 1Z0-007 test focuses on your ability to use SQL statements to interact with Oracle databases. This test requires you to have a very good command over SQL. For this purpose, along with studying books and taking various practice tests, you should also practice with Oracle. While practicing with...
continue reading "Things to practice for Oracle test 1Z0-007." »
Things to practice for Oracle test 1Z0-031.
in OCA DBA 9i
Nearly eighty objectives have been specified for 1Z0-031 (Oracle9i Database: Fundamentals I) test. This clearly indicates that a candidate should have a sound knowledge about Oracle's architectural components and database structure before taking the test. One should also be capable of managing...
continue reading "Things to practice for Oracle test 1Z0-031." »
What are database objects?
in OCA DBA 9i
Database objects are data structures that are stored in an Oracle database. They are used to store data, access stored data, restrict data access, and speed up data access. Database objects can be created either by Oracle Server or a database user. An Oracle database can contain multiple database...
continue reading "What are database objects?" »
What is a trigger?
in OCA DBA 9i
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 Oracle's password management policy?
in OCA DBA 9i
Oracle's password management policy is used to maintain the secrecy of passwords in order to maintain the integrity of database security systems that are dependent on passwords. Oracle uses profiles to implement the password management policy. Oracle provides certain parameters to manage...
continue reading "What is Oracle's password management policy?" »
What is PL/SQL?
in OCA DBA 9i
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?" »
