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.

Download free practice test for Oracle OCP DBA 9i exam. Become Oracle Oracle9i Database: Fundamentals I certified.

Permanent link to this post (97 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 oca-dba9i OCA DBA 9i exam.
Click here to download ocp-dba9i test study guide and practice question.
Pass Oracle9i Database: Fundamentals I in first attampt.
Download free practice test for Oracle Oracle9i Database: Fundamentals II exam.
Download practice question and study guide for 1Z0-033 for exam.
Click here to download 1Z0-040 test study guide and practice question.
Download free practice test for Oracle Oracle Database 10g: Admin - I exam.
Best exam simulation Oracle 1Z0-043 download free trial.
Best exam simulation Oracle 1Z0-045 download free trial.
Best exam simulation Oracle 1Z0-047 download free trial.
Best exam simulation Oracle 1Z0-052 download free trial.

Permanent link to this post (169 words, estimated 41 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 (224 words, estimated 54 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 (174 words, estimated 42 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.

Click here to get free ocp-dba9i OCP DBA 9i exam practice questions. Become Oracle Oracle9i Database: Fundamentals I certified.

Permanent link to this post (154 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 (307 words, estimated 1:14 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.

Click here to get free oca-dba9i OCA DBA 9i exam practice questions.
Click here to get free ocp-dba9i OCP DBA 9i exam practice questions.
Download free practice test for Oracle Oracle9i Database: Fundamentals I exam.
Download practice question and study guide for 1Z0-033 for exam.
Pass OCA, 10g New Feature for Administrator in first attampt.
Click here to get free 1Z0-043 Oracle Database 10g: Admin - II exam practice questions.
Download practice question and study guide for 1Z0-045 for exam.

Permanent link to this post (147 words, estimated 35 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 (296 words, estimated 1:11 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.

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