Oracle 10g, Databases

Question: What are two main advantages of using bitmap indexes?
A
Bitmap indexes use less storage space

B
Bitmap segments are updated upon COMMIT, at the end of the transaction

C
Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators

D
None of these

Note: not sure
1. Report
Question: Which of the following data dictionary views should be used to get a list of object privileges for all the database users?
A
DBA_TAB_PRIVS

B
ALL_TAB_PRIVS

C
USER_TAB_PRIVS

D
ALL_TAB_PRIVS_MADE

Note: not sure
1. Report
Question: Which of the following sets of tablespaces is mandatory for any Oracle 10g database?
A
SYSTEM, SYSAUX, and UNDOTBS

B
SYSTEM and UNDOTBS

C
SYSAUX and UNDOTBS

D
SYSTEM and SYSAUX

Note: not sure
1. Report
Question: Which tablespace is used as a temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?
A
TEMP

B
DATA

C
SYSTEM

D
ROLLBACK

Note: not sure
1. Report
Question: Which of the following graphical DBA administration tools is used to tune an Oracle database?
A
SQL*Plus

B
Oracle Enterprise Manager

C
Oracle Universal Installer

D
Oracle Database Configuration Assistant

Note: not sure
1. Report
Question: In an Oracle database environment, SGA is created:
A
When the database is created

B
When the instance is started

C
When the database is mounted

D
When a user process is started

Note: not sure
1. Report

Question: What are two main advantages of using bitmap indexes?