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

Ans:Ora.


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

A. You can drop tables from it

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

C. You cannot drop anything from it

D. You can drop indexes from it

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

Ans:A,B,D.

#3.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. Parallel Server

B.
Partitioning

C. DBA Management Pack

D. JServer

E. Enterprise Manager Packs


Ans:B.

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

A. Plan Manager

B. Database Alter


C. Database Propagate

D. Database Capture

E. Database Quick Change

F. Database Diff


Ans:F.

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

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


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

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

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


Ans:C.

#6.In Windows NT, what parameter specifies the actual location of the
parameter file?

Ans:IFILE.

#7.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. Dismount the database -> Shut down the instance -> Close the database


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

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


Ans:A.


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

B. instance

C. startup

D. None of the choices.

E. parameter


Ans:E.


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

A. Parallel Server

B. Enterprise Manager Packs

C. DBA Management Pack

D. JServer

E. Partitioning


Ans:A.

---