READ Free Dumps For Oracle- 1z0-023
| Question ID 8873 | From the data dictionary you know that user A has profile TEST_PROF assigned, and the IDLE_TIME resource shows default as its value. What does this mean?
|
| Option A | The actual limit depends on the setting in the profile called DEFAULT.
|
| Option B | User A can stay connected to the database without ever being automatically disconnected.
|
| Option C | The limit can be influenced only at the instance level by setting an initialization parameter.
|
| Option D | A database administrator using the ALTER SYSTEM command can set the limit
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. The IDLE_TIME resource will be defined by the settings in the DEFAULT profile. Incorrect Answers: B: User A will be disconnected when the idle time of user connection will exceed IDLE_TIME parameter. C: The limit can be influenced not only at the instance level. D: You cannot set this limit by using the ALTER SYSTEM command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 480-484 Chapter 10: Managing Database Use
| Question ID 8875 | Which system parameter must be set to TRUE in orderfor Oracle to enforce the resource usage defined in the profile?
|
| Option A | RESOURCE_LIMIT
|
| Option B | RESOURCE_PLAN
|
| Option C | RESOURCE_PROFILE
|
| Option D | RESOURCE_UTILIZATION
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. RESOURCE_LIMIT system parameter must be set to TRUE in order for Oracle to enforce the resource usage defined in the profile. Incorrect Answers: B: There is no RESOURCE_PLAN system parameter in Oracle. C: There is no RESOURCE_PROFILE system parameter in Oracle. D: There is no RESOURCE_UTILIZATION system parameter in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 480-484 Chapter 10: Managing Database Use