Oracle8i Architecture and Administration Set 2

DB_OBJECTS

✘

ALL_OBJECTS

✘

DBA_OBJECTS

✘

USER_OBJECTS

✔

To export a users schema. ✘ To group related PL/SQL packages, functions, and procedures. ✘ To hide application code by encrypting PL/SQL package bodies. ✘ To hide application code by encrypting PL/SQL package applications. ✔

It is entered into the free list of table. ✘ It is inaccessible to INSERT statements. ✘ It is deleted from the free list of the table. ✘ It is inaccessible to DELETE statements. ✔ It is inaccessible to UPDATE statements. ✔

All equal ✘

No larger than five times DB_BLOCK_SIZE

✘ Equal to the size of the biggest possible row ✘

A multiple DB_FILE_MULTIBLOCK_READ_COUNT

✔

In the alert file ✘ In DBA_TABLES ✘ In DBA_ROWSTATS ✘ In the trace file produced by the ANALYZE command. ✔

DBA_SEGMENTS

✘

DBA_TABLES

✘

DBA_OBJECT

✘

DBA_OBJECTS

✔ DBA_SEGMENT ✔

Profile assignments do not affect current sessions. ✘ Profiles enable group resource limits for similar users. ✘ Profiles are assigned to users, roles, and other profiles. ✘ The ALTER USER command can be used to assign profiles to users. ✔

Account locking ✘ Password history ✘ Password change ✘ Password aging and expiration ✔

DBA_USERS

✘

DBA_PROFILES

✘

DBA_EXP_DATES

✘

V$ACC_EXPIRATION

✔

Query slaves insert the rows into temporary segments, which are converted to extents. ✘ The server process inserts the rows into temporary segments, which are converted to extents. ✘ Query slaves insert the rows into temporary segments, which are copied into existing table extents. ✘ The server process inserts the rows into temporary segments, which are copied into existing table extents. ✔ Query slave are assigned a range of blocks that are already part of the table and inserted into theirassigned blocks. ✔