Posts Tagged ‘1Z0-031’

What is a log switch?

October 31st, 2009

A log switch occurs when the log writer (LGWR) finishes writing redo entries to the current online redo log file group and starts writing to the next online redo log file group. By default, a log switch occurs automatically when the current online redo log file group is full. A log switch can also be forced by executing the ALTER SYSTEM SWITCH LOGFILE; statement, regardless of whether or not the current online redo log file group is full.

Pass OCP DBA 9i in first attampt. Become Oracle Oracle9i Database: Fundamentals I certified.

Permanent link to this post (94 words, estimated 23 secs 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 9i, OCP DBA 9i

Tags: 1Z0-031

What is log writer (LGWR)?

September 8th, 2009

The log writer (LGWR) is an Oracle background process. It is responsible for writing all the new entries that have been copied in the redo log buffer since the LGWR last wrote the entries to a redo log file. The log writer should write the entries of the redo log buffer fast enough, so that buffers are immediately available for new entries.

Download free practice test for Oracle OCA DBA 9i exam.
Get certified in first attempt download ocp-dba9i - OCP DBA 9i simulation.
Get certified in first attempt download 1Z0-031 - Oracle9i Database: Fundamentals I simulation.
Pass Oracle 1Z0-032 - Oracle9i Database: Fundamentals II
Get certified in first attempt download 1Z0-033 - Oracle9i DB: Performance Tuning simulation.
Download practice question and study guide for 1Z0-040 for exam.
Pass Oracle 1Z0-042 - Oracle Database 10g: Admin - I
Download free practice test for Oracle Oracle Database 10g: Admin - II exam.
Click here to get free 1Z0-045 OCA, 10g New Feature for Oracle 8i Ocp exam practice questions.
Download free practice test for Oracle Oracle Database SQL Expert exam.
Best exam simulation Oracle 1Z0-052 download free trial.

Permanent link to this post (188 words, estimated 45 secs reading time)

No comments »

Posted in OCA DBA 9i, OCP DBA 9i

Tags: 1Z0-031 1Z0-032 1Z0-033 1Z0-040 1Z0-042 1Z0-043 1Z0-045 1Z0-047 1Z0-052

What is an online redo log group?

September 2nd, 2009

An online redo log group consists of an online redo log file that may or may not be multiplexed. In other words, an online redo log group may be a single online redo log file or a set of identical copies of an online redo log file. Each copy of an online redo log file in an online redo log group is called a member.

This is a preview of What is an online redo log group?. Read the full post (287 words, estimated 1:09 mins reading time)

No comments »

Posted in OCA DBA 9i, OCP DBA 10g, OCP DBA 9i, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-031 1Z0-043

What is an undo segment?

September 2nd, 2009

An undo segment holds all undo data of a database when the database is running in automatic undo management mode. An undo segment is internally similar to a rollback segment that is used to hold undo data of a database when the database is running in manual undo management mode.

This is a preview of What is an undo segment?. Read the full post (215 words, estimated 52 secs reading time)

No comments »

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

Tags: 1Z0-031 1Z0-053

What is Oracle’s password aging and expiration feature?

September 2nd, 2009

Oracle’s password aging and expiration feature ensures that the password of a user account expires after a specified number of days. The user or the database administrator must change the password once it has expired. The PASSWORD_LIFE_TIME parameter is used to specify the number of days after which a user account’s password expires.

This is a preview of What is Oracle’s password aging and expiration feature?. Read the full post (172 words, estimated 41 secs reading time)

No comments »

Posted in OCA DBA 9i, OCP DBA 9i

Tags: 1Z0-031

What is Oracle’s password complexity verification feature?

September 2nd, 2009

Oracle’s password complexity verification feature ensures that a password is too complex to be guessed easily. The complexity of a password can be verified before a user can set the password for his account. The PASSWORD_VERIFY_FUNCTION parameter specifies a PL/SQL script that is used to verify the complexity of a password. Oracle provides a default PL/SQL script for this purpose. However, users can also create their own scripts. For example, a script can be created to verify that a password has a minimum length of four characters, the password is not the same as the account’s name, the password has at least one alphabetical, one numeric, and one punctuation mark character, the password is not a simple or obvious word, and the password differs from the previous password by at least three characters.

Download free practice test for ocp-dba9i OCP DBA 9i exam. Download free practice test for 1Z0-031 Oracle9i Database: Fundamentals I exam.

Permanent link to this post (156 words, estimated 37 secs reading time)

No comments »

Posted in OCA DBA 9i, OCP DBA 9i

Tags: 1Z0-031

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 (288 words, estimated 1:09 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, SQL Certified Expert 10g, SQL Certified Expert 11g

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

What is high water mark?

July 29th, 2009

The high water mark acts as an indicator within a data segment, which demarcates the used and the unused space, or space that has been formatted for user data. The space below this mark cannot be released even if there is no user data in it. If the segment is completely empty, a user can release that space by issuing the TRUNCATE .. DROP STORAGE statement.

Pass OCA DBA 9i in first attampt.
Download free practice test for Oracle OCP DBA 9i exam.
Download free practice test for 1Z0-031 Oracle9i Database: Fundamentals I exam.
Pass Oracle 1Z0-033 - Oracle9i DB: Performance Tuning
Become Oracle OCA, 10g New Feature for Administrator certified.
Pass Oracle Database 10g: Admin - II in first attampt.
Best exam simulation Oracle 1Z0-045 download free trial.

Permanent link to this post (130 words, estimated 31 secs reading time)

No comments »

Posted in OCA DBA 9i, OCP DBA 9i

Tags: 1Z0-031 1Z0-033 1Z0-040 1Z0-043 1Z0-045

What is a bitmap index?

July 26th, 2009

A bitmap index is used for data warehouse applications, where there are large amounts of data. Queries are more frequently issued than data updates. Hence, bitmap index proves more efficient than conventional indexes in retrieving data. A bitmap index is built on columns with low cardinality, unlike the B-tree index that is built on columns with high cardinality. The bitmap index uses a bitmap to indicate that a row with the required key value exists. It does so by setting the bit at the corresponding column of the bitmap to 1. For example, consider that the bitmap index is built on a column that contains three distinct city names, Las Vegas, New York, and Paris. A conventional index employing the row-id value would look such as the one below:

This is a preview of What is a bitmap index?. Read the full post (284 words, estimated 1:08 mins reading time)

No comments »

Posted in OCA DBA 10g, OCA DBA 9i, OCP DBA 10g, OCP DBA 9i, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-031 1Z0-033 1Z0-042

What is process monitor (PMON)?

July 25th, 2009

The process monitor (PMON) is an Oracle background process that is responsible for performing the cleaning of failed user database connections. This process involves the releasing of blocks that were involved in the failed connection, from the database buffer cache. It also involves the releasing of the resources used by a user process at the time of connection failure. The resource releasing includes removing the locks from database objects that were involved in the failed connection, and removing process id’s of the failed processes from the list of active processes.

Become Oracle OCA DBA 9i certified.
Download practice question and study guide for ocp-dba9i for exam.
Click here to get free 1Z0-031 Oracle9i Database: Fundamentals I exam practice questions.
Get certified in first attempt download 1Z0-032 - Oracle9i Database: Fundamentals II simulation.
Become Oracle Oracle9i DB: Performance Tuning certified.
Download free practice test for Oracle OCA, 10g New Feature for Administrator exam.
Become Oracle Oracle Database 10g: Admin - I certified.
Download practice question and study guide for 1Z0-043 for exam.
Click here to get free 1Z0-045 OCA, 10g New Feature for Oracle 8i Ocp exam practice questions.
Click here to download 1Z0-052 test study guide and practice question.