Archive for the ‘OCP’ category

Newer Entries »

OCP 1Z0-047 Short Notes: Exam passing tips

November 13th, 2008

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.

This is a preview of OCP 1Z0-047 Short Notes: Exam passing tips. Read the full post (638 words, 1 image, estimated 2:33 mins reading time)

No comments »

Posted in Exam passing tips, News and Press Release, OCP, Study Tips

Tags:

OCP 1Z0-045 Short Notes: Exam passing tips

November 7th, 2008

General high availability technologies in 10g

  • The ORDER BY clause sorts the records in ascending order and it comes last in the SELECT statement.
  • The Online redo log files and the operating system flat file are used to store a copy of a data dictionary.
  • RMAN can be used to take an incremental backup for tablespaces and data files.
  • 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 NLS_LANG parameter must be set to specify the language, territory, and character set used in an application.
  • CONFIGURE is an RMAN command that configures an RMAN environment.
  • CONFIGURE RETENTION POLICY CLEAR is a command that will configure the retention policy to the default of REDUNDANCY 1.
  • RMAN is used to migrate the database files from conventional file system storage to ASM storage.
  • The control file, target database catalog, and Recovery catalog are used to store the RMAN’s persistent settings.
  • The redo files are opened after executing the ALTER DATABASE OPEN command on a database when it is in MOUNT mode.
  • RMAN can be used to move database objects from a non-ASM disk location to an ASM disk group.
  • The V dynamic performance view includes the status, the location where the block change tracking file is stored, and the size in bytes of the file.

This is a preview of OCP 1Z0-045 Short Notes: Exam passing tips. Read the full post (4343 words, 1 image, estimated 17:22 mins reading time)

No comments »

Posted in OCA, OCP, Study Tips

Tags:

OCP 1Z0-040 Short Notes: Exam passing tips

November 1st, 2008

New Features of Oracle 10g, Oracle 10g Installation, Server Configuration, and Maintenance of the Software

  • Memory – 512MB, Temp space – 400MB of free space in the /tmp directory applicable for the Unix operating system, Swap space – 1GB or twice the amount of RAM, Free disk space – 1.5GB are the minimum hardware requirements to install Oracle 10g.
  • The Installation Type list box is used to decide the type of installation.
  • Oracle Management Agent (OMA) is a centralized administrative tool that is capable of administering the database server and an application server.
  • The location (/u01/app/oracle) will be considered as the base of Optimal Flexible Architecture (OFA).
  • The password file is used to authenticate the administrative tasks from remote locations.
  • An Oracle 10g client can be used to connect to an Oracle 8i or 9i database by using the following syntax:
This is a preview of OCP 1Z0-040 Short Notes: Exam passing tips. Read the full post (3492 words, 1 image, estimated 13:58 mins reading time)

No comments »

Posted in Exam passing tips, OCA, OCP, Study Tips

Tags:

Everything you want to know about the 1z0-043 exam

October 3rd, 2008

Q. What is the pre-requisite for taking the 1z0-043 exam?

A. The 1z0-042 exam is the pre-requisite for Oracle Database 10g OCP credential. Additionally, it also requires hands-on experience to obtain the credential. The 1z0-043 exam is meant for serious database professionals. Acquiring an OCP credential is a real professional accomplishment that requires training and hands-on experience.

Q. What credit it provides?

A. After passing the 1z0-043 exam, you will be Oracle 10g certified Professional (OCP) Also, you will be eligible

This is a preview of Everything you want to know about the 1z0-043 exam. Read the full post (725 words, 1 image, estimated 2:54 mins reading time)

No comments »

Posted in Everything you want to know, OCA, OCP

Tags:

Everything you want to know about the 1z0-045 test

September 13th, 2008

Q. What is the pre-requisite for taking the 1z0-045 test?

A. 1z0-045 is an upgrade test for all Oracle 8i OCPs (1z0-020). Therefore, to give 1z0-045, you must be 8i OCP. 1z0-045 is titled as Oracle Database 10g DBA New Features for Oracle8i OCPs. The best way to study for any certification is self-studying and getting hands on the software.

Q. How can I register for the test?

A. You can register yourself through the Oracle registered testing centers. After getting yourself registered for the test, you can contact the testing center to know the schedule (date and time) of your test. Oracle certifications can be taken only at authorized Prometric testing centers worldwide. The test date may depend on your choice (and availability of slot) in your selected test center. You may choose to register yourself online at Prometric Website .

