Articles for Oracle9i Database: Fundamentals I 1Z0-031
How is a constraint disabled?
A constraint is disabled using the DISABLE clause of the ALTER TABLE statement. When disabling a constraint, the VALIDATE or NOVALIDATE keyword can be used with the DISABLE clause.
The VALIDATE keyword specifies that the constraint is disabled and all indexes used to enforce the constraint are......
continue reading "How is a constraint disabled?" »
How is a constraint enabled?
A constraint is enabled using the ENABLE clause of the ALTER TABLE statement. When enabling a constraint, the VALIDATE or NOVALIDATE keyword can be used with the ENABLE clause.
The VALIDATE keyword specifies that all existing rows in the table and new rows inserted in the table must comply......
continue reading "How is a constraint enabled?" »
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 index's usage monitored?
The V dynamic performance view displays statistics about index usage. It can be used to determine whether or not an index is used during database transactions. If it is found that the index is not used, it can be dropped. Dropping unused indexes eliminates unnecessary overhead and consequently......
continue reading "How is an index's usage monitored?" »
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 database shut down?
The SHUTDOWN command is used to shut down an Oracle database. Only a database administrator can shut down an Oracle database. An Oracle database is shut down in three stages. First, the database is closed. Then, the database is unmounted. Finally, the associated Oracle instance is shut down.......
continue reading "How is an Oracle database shut down?" »
Skills required for Oracle test 1Z0-031.
Oracle has specified more than seventy-five objectives for 1Z0-031 (Oracle9i Database: Fundamentals I) test, which are grouped under eighteen topics. Before taking the test, one should have good command over the following areas:
Setting up password file authentication for administrative......
continue reading "Skills required for Oracle test 1Z0-031." »
Things to practice for Oracle test 1Z0-031.
Nearly eighty objectives have been specified for 1Z0-031 (Oracle9i Database: Fundamentals I) test. This clearly indicates that a candidate should have a sound knowledge about Oracle's architectural components and database structure before taking the test. One should also be capable of managing......
continue reading "Things to practice for Oracle test 1Z0-031." »
What are active and inactive online redo log files?
Log writer (LGWR) writes redo entries to online redo log files (groups) in a circular manner. The online redo log file that LGWR is currently writing to is called the current online redo log file. When the current online redo log file is full, a log switch occurs and LGWR starts writing to the......
continue reading "What are active and inactive online redo log files?" »
What are data files?
Data files are operating system files that store the data of all logical structures, such as tables, indexes, etc., in a database. A data file can belong to only one tablespace in a database. However, a tablespace can contain multiple data files. A data file can be created at the time of database......
continue reading "What are data files?" »
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-031 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 | 15 | 95 |
Tips and How Tos for 1Z0-031 exam
