Oracle8i Architecture and Administration Set 1

PUBLIC ✘ WITH PRIVILEGE ✘ WITH ADMIN OPTION ✘ WITH GRANT OPTION ✔

SESSION_PRIVS

✘

DBA_SYS_PRIVS

✘

DBA_COL_PRIVS

✘

DBA_SESSION_PRIVS

✔

With the ADD CONROLFILE command. ✘ By using the files in the STARTUP command. ✘ With the MULTIPLEX control file command. ✘ By listing the files in the CONTROL_FILES parameter. ✔

V$CONTROLFILE

✘

DBA_CONTROLFILE

✘

V$CONTROLFILE_RECORD_SECTION

✘

DBA_CONRTOLFILE_RECORD_SECTION

✔

Creating a table. ✘ Dropping an index. ✘ Taking a rollback segment offline. ✘ Exporting a consistent image of a large number of tables. ✔

V$DATABASE

✘

DBA_CHARACTER_SET

✘

NLS_DATABASE_PARAMETERS

✘

NLS_DATABASE_CHARACTERSET

✔

By creating the database ✘ By installing the Oracle software ✘

By setting the initialization parameter CHARACTER_SET

✘

By setting the environment variable DB_CHARACTER_SET

✔

An Oracle instance can access multiple databases at one time only. ✘ An Oracle instance has a minimum of three background processes. ✘ An Oracle instance consists of the shared pool and the redo log files. ✘ The memory allocated by an Oracle instance is shareable by the database processes. ✔

The user process. The Oracle login process. The Oracle server process. The system monitor (SMON) process. The process monitor (PMON) process.

Context area ✘ Log buffer area ✘ Shared pool area ✘ Data buffer cache ✔