[Q][031]Discuss Together

shyu1

无边落木:
You can go here, I also got from here.
http://www.chinaitlab.com/articlecatalog.asp?id=4

Now I have a plan to quit smoking first. No mood to study is a symptom of  quit smoking, so I will take  031 exam  after one month at least.

fdmiy

i think B is the correct answer,
one computer can contain only one oracle database software,
one computer can contain multiple oracle instances, each instance
can access corresponding one database or the same one database.
i do not remember the page of book,
but i have really setupped two instance on my computer, each instance
access one database.

fdmiy

QUESTION NO: 36
You have two undo tablespaces defined for your database. The instance is currently using
the undo tablespace named UNDOTBS_1. You issue this command to switch to UNDOTBS
2 while there are still transactions using UNDOTBS_1:
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_2
Which two results occur? (Choose two.)
A. New transactions are assigned to UNDOTBS_2.
B. Current transactions are switched to the UNDOTBS_2 tablespace.
C. The switch to UNDOTBS_2 fails and an error message is returned.
D. The UNDOTBS_1 undo tablespace enters into a PENDING OFFLINE mode (status).
E. The switch to UNDOTBS_2 does not take place until all transactions in UNDOTBS_1
are completed.
Answer: B, D

i think the correct answer is : A,D

jgworacle

I agree Answer of No. 36 is A, D.

fdmiy

QUESTION NO: 125
The server parameter file (SPFILE) provides which three advantages when managing
initialization parameters? (Choose three.)
A. The Oracle server maintains the server parameter file.
B. The server parameter file is created automatically when the instance is started.
C. Changes can be made in memory and/or in the SPFILE with the ALTER SYSTEM
command.
D. The use of SPFILE provides the ability to make changes persistent across shut down and
start up.
E. The Oracle server keeps the server parameter file and the text initialization parameter file
synchronized.
Answer: B, C, D

i think the correct answer is A,C,D

fdmiy

QUESTION NO: 127
Which two are true about the data dictionary views with prefix USER_? (Choose two.)
A. The column OWNER is implied to be the current user.
B. A user needs the SELECT ANY TABLE system privilege to query these views.
C. The definitions of these views are stored in the user's default tablespace.
D. These views return information about all objects to which the user has access.
E. Users can issue an INSERT statement on these views to change the value in the
underlying base tables.
F. A user who has the CREATE PUBLIC SYNONYM system privilege can create public
synonyms for these views.
Answer: C, F

i think C is not correct, but A is also doubtful, there is no OWNER column
in USER_? views.

fdmiy

QUESTION NO: 133
In which two situations does the Log Writer (LGWR) process write the redo entries from
the redo log buffer to the current online redo log group? (Choose two.)
A. When a transaction commits
B. When a rollback is executed
C. When the redo log buffer is about to become completely full (90%)
D. Before the DBWn writes modified blocks in the database buffer cache to the data files
E. When there is more than a third of a megabyte of changed records in the redo log buffer
Answer: A, E

i think the correct answer is A,D

fdmiy

Which three dynamic performance views obtain information from the control file? (Choose
three.)
A. V$LOG
B. V$SGA
C. V$THREAD
D. V$VERSION
E. V$DATAFILE
F. V$PARAMETER
Answer: A, C, F

i think the correct answer is A,C,E

fdmiy

QUESTION NO: 140
Your database is currently configured with the database character set to WEBIS08859P1
and national character set to AL16UTF16.
Business requirements dictate the need to expand language requirements beyond the
current character set, for Asian and additional Western European languages, in the form
of customer names and addresses.
Which solution saves space storing Asian characters and maintains consistent character
manipulation performance?
A. Use SQL CHAR data types and change the database character set to UTF8.
B. Use SQL NCHAR data types and change the national character set to UTF8.
C. Use SQL CHAR data types and change the database character set to AL32UTF8.
D. Use SQL NCHAR data types and keep the national character set to AL16UTF16.
Answer: C

i think the correct answer is B, not confirmed

无边落木

The answer for 125 is A,C,D.
The answer for 133 is A,D.
Others not sure.

PS: Shyu1 are you sure "All questions will be come from TK v2.0"?