Archive for the ‘OCA DBA 11g’ category

OCP 1z0-047 Short Notes: Exam passing tips

October 3rd, 2009

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.

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

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.

No comments »

Posted in OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g, SQL Certified Expert 10g, SQL Certified Expert 11g

Tags: 1Z0-047 1Z0-051

What is the REMOTE_OS_AUTHENT parameter?

September 30th, 2009

The REMOTE_OS_AUTHENT parameter in the parameter file of the database specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter or not. The type of the REMOTE_OS_AUTHENT parameter is Boolean, the default value is false, and the parameter class is static. The REMOTE_OS_AUTHENT parameter is case sensitive on some operating systems. The flow diagram below may help a user understand the role of the REMOTE_OS_AUTHENT parameter for a remote database:

This is a preview of What is the REMOTE_OS_AUTHENT parameter?. Read the full post (230 words, 1 image, estimated 55 secs reading time)

No comments »

Tags: 1Z0-042 1Z0-047

What is DBMS_SESSION PL/SQL package?

September 8th, 2009

The DBMS_SESSION PL/SQL package is used to provide access to the ALTER SESSION and ALTER SYSTEM statements. This package is also used for gathering session related information. The DBMS_SESSION PL/SQL package uses the privileges of the user executing this package, instead of using privileges of the user SYS.

Pass OCA DBA 10g in first attampt.
Pass OCA DBA 11g in first attampt.
Best exam simulation Oracle oca-dba9i download free trial.
Become Oracle OCA PL/SQL Developer certified.
Pass Oracle ocp-dba10g - OCP DBA 10g
Best exam simulation Oracle ocp-dba-11g download free trial.
Get certified in first attempt download ocp-dba9i - OCP DBA 9i simulation.
Click here to get free ocp-pl-sql OCP PL/SQL Developer exam practice questions.
Download free practice test for Oracle Oracle Certified Master 10g exam.
Get certified in first attempt download oracle-pl-sql - Oracle PL/SQL Developer simulation.
Download practice question and study guide for performance-tuning-certified-expert-11g for exam.
Click here to get free rac-administrator-certified-experts-10g RAC Certified Expert 10g exam practice questions.
Get certified in first attempt download sql-certified-expert-10g - SQL Certified Expert 10g simulation.
Get certified in first attempt download sql-certified-expert-11g - SQL Certified Expert 11g simulation.
Download free practice test for Oracle Oracle9i DB: Performance Tuning exam.
Best exam simulation Oracle 1Z0-042 download free trial.
Download practice question and study guide for 1Z0-047 for exam.
Download free practice test for 1Z0-051 OCA: Oracle Database 11g-SQL Fundamentals-I exam.

Permanent link to this post (229 words, estimated 55 secs reading time)

No comments »

Tags: 1Z0-033 1Z0-042 1Z0-047 1Z0-051

What is DECODE function?

September 1st, 2009

The DECODE function decodes a column value or an expression and compares it with each specified search value, one by one. If the expression matches a search value, a result value corresponding to the matching search value is returned. If no match is found, a default result value, if included, is returned. However, if no default value is included, a NULL value is returned. The DECODE function is one of the few single-row functions that directly deal with NULL values. It can compare two NULL values and can return a NULL value.

This is a preview of What is DECODE function?. Read the full post (255 words, estimated 1:01 mins reading time)

No comments »

Posted in OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA DBA 9i PL/SQL, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g

Tags: 1Z0-007

What is TO_CHAR (datetime) function?

September 1st, 2009

TO_CHAR (datetime) is a single-row function that is used to convert a value of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH LOCAL TIME ZONE datatype to a value of VARCHAR2 datatype in the specified date format.

Syntax:

TO_CHAR ( datetime [, fmt [, 'nlsparam' ]] )

This is a preview of What is TO_CHAR (datetime) function?. Read the full post (313 words, estimated 1:15 mins reading time)

No comments »

Tags: 1Z0-007 1Z0-031 1Z0-043 1Z0-047 1Z0-051 1Z0-053

Joins: Its Types and Uses

August 21st, 2009

The JOIN clause is used with the SELECT statement to retrieve data from more than one table. This clause matches data from multiple tables. This results in the creation of a table, which is a combination of columns from multiple tables.

This is a preview of Joins: Its Types and Uses. Read the full post (1034 words, estimated 4:08 mins reading time)

No comments »

Posted in MCITP, MCITP Database Administrator, MCITP Database Administrator SQL Server, MCITP Database Administrator SQL Server 2005, MCITP Database Developer SQL Server 2008, MCITP Microsoft SQL Server, MCP, OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g, SQL Certified Expert 10g, SQL Certified Expert 11g

Tags: 1Z0-047 1Z0-051 70-443 77-605

Relational Algebra

August 15th, 2009

Algebra is a formal structure, which consists of sets, and operations performed on these sets. Relational algebra is a formal structure for manipulating relations. There are various relational operators for manipulating relations. These operators take two tables, perform the operation, and return back the desired output.

This is a preview of Relational Algebra. Read the full post (1334 words, estimated 5:20 mins reading time)

No comments »

Posted in CIW Professional, Master CIW Enterprise Developer, OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g, SQL Certified Expert 10g, SQL Certified Expert 11g

Tags: 1D0-441 1Z0-047 1Z0-051

OCP 1z0-047 Short Notes: Exam passing tips

August 7th, 2009

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.

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

No comments »

Tags: 1Z0-047 1Z0-051

What is the REMOTE_OS_AUTHENT parameter?

August 4th, 2009

This is a preview of What is the REMOTE_OS_AUTHENT parameter?. Read the full post (207 words, 1 image, estimated 50 secs reading time)

No comments »

Tags: 1Z0-042 1Z0-047

What are conventional path loads?

July 27th, 2009

A conventional path load is a method of loading data into tables. This method uses the SQL INSERT statement and a bind array buffer for loading the data. It is the default method employed by every Oracle tool and application. In conventional path loads, the SQL*Loader has to compete with all other Oracle processes for buffer resources. However, this significantly deteriorates the speed of the load process as compared to direct path loads. Conventional path loads search for partially filled data blocks to fill them at each insert operation. This process also deteriorates the speed of conventional path loads. Conventional path loads are generally employed for loading data into clustered tables or where a small number of rows are to be inserted into a large indexed table.

Click here to get free oca-dba-11g OCA DBA 11g exam practice questions.
Best exam simulation Oracle ocp-dba-11g download free trial.
Pass Oracle ocp-dba9i - OCP DBA 9i
Best exam simulation Oracle performance-tuning-certified-expert-11g download free trial.
Download practice question and study guide for rac-administrator-certified-experts-10g for exam.
Get certified in first attempt download 1Z0-033 - Oracle9i DB: Performance Tuning simulation.
Become Oracle OCA: Oracle Database 11g: Administration I certified.

Permanent link to this post (195 words, estimated 47 secs reading time)

No comments »

Posted in OCA DBA 11g, OCP DBA 11g, OCP DBA 9i, Performance Tuning Expert 11g, RAC Certified Expert 10g

Tags: 1Z0-033 1Z0-052

« Older Entries