Oracle8i New Features for Administrators Set 1

ORAINST ✘ Enterprisemanager ✘ Universal installer ✘ Database Replication Assistant ✔ Database configuration Assistant ✔

They share resources with the calling transaction. ✘ Committed changes in an autonomous transaction are visible to other transactions (except possibly thecalling transaction) regardless of whether the calling transaction commits or rolls back. ✘ Deadlocks between the autonomous transaction and its calling transaction are previewed. ✘ Savepoint names need to be unique between the calling transaction and the autonomous transaction. ✔

SQL statement hints. ✘ Statement pinning in the large pool. ✘ Statement pinning in the shared pool. ✘ Automatic analysis of objects to collect current statistics. ✔

Dropping the partition. ✘ Splitting the partition. ✘ Modifying the partition of a global index. ✘ Rebuilding the partition of a local index. ✔

A free list contains information about free blocks in the file. ✘ A set of blocks in the system tablespace tracks space usage. ✘ Dictionary tables in the system tablespace track space usage. ✘ A file bitmap contains information about free blocks in the file. ✔ A dictionary table contains information about free blocks in the file. ✔

Roll back a transaction ✘ Store resource usage statistics ✘ Facilitate validation before committing ✘ Hold rows inserted into temporary tables. ✔

A parallel server environment will allow only one user connection per instance. ✘

The PARALLEL_AUTOMATIC_TUNING initialization parameter is automatically set to TRUE.

✘ The requested degree of parallelism, specified on a table or through a hint, is reduced to match the currentload. ✘ The total number of concurrent parallel query slaves will have a hard-coded platform-dependent maximumvalue. ✔

To verify whether a set of tablespaces is self-contained. ✘

To create and display the table TRANSPORT_SET_VIOLATIONS

✘ To verify the consistency of a set of unplugged tablespaces. ✘ To check whether a set of tablespaces was successfully transported. ✔

Archive logs generated by the standby database. ✘ Archive logs copied by the DBA from the primary site. ✘ Archive logs copied automatically from the primary site. ✘ Default destination for archiving in the event a current archive destination becomes unavailable. ✔

ALTER INDEX emp_indx REBUILD COMPUTE STATISTICS;

✘

ALTER INDEX emp_indx REBUILD COLLECT STATISTICS;

✘

ALTER INDEX emp_indx REBUILD ESTIMATE STATISTICS;

✘

ALTER INDEX emp_indx REBUILD;ANALYZE TABLE emp COLLECT STATISTICS;

✔