1. You always want to tune up the solution. How do you identify the unnecessary parse calls?

a.Run your
application with the SQL trace facility enabled.

b.Run your application with the SQL trace facility disabled.

c.Run your application with
Oracle Expert enabled.

d.Run your application with EXPLAIN PLAN enabled.

e.None of the choices.

Ans: Run your application with the SQL
trace facility enabled.


2. You always want to tune up the solution. You want to fine tune the memory settings. When should you increase the
size of the redo log buffer?

a . When the space request ratio is greater than 1:50

b . When the space request ratio is greater than 1:500


c . When the space request ratio is greater than 1:1000

d . When the space request ratio is greater than 1:5000

e . When the space
request ratio is greater than 1:15000

f . None of the choices.


Ans: When the space request ratio is greater than 1:5000

3. You always
want to tune up the solution. How do you instruct Oracle to read the entire SGA into memory when you start your instance?

a . Configure the
initialization parameter PRE_PAGE_SGA to YES

b . Configure the initialization parameter PAGE_SGA to YES

c . Configure the initialization
parameter PAGE_SGA_RAM to YES

d . Configure the initialization parameter PAGE_SGA_LOAD to YES

e . None of the choices.


Ans: Configure
the initialization parameter PRE_PAGE_SGA to YES

4. You are the Database Administrator for your company. You are managing an Oracle 8i database
solution. You always want to tune up the solution. You plan to use a nonunique index to enforce a UNIQUE constraint. What is the advantage of doing
this?

a . No need to rebuild the constraints index when you change the constraint from disabled to enforced

b . You save 50% of the time
spent on rebuilding the constraints index when you change the constraint from disabled to enforced

c . You save 75% of the time spent on
rebuilding the constraints index when you change the constraint from enabled to enforced

d . You save 90% of the time spent on rebuilding the
constraints index when you change the constraint from enabled to enforced

e . None of the choices.


Ans: No need to rebuild the constraints
index when you change the constraint from disabled to enforced

5. You are the Database Administrator for your company. You are managing an
Oracle 8i database solution. You always want to tune up the solution. What command do you use to reorganize an existing index?

a . ALTER
DATABASE ... REBUILD INDEX

b . ALTER SYSTEM ... REBUILD INDEX

c . ALTER SESSION ... REBUILD INDEX

d . ALTER INDEX ... REBUILD

e .
None of the choices.


Ans: ALTER INDEX ... REBUILD

6. You are the Database Administrator for your company. You are managing an Oracle 8i
database solution. You always want to tune up the solution. What command do you use to compact an existing index?

a . ALTER DATABASE ... REBUILD
INDEX COMPACT

b . ALTER SYSTEM ... REBUILD COMPACT

c . ALTER SESSION ... REBUILD INDEX COMPACT

d . ALTER INDEX ... REBUILD

e . None
of the choices.


Ans: ALTER INDEX ... REBUILD


7. You are the Database Administrator for your company. You are managing an Oracle 8i
database solution. You always want to tune up the solution. What command do you use to change the storage characteristics of an existing index?


a . ALTER DATABASE ... REBUILD INDEX SETTINGS

b . ALTER SYSTEM ... REBUILD SETTINGS

c . ALTER SESSION ... REBUILD INDEX CHANGE

d .
ALTER INDEX ... REBUILD

e . None of the choices.


Ans: ALTER INDEX ... REBUILD

8. You always want to tune up the solution. You like to
enable FAST FULL SCAN. How do you enable this feature?

a . set the FAST_FULL_SCAN_ENABLED parameter to TRUE

b . set the
FAST_FULL_SCAN_ENABLED parameter to YES

c . set the FAST_FULL_SCAN parameter to TRUE

d . set the FAST_ SCAN_ENABLED parameter to YES

e .
None of the choices.

Ans: set the FAST_FULL_SCAN_ENABLED parameter to TRUE


9. You always want to tune up the solution. You like to enable
FAST FULL SCAN. What is the index hint type associated with FAST FULL SCAN?

a . INDEX_FFS

b . INDEXFFS

c . FFS_INDEX

d . FFSINDEX


e . FFS_INDEX

f . None of the choices.


Ans: INDEX_FFS

10. You are advised to index only the columns with good selectivity. Which
of the following correctly describe a columns selectivity?

a . the percentage of rows in a table having the same value for the indexed column.


b . the percentage of rows in a table having the different values for the indexed column.

c . the percentage of rows in a table having the
same value for the non-indexed column.

d . the percentage of rows in a table having the different values for the non-indexed column.

e .
None of the choices.

Ans: the percentage of rows in a table having the same value for the indexed column.

---