1.Which of the following components of the Change Management Pack can you use to compare differences in the
object definitions of your databases?

A. Database Capture

B. Database Quick Change

C. Database Diff

D. Database Alter

E.
Database Propagate

F. Plan Manager

Ans:C

2.What facilities of Oracle 8i Enterprise enables control over tables and indexes at a lower
level of granularity so that scalability and availability can be enhanced?

A. JServer

B. DBA Management Pack

C. Partitioning

D.
Enterprise Manager Packs

E. Parallel Server


Ans:c


3.Which of the following correctly describe the order of the events occurring
during a database startup?

A. Mount the database -> Open the database -> Start an instance

B. Mount the database -> Start an instance ->
Open the database

C. Start an instance -> Mount the database -> Open the database

D. Start an instance -> Open the database -> Mount the
database


Ans:C

4.What is the name of the file extension of the Oracle parameter file?


Ans:ora

5.In Oracle Oracle 8i, which of
the following correctly describe the use of the read only tablespace?

A. You can drop indexes from it

B. It is placed in the read only mode
by the ALTER DATABASE ... READ ONLY command

C. You cannot drop anything from it

D. It is placed in the read only mode by the ALTER
TABLESPACE ... READ ONLY command

E. You can drop tables from it


Ans:A,D,E


6.What facilities of Oracle 8i Enterprise allows more than
one Oracle software to access a single database so that scalability can be provided?

A. Partitioning

B. Parallel Server

C. Enterprise
Manager Packs

D. DBA Management Pack

E. JServer


Ans:B

7.In Windows NT, what parameter specifies the actual location of the
parameter file


Ans:IFILE

8.To specify that only one instance can use the password file, you should set the REMOTE_LOGIN_PASSWORDFILE
parameter to a value of


Ans:EXCLUSIVE

9.Refer to the exhibit:

db_name =U15

control_files =

(/DISK1/control01.con,/DISK2/control01.con)

db_block_size =8192

db_block_buffers =2048

shared_pool_size =52428800

log_buffer =64K


processes =50

db_files =1024

log_files =10

max_dump_file_size =10240

background_dump_dest =(/home/disk3/user15BDUMP)


user_dump_dest =(/home/disk3/user15UDUMP)

core_dump_dest =(/home/disk3/user1CBDUMP)

rollback_segments =(r01,r02,r03,r04,r05,r06,r07,r08)


The above information is likely to be included in which of the following files?

A. instance

B. parameter

C. startup

D. control


E. None of the choices.


Ans:B

10.Which of the following correctly describe the order of the events occurring during a database
shutdown?

A. Close the database -> Shut down the instance-> Dismount the database

B. Shut down the instance -> Close the database ->
Dismount the database

C. Close the database -> Dismount the database -> Shut down the instance

D. Dismount the database -> Shut down the
instance -> Close the database


Ans:C

---