The certification test for Oracle 11g Database SQL Fundamental (1Z0-051) requires a profound knowledge of developing a database. Oracle certifications are considered to be the hottest credentials in the database world. To clear the exam of 1Z0-051, you must be well versed with the objectives specified for the test. Practicing especially in the following areas will definitely help raise your level of confidence:

The Oracle test 1z0-053 is designed to measure an individual’s ability to administer Oracle Database 11g. Before taking the 1z0-053 test, you should practice the following:

  1. Describe Automatic Storage Management (ASM).
  2. Set up initialization parameter files for ASM and database instances.
  3. Start up and shut down ASM instances.
  4. Administer ASM disk groups.
  5. Configure multiple archive log file destinations to increase availability.
  6. Define, apply, and use a retention policy.
  7. Continue reading

Posted in OCP.

This test requires a thorough knowledge of administrative tasks for managing the database for optimal performance. The candidate appearing in this test should have a sound knowledge of various tools available in Oracle9i for managing different issues in the database. This includes identifying contentions and resolving them through the tools. For this purpose, one should practice the following to a good extent:

  1. Identifying tuning areas through querying the available views.
  2. Gathering statistics through available tools, such as STATSPACK.
  3. Using the available GUI tools, such as Instance Manager to resolve contentions.
  4. Changing the values of various initialization parameters to monitor the subsequent affect on the system performance.
  5. Changing the size of various database objects, such as buffers, pools, tablespace, and rollback segments to monitor its affect on the performance of the system.
  6. Pass OCP DBA 9i certification exam in first attempt. Download latest exam simulation, questions, tutorial and study guide for OCP DBA 9i:

What is Oracle 11g DBA OCA, Oracle9i DBA OCA, and Oracle PL/SQL Developer Certified Associate?

Oracle 11g DBA OCA, Oracle9i DBA OCA, and Oracle PL/SQL Developer Certified Associate are some of the certification levels offered by Oracle. It prepares a candidate to build intensive internet applications for Oracle database. You should be very well versed with how to write a PL/SQL programs to qualify the certification test. It also prepares you for the next certification level to become an Oracle Form Developer. It is an essential certification for the advanced certification level (OCP DBA 9i).

Continue reading

What is OCA DBA (10g) certification?

OCA DBA (10g) certification is the most fundamental and entrance level certification on DBA track on 10g platform. Its objectives are intended to measure a candidate’s ability to work as a junior team member with Database Administrators or Application Developers. This certification is the first step towards the more advanced OCP – 10g certification. The certification requires the comprehensive skills in the following areas:

Posted in OCP.

Robert G. Freeman is a Principal Engineer and Database Team Manager at the Church of Jesus Christ of Latter-Day Saints in Salt Lake City, UT, USA. He has been working with Oracle Databases for almost two decades. Robert is the author of several books including Oracle Database 10g RMAN Backup and Recovery and Oracle Database 11g New Features. Robert is an Oracle ACE, and is currently the only residing ACE in the state of Utah, USA. When not working with Oracle databases Robert may be found flying around in his airplane, kicking in karate class or just hanging out with his wife, kids, 2 cats and a dog named Denali.

Robert is a co-author for following uCertify PrepKit:
1Z0-051: OCA: Oracle Database 11g-SQL Fundamentals-I
Continue reading

Deepak Jaisingh has 10+ years of technical experience in various industries like Banking, Manufacturing, Insurance etc. His expertise lie in Database and System Administration. His “Never Give Up” attitude is the reason behind all his success. He started his career in a small call center, then very soon he migrated to IT and from there on he never looked back. Oracle became his passion and his job, his obsession.

Deepak is an Oracle certified professional (OCP) and Sun Certified Java Professional (SCJP). He is currently perusing OCM.

Deepak is co-author and contributor for following PrepKits:
1Z0-042: Oracle 10g DBA Admin I
1Z0-043: Oracle 10g DBA Admin I,
1Z0-047: Oracle 11g SQL Expert

Bob Bryla is an Oracle 8, 8i, 9, 10g and 11g Certified Professional with more than 20 years of experience in database design, database application development, training, and Oracle database administration. He is the primary internet database designer and developer at Lands’ End in Dodgeville, Wisconsin. Bob works with PL/SQL and Oracle on a daily basis to support the back end of the world’s #1 clothing web site, landsend.com.

Bob Bryla Co-Author and contributor for following uCertify PrepKit
1Z0-052 OCA: Oracle Database 11g: Administration I

Continue reading

Configuring Recovery Manager

  • The control file, target database catalog, and Recovery catalog is used to store the RMAN’s persistent settings.
  • The alert log file is used to find out the values of the changed parameters at the time of instance startup.
  • The NLS_LANG parameter must be set to specify the language, territory, and character set used in an application.
  • CONFIGURE RETENTION POLICY CLEAR is a command that will configure the retention policy to the default of REDUNDANCY 1.
  • CONFIGURE is an RMAN command that configures an RMAN environment.
  • The rman target/ command is used to maintain backup copies by connecting to the target database and returns the RMAN prompt to issue further backup commands.
  • The redo files are opened after executing the ALTER DATABASE OPEN command on a database when it is in MOUNT mode.

Understanding Globalization Support
Continue reading

Retrieving data using the SQL SELECT statement and using single row functions to customize the output

  • /*…*/ and — are used to put comments in an Oracle program.
  • The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
  • Name of a table cannot start with @ special character.
  • Knowing about the GROUP BY clause.

Using sub queries and set operators to solve queries, as well as DDL statements to create and manage tables

  • + (unary), – (unary), *, /, ||, =, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN, NOT, AND, OR is the correct order of operators precedence.
  • Continue reading