Oracle8i Architecture and Administration Set 3

ALTER SYSTEM CHECKPOINT ✘ ALTER DATABASE CHECKPOINT ✘ ALTER SYSTEM SWITCH LOGFILE ✘ ALTER DATABASE SWITCH LOGFILE ✔

The instance crashes. ✘ The instance writes to the next online redo log group. ✘ The instance hangs until the DBA switches the redo log file. ✘ The instance hangs until the DBA restart the archive process. ✔

Free, below, PCTFREE ✘ Free, above, PCTFREE ✘ Used, below, PCTUSED ✘ Used, above, PCTUSED ✔

You should mix segments with short and long life spans in the same tablespace. ✘ You should keep good control over space allocation and define storage limits for users. ✘ You should use the autoextend feature on tablespaces that have a high update, delete, and insert activity. ✘ Data that is accesses by multiple users should be stored in tablespaces that reside on the same disk foreasier management. ✔

DBA_TABLES DBA_EXTENTS DBA_TABLESPACE DBA_FREE_SPACE DBA_SPACE_USAGE

Big, rarely ✘ Small, rarely ✘ Big, frequently ✘ Small, frequently ✔

CREATE ROLE sales_clerk;

✘

CREATE ROLE sales_clerk NOT IDENTIFIED;

✘

CREATE ROLE sales_clerk IDENTIFIED BY bonus;

✘

CREATE ROLE sales_clerk IDENTIFIED EXTERNALLY;

✔ CREATE ROLE sales_clerk IDENTIFIED INTERNALLY; ✔

It revokes all default roles from Scott. ✘ It makes all of the roles granted to Scott default roles. ✘ It makes all of the roles granted to Scott nondefault roles. ✘ It enables Scott's currently-disabled roles for the duration of this session. ✔ It disables Scott's currently-enabled roles for the duration of this session. ✔

DBA_USERS

✘

DBA_ROLES

✘

DBA_PASSWORDS

✘

V$PW_EXPIRATION

✔

None ✘ The SYSTEM profile ✘ The DEFAULT profile ✘

The RESOURCE_LIMIT profile

✔