This is a preview of Everything you want to know about the 1z0-045 test. Read the full post (1221 words, 1 image, estimated 4:53 mins reading time)

No comments »

Posted in Everything you want to know, OCA, OCP

Tags:

Everything you want to know about the 1Z0-040 test

August 28th, 2008

Q. What is the pre-requisite for taking the 1Z0-040 test?

A. The prerequisite for the 1Z0-040 test is Oracle Database 10g: New Features for Administrators Release 2 (1z0-030). The 1Z0-040 (OCP) is a step that upgrades your 9i OCP credential to 10g credential. Generally, one test is required for OCPs to upgrade to each new release of an Oracle DBA track. The Oracle Database 10g certification track is a step towards a successful career as an Oracle professional. However, you must be well experienced with the SQL before you take the test. Self-studying and self-schooling can certainly help you prepare for the test. This will require a lot of dedication and practice managing a database and newly added features in 10g.

Q. How can you register for the test?

This is a preview of Everything you want to know about the 1Z0-040 test. Read the full post (1272 words, 1 image, estimated 5:05 mins reading time)

No comments »

Posted in Everything you want to know, OCA, OCP

Tags:

Everything you want to know about the 1z0-047 test

August 5th, 2008

Q. What is the pre-requisite for taking the 1z0-047 test?

A. There is no pre-requisite for the 1Z0-047 test. The 1z0-047 is a Beta test, known by the name Oracle Database SQL Expert. The production test of the same (1Z0-047) is available now. You can entirely waive your 1Z0-007 credential, which is for OCP by taking the 1z0-047 test. The Oracle database credential track is the most preferable to start a career as Oracle professional. Before taking the 1z0-047 test, you must be proficient with using SQL queries and statements.

Q. What exactly are Beta tests?

This is a preview of Everything you want to know about the 1z0-047 test. Read the full post (1083 words, 1 image, estimated 4:20 mins reading time)

No comments »

Posted in Everything you want to know, OCA, OCP

Tags:

Bas Appraises uCertify’s OCP PrepKit

May 7th, 2008

Bas Appraises uCertify’s OCP PrepKit

Bas Klaassen is a member of Oracle community. He has been an Oracle EBS Dba for 8 years and residing in the Netherlands. He is also being certified with OCA 10g and currently preparing for OCP 10g certification exam.

Klaassen reviewed the 1Z0-043 PrepKit for the OCP 10g certification and found it very useful. He remarked, “I think the tool is great for preparing for your Oracle OCP exam, and I am sure the prepkit will help me prepare.” Please read the complete review at My Oracle EBS Dba Blog.

Permanent link to this post (91 words, 1 image, estimated 22 secs reading time)
Share

No comments »

Posted in OCP, Reviews

Tags:

Targeting Oracle 10g DBA Certifications

January 21st, 2008

What is Oracle certification? How many Oracle credentials are available? Which credential to choose in order to start the certification path? These are some of the questions that may be striking your mind.

This article will provide you sufficient insight to all the certification programs offered by Oracle on the 10g technology. We will also try to explain the various job roles and the strategies to be adopted while preparing for these certification exams.

Certification paths

Here’s a description of the three levels of certification paths:

Oracle 10g OCA: The Oracle 10g OCA is the first step in the Oracle database 10g certification track. It is the stepping-stone in the Oracle 10g certification path. The demand for a highly skilled DBA is on the rise, and OCA credential is a great way to get started. It is an entrance level credential and makes the foundational skills robust to manage important database administration and configuration functions. To become an OCA on Oracle 10g, you will have to pass the 1Z0-042 exam.

This is a preview of Targeting Oracle 10g DBA Certifications. Read the full post (674 words, 1 image, estimated 2:42 mins reading time)

No comments »

Posted in OCA, OCP

Tags:

PrepKit Tour | Volume licensing | PrepEngine Features | Articles | Contact Us | Privacy Policy | Translation
Microsoft Certification | Oracle Certification | Adobe Certification | CompTIA Certification | EC-Council Certification
Visual Studio 2010 MCTS, MCITP    New SUN Oracle Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT
A+, Network+, Security+ Project+ Oracle Certification: OCP 11g, OCA 11g, Oracle Java Web Services Developer, Oracle MySQL Developer
CIW Associate Ethical Hacker, CHFI, GISP, GSLC, CISSP    Photoshop ACE CS5    Adobe Flex 4, PMP, CAPM,
© 2012 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.