uCertify.com

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:

1. Setting up password file authentication for administrative users.
2. Using Oracle Enterprise Manager (OEM) and its components.
3. Creating and managing initialization parameter files.
4. Implementing Oracle Managed Files (OMF).
5. Starting up and shutting down an Oracle instance.
6. Creating a database manually and by using Database Configuration Assistant (DBCA).
7. Querying data dictionary.
8. Multiplexing and managing control files and online redo log files.
9. Creating and altering tablespaces.
10. Implementing automatic undo management.
11. Creating and altering regular and temporary tables and managing storage structures within them.

Continue reading “How to prepare for 1Z0-031 exam.”

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. Practicing the following things will help a candidate to perform well in the test:

1. Create tables and link them using different types of constraints.
2. Create views, synonyms, and indexes.
3. Use the SELECT statement to retrieve rows from tables and views.
4. Insert, update, and delete rows from tables.
5. Use the WHERE and ORDER BY clauses to restrict and sort rows retrieved by SELECT statements.

Continue reading “How to prepare for 1z0-001 exam.”