OCA OCP Oracle Certification Exam Braindumps

Killtest offers free demo for 1Z0-235 Exam. You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only onesite can offer demo for almost all products.

1. You receive the following error while connecting to an Oracle9i database instance: ORA-12523
TNS:listener could not find instance appropriate for the client connection Which action would be
appropriate in the context of investigating the cause of error? 
A. checking the listener.ora file to verify that the protocol specified in ADDRESS is supported by the
database server 
B. checking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH =
(TNSNAMES,HOSTNAME)parameter is set 
C. executing the lsnrctl services command to verify that the instances are registered with the listener, and
have the READY status. 
D. checking the tnsnames.ora file to verify that the net service name specified in your connect string is
mapped to a connect descriptor 
Answer: C 
2. You are using rollback segments in your database. To ease transaction management, you want to
implement automatic undo management by using the following steps: 
1.  creating an undo tablespace 
2.  setting the UNDO_MANAGEMENT parameter to AUTO in the parameter file 
3.  changing the tablespace that has the rollback segments to an undo tablespace by using the
ALTER TABLESPACE command 
4.  setting the UNDO_TABLESPACE parameter to the tablespace that has the rollback segments 
5.  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