1z0-235 Other Oracle Certification Oracle 11i Braindump
ExamSoon 1z0-235 Exams
Oracle Oracle 11i applications DBA:Fundamentals I
O rder : 1z0-235 Exam
Practice Exam: 1z0-235
Exam Number/Code: 1z0-235
Exam Name: Oracle 11i applications DBA:Fundamentals I
Questions and Answers: 136 Q&As
Free 1z0-235 Braindumps
Exam : Oracle 1Z0-235
Title : Aix 5l Problem Detemination
1. Which two statements are true regarding the temporary tablespace? (Choose two.)
A. Used for sort operations
B. Can contain permanent objects
C. Cannot be shared by multiple users
D. Cannot be created with nonstandard block size specification
Answer: AD
2. Which three functions are provided by undo segments? (Choose three.)
A. to avoid dead locks
B. to maintain read consistency
C. to roll back an erroneous transaction
D. to record the old values of a transaction
E. to record both old and new values of a transaction
Answer: BCD
3. View the Exhibit.
Examine the value set for the NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file. You are working in a
TCP/IP network environment. What will happen when you try to connect to the database from a remote client?
A. The local naming method will be used first to resolve a connect identifier.
B. It will result in an error because two values cannot be specified for the NAMES.DIRECTORY_PATH parameter.
C. If the local naming method is unable to resolve the connect identifier, then Oracle Names server will be used to
resolve the connect identifier.
D. If the host naming method is unable to resolve the connect identifier, then the net service name stored in a
centralized LDAP-compliant directory server is used to resolve the connect identifier.
Answer: A
4. dropping the rollback segments and create undo segments in the same tablespace that has the rollback segments
Which option would you use?
A. 3 only
B. 1 and 2 only
C. 2 and 3 only
D. 3 and 5 only
E. 2 and 5 only
Answer: B
5. You executed the following command to create an index on CUSTOMER_ID and ITEMS_ID columns in the
ORDERS table:
SQL>