READ Free Dumps For Oracle- 1z0-026
| Question ID 21385 | A site is having intermittent problems with users loosing connections to an Oracle instance, running on a UNIX
server. Each user runs the client application on his or her Windows NT client. The preliminary diagnosis is done
with no success. The DBA then decides to enable Net8 tracing and sets the tracing level to Admin on one of the
client nodes experiencing the problem. Which statement best describes the result of the DBA's action?
|
| Option A | Trace information for all users is enabled.
|
| Option B | Trace information for only active users is enabled.
|
| Option C | Trace information applicable for database administrator is enabled.
|
| Option D | Trace information for all users listed in the Net8 configuration file if enabled.
|
| Correct Answer | C |
Explanation Explanation: Answer C is correct. By setting the tracing level to Admin on the client node trace information applicable for database administrator will be enabled. Incorrect Answers: A is incorrect; trace information for all users is not enabled with usage of tracing level Admin. B is incorrect; trace information not only for active users will be enabled. D is incorrect; trace information for database administrator will be enabled, not for all users listed in the Net8 configuration file.
| Question ID 21386 | Which two statements are true regarding initial shared server processes? (Choose two)
|
| Option A | If initial shared server process is idle, they get de-allocated.
|
| Option B | It is best to estimate more initial server processes than fewer.
|
| Option C | You can change the minimum number of shared server processes dynamically.
|
| Option D | Initial server processes all get allocated when starting up the instance and database.
|
| Correct Answer | A,C |
Explanation Explanation: Answers A and C are correct. Idled initial shared servers can be de-allocated and it is possible to change the minimum number of shared server processes dynamically by editing MTS_SERVERS parameter. Incorrect Answers: B is incorrect; it is wise to specify a smaller number of shared-server processes. This is because Oracle will automatically start more shared servers during periods of high load volume, up to a maximum number of shared servers set by the initsid.ora parameter MTS_MAX_SERVERS. D is incorrect; not all initial server processes will be allocated when starting up the instance and database: some of them will be idle.