Articles for Oracle 10g New Feature for Administrator 1Z0-040
Automatic Storage Management (ASM)
The ASM software components are shipped with Oracle 10g database. They are always available as the storage type in the Configure Automatic Storage Management window for the SYSTEM, SYSAUX, and other default tablespaces while creating a database. ...
continue reading "Automatic Storage Management (ASM)" »
Calendaring expression or PL/SQL block
When more complicated and sophisticated capabilities are required for the repeat_interval attribute while creating a schedule then PL/SQL block is preferably used. The PL/SQL block must evaluate to a timestamp or a date. An example of using PL/SQL block to specify the repeat_interval is given......
continue reading "Calendaring expression or PL/SQL block" »
Caution with the BYYEARDAY specifier.
The BYYEARDAY specifier in a calendaring expression specifies the day of the year as a number. A certain amount of caution is required while using the BYYEARDAY specifier for a leap year. For example, the number -17 will evaluate to December 15 always. ...
continue reading "Caution with the BYYEARDAY specifier." »
Cross platform transportable tablespace
During cross-platform transportable tablespaces operation the destination host uses ASM storage, and the CONVERT command is used to move the data into ASM. Operating system utilities cannot be used to move data into ASM....
continue reading "Cross platform transportable tablespace" »
OCP 1z0-040 Short Notes: Exam passing tips
New Features of Oracle 10g, Oracle 10g Installation, Server Configuration, and Maintenance of the Software
Memory - 512MB, Temp space - 400MB of free space in the /tmp directory applicable for the Unix operating system, Swap space - 1GB or twice the amount of RAM, Free disk space - 1.5GB are......
continue reading "OCP 1z0-040 Short Notes: Exam passing tips" »
Skills required for Oracle test 1z0-040
Oracle has specified 1z0-040 (Oracle Database 10g: New features for Administrators) as an upgrade certification test, which helps one to upgrade from an Oracle 9i Certified Professional to an Oracle 10g Certified Professional (OCP). Oracle specifies 80 objectives under 17 chapters. Before taking......
continue reading "Skills required for Oracle test 1z0-040" »
The Segment Shrink Functionality in Oracle 10g
Oracle 10g is a revolutionary product in Oracle's grid computing world. Oracle 10g is a DBMS, which can automate many database tasks. It follows the Oracle's 9i platform; the letter 'g' in Oracle 10g signifies grid computing .
The DBA has the most critical and responsible task to be......
continue reading "The Segment Shrink Functionality in Oracle 10g" »
Things to practice for Oracle test 1z0-040
Oracle has designed 1z0-040 (Oracle Database 10g: New features for Administrators) as an upgrade certification test, which helps you to upgrade from an Oracle 9i Certified Professional to an Oracle 10g Certified Professional (OCP). Apart from studying books and taking various practice tests, you......
continue reading "Things to practice for Oracle test 1z0-040" »
Valid value for the BYWEEKNO specifier in a calendaring expression
The BYWEEKNO specifier specifies the week numbers of the year in a calendaring expression. It follows ISO-8601 standard. It is valid only for FREQ = YEARLY....
continue reading "Valid value for the BYWEEKNO specifier in a calendaring expression" »
What are seed templates?
Seed templates are XML-based templates used to create Oracle databases. Seed templates are used in DBCA to make clones of existing (seed) databases. The information in seed templates are as follows:
Database options
Initialization parameters
Storage attributes (data files, redo logs,......
continue reading "What are seed templates?" »
In Stock (
US$ 79.99 59.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-040 PrepKit at a Glance
| Includes | Free | Buy |
|---|---|---|
| Version | 8.01.05 | |
| Practice Tests | 1 | 5 |
| 30 | 261 | |
| Quiz | 15 | 111 |
| Final Test | No | Yes |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 15 | 195 |
Tips and How Tos for 1Z0-040 exam
