|
Check
some 032 questions. Specially for you.
1.
What criterion does Oracle9i use to determine whether a
database file is an Oracle Managed
File?
A.
The filename format.
B.
Information stored inside a data dictionary table.
C.
Information stored in the ALERT.LOG file for the corresponding
instance.
D.
Information stored inside the corresponding initialization
parameter file for the
instance.
Answer:
A
2.
Which statement correctly describes the function of
Oracle9i Cache Fusion feature?
A.
It provides each session with its own view of the database at a
different point in the
past.
B.
It enables you to execute scalable applications on a clustered
database without having
to
partition the users or the database tables.
C.
It lets you dynamically reassign memory in your database buffer
cache to different
block
buffer sizes.
D.
It allows you to add new sites to multimaster replication
environment without
quiescing
the master definition site.
Answer:
B
3.
What is the new Oracle Shared Server?
A.
An improved version of multithreaded server configuration.
B.
A connection pooling configuration where several clients are
connected to the same
server
process.
C.
Two more database servers, which share data by means of database
links; the client
software
is unaware to which server it is connected.
D.
A configuration of Real Application Cluster where the client
connection is routed to
the
least busy instance.
Answer:
A
4.
The Oracle Shared Server architecture reduces memory usage
by reducing the number of server processes required. To process a
request for a server process, the following tasks
are performed:
-
A shared server picks up the request from the
request queue and processes the request.
-
The dispatcher retrieves the response from
the response queue.
-
A user sends a request to its dispatcher.
-
The dispatcher returns the response to the
user.
-
The shared sever places the response on the
calling dispatcher’s response queue.
-
The dispatcher places the request into the
request queue in the SGA.
Put the above task in the order in which they
are performed.
A.
3, 1, 6, 2, 5, 4
B.
3, 6, 1, 5, 2, 4
C.
3, 1, 2, 3, 4, 5
D.
6, 1, 3, 5, 2, 4
E.
6, 3, 1, 2, 4, 5
F.
6, 3, 1, 2, 5, 4
Answer:
B
5.
A user is running a long update batch file. Many tables are
updated and all the statements are in one transaction. Before the
process is finished, the user machine lost power.
When the user calls you, what should you do as DBA?
A.
Do nothing, the PMON process handles everything.
B.
Shut down the database and restore all the tables the user was
updating.
C.
Log in as DBA, clean up the partial updates in those tables, and
do another manual
backup.
D.
Use LogMiner to find out which records are changed based on the
user’s ID, then roll
back
all those changes.
Answer:
A
|
