Exam : Oracle 1Z0-235
Title : Aix 5l Problem Detemination


1. 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

2. You want to reuse all the existing data files, control files, and redo log files to re-create your test database. You execute the following command to create the database:
CREATE DATABASE testdb
DATAFILE
'/u01/oradata/testdb/system01.dbf'
SIZE 100M REUSE
LOGFILE
GROUP 1 ('/u01/oradata/testdb/log1a.rdo',
'/u02/oradata/testdb/log1b.rdo')
SIZE 50K REUSE,
GROUP 2 ('/u01/oradata/testdb/log2a.rdo',
'/u02/oradata/testdb/log2b.rdo')
SIZE 50K REUSE
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10;
The command fails to create the database successfully. What could be the reason?
A. You have set MAXLOGFILES to a very low value.
B. You cannot reuse the online redo log files.
C. You have omitted the CONTROLFILE REUSE clause.
D. You cannot reuse the data file belonging to the SYSTEM tablespace.
Answer: C

3. 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

4. Which three statements are correct regarding the listener process? (Choose three.)
A. A listener can be configured to listen for multiple protocols.
B. Multiple listeners cannot listen on behalf of a single database.
C. The name of the listener should be unique per listener.ora file.
D. A listener can listen for a single database only and not multiple databases.
E. The listener transfers the connection request to a dispatcher in a Shared Server configuration.
F. The listener transfers the connection request to the Connection Manager in a Dedicated Server configuration.
Answer: ACE

5. 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

6. 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

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

8. 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