Articles for Oracle9i Database: Fundamentals II 1Z0-032
How are archive destinations specified?
When archiving redo logs, it must be decided whether to archive them to a single archive destination or multiplex them. When the archived redo logs are multiplexed, they are archived to more than one archive destination. The following two methods can be used to specify archive destinations:......
continue reading "How are archive destinations specified?" »
How are the archived redo log files' names determined when automatic archiving is enabled?
When a database is running in ARCHIVELOG mode, and automatic archiving is enabled, the archiver process (ARCn) automatically archives the filled online redo log files at specified archive destinations. ARCn automatically decides the names of the archived redo log files by looking at the......
continue reading "How are the archived redo log files' names determined when automatic archiving is enabled?" »
How is a checkpoint related to the cache recovery phase of a recovery process?
At certain time intervals, the database writer (DBWn) writes all modified (dirty) buffers from the database buffer cache to the data files on disk. This event is called a checkpoint. Whenever a checkpoint occurs, the checkpoint process (CKPT) updates the headers of data files and control files......
continue reading "How is a checkpoint related to the cache recovery phase of a recovery process?" »
How is a client/server connection established in a dedicated server environment?
In a dedicated server environment, a listener (the listener must be running on the same computer on which the server is running) starts a separate dedicated server process for each incoming client connection request. Based on the operating system and the transport protocol, the listener can use......
continue reading "How is a client/server connection established in a dedicated server environment?" »
How is a client/server connection established in a shared server environment?
In a shared server configuration, a fixed number of shared server processes are automatically started when an Oracle instance starts. However, clients are not directly connected to shared server processes. They are connected to their corresponding dispatcher processes instead. The dispatcher......
continue reading "How is a client/server connection established in a shared server environment?" »
How is a listener configured?
Oracle Universal Installer (the Oracle installation tool) launches Oracle Net Configuration Assistant during software installation. Oracle Net Configuration Assistant enables a user to configure the listening protocol addresses and service information for an Oracle database.
Oracle Net......
continue reading "How is a listener configured?" »
How is a tablespace taken offline and online?
The ALTER TABLESPACE TablespaceName OFFLINE; statement is used to take a tablespace offline. When a tablespace is taken offline, all associated data files are also taken offline. Taking a database's tablespace offline makes the tablespace unavailable for general use, while the rest of the......
continue reading "How is a tablespace taken offline and online?" »
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 is an Oracle shared server configured?
To configure an Oracle shared server, the following processes must be set to run on the server:
Listener process: A listener process contains the addresses of all the dispatchers in the Oracle shared server. The job of a listener is to constantly look out for user requests. Whenever it......
continue reading "How is an Oracle shared server configured?" »
How is the filename format of a control file autobackup configured?
By default, Recovery Manager (RMAN) uses a default filename format to store a control file autobackup, so that RMAN can search for the autobackup even if the RMAN repository (the recovery catalog or the control file's header) is inaccessible. However, the default filename format can be changed by......
continue reading "How is the filename format of a control file autobackup configured?" »
In Stock (
US$ 79.99 39.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-032 PrepKit at a Glance
| Includes | Free | Buy |
|---|---|---|
| Version | 8.02.05 | |
| Practice Tests | 1 | 4 |
| 30 | 280 | |
| Quiz | 15 | 100 |
| Final Test | No | Yes |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 14 | 94 |
Tips and How Tos for 1Z0-032 exam
