1.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. Parallel Server

C. DBA Management Pack

D. Enterprise
Manager Packs

E. Partitioning

Ans:E.

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

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

B. You can drop tables from it

C.You can
drop indexes from it

D. You cannot drop anything from it

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



Ans:A,B,C.

#3.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 Alter

C. Database Quick Change

D. Database Propagate

E. Plan Manager

F.
Database Diff


Ans:F.


#4.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. Start an instance -> Mount the database -> Open the database

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

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


Ans:B.


#5.What
is the name of the file extension of the Oracle parameter file?


Ans:ora.


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

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

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

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

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

Ans:A.

#7.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. startup

B. control

C. instance

D. None of the
choices.

E. parameter



Ans:E.


#8.To specify that only one instance can use the password file, you should set the
REMOTE_LOGIN_PASSWORDFILE parameter to a value of (fill in the blank):

Ans:Exclusive.


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

A. JServer

B. Enterprise Manager Packs

C.
Partitioning

D. DBA Management Pack

E. Parallel Server


Ans:E.

#10.In Windows NT, what parameter specifies the actual location of
the parameter file (fill in the blank):

Ans:IFILE.

---