Articles for Oracle Database 10g: Administration I 1Z0-042
Architecture of Oracle Instance
The Oracle architecture consists of a number of primary components:
Orace server:
Oracle instance
Oracle database Oracle instance
An oracle instance is the combination of various background processes and memory structures. The background processes consist of PMON, SMON, DBWR,......
continue reading " Architecture of Oracle Instance" »
TheDatabase Configuration Assistant (DBCA) FEATURE
The Database Configuration Assistant (DBCA) is Graphical User Interface (GUI) tool. DBCA is one of the three ways used to create a database. It provides a user-friendly, wizard based, and step-by-step process to create a database. It is java-based. The DBCA enables us to specify memory options,......
continue reading " TheDatabase Configuration Assistant (DBCA) FEATURE" »
Automatic Storage Management
Enterprises are preferably switching from old existing Oracle versions, such as Oracle 8i and Oracle 9i, to Oracle 10g to have various additional profitable features. They often employ the Automatic Storage Management (ASM) option to enhance the manageability and consolidation of a database.......
continue reading "Automatic Storage Management" »
DATABASE LOCKS
When many users are performing transactions on the same database, database locks become inevitable. When a resource is locked, database users are put in a queue on a First In First Out (FIFO) basis for accessing that resource.
In this article, a number of ways have been described to detect and......
continue reading "DATABASE LOCKS" »
How does an Oracle shared server differ from a dedicated server?
In a dedicated server process, every user process on a client computer is connected to a separate virtual dedicated server process (shadow process) on the computer on which the Oracle server is installed. Each client's request is processed by a separate dedicated server. The server process......
continue reading "How does an Oracle shared server differ from a dedicated server?" »
How is an Oracle database opened?
The STARTUP command is used to open an Oracle database. Only a database administrator can open an Oracle database. An Oracle database is opened in three stages. First, an Oracle instance is started. Then, the instance mounts the specified database. Finally, the database is opened.
When......
continue reading "How is an Oracle database opened?" »
How to check whether a database has used a PFILE or an SPFILE?
A database user will run the following SQL query to check whether a PFILE or an SPFILE has been used by the database:
SELECT DECODE (value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_ WHERE name = 'spfile';
Alternatively, a database user can use the V view......
continue reading "How to check whether a database has used a PFILE or an SPFILE?" »
How to install Oracle 10g software?
Take the following steps to install Oracle10g software:
The Oracle Universal Installer (OUI) is used to install and configure the Oracle 10g software. Mount the CD in the server's CD-ROM. The Welcome window will be displayed as follows:
Click the Next tab to proceed.
The......
continue reading "How to install Oracle 10g software?" »
OCA 1z0-042 Short Notes: Exam passing tips
Oracle architecture The size of the shared pool can be changed dynamically. The data dictionary cache of the shared pool holds the most recently accessed data dictionary information. The shared pool consists of a library cache and data dictionary cache. Control file, redo log file, and data......
continue reading "OCA 1z0-042 Short Notes: Exam passing tips" »
Role to export data
In order to perform a full database export, a database user should have the EXP_FULL_DATABASE role....
continue reading "Role to export data" »
In Stock (
US$ 79.99 64.99
)
Download and try this PrepKit for free. As soon you place the order, we will send you the registration code. Use it to unlock the PrepKit and start learning. Its that easy!
1Z0-042 PrepKit at a Glance
| Includes | Free | Buy |
|---|---|---|
| Version | 8.07.05 | |
| Practice Tests | 1 | 4 |
| 15 | 414 | |
| Quiz | 15 | 191 |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 34 | 232 |
Tips and How Tos for 1Z0-042 exam
