READ Free Dumps For Oracle- 1z0-023
| Question ID 8797 | Which three resources can be controlled using profiles? (Choose three)
|
| Option A | Idle time.
|
| Option B | CPU time.
|
| Option C | Database links usage.
|
| Option D | PGA memory allocations.
|
| Option E | Number of concurrent sessions for a user name.
|
| Correct Answer | ABE |
Explanation Explanation/Reference: Explanation: Answers A, B and E are correct. Profiles control idle time, CPU time and number of concurrent sessions for a user name. Incorrect Answers: C: Profile does not handle database links usage. D: It cannot control PGA memory allocations. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 471-480 Chapter 10: Managing Database Use
| Question ID 8798 | You want to retrieve information about account expiration dates from the data dictionary. Which view do you use?
|
| Option A | DBA_USERS
|
| Option B | DBA_PROFILES
|
| Option C | DBA_EXP_DATES
|
| Option D | V$ACC_EXPIRATION
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. Account expiration dates are accessible from DBA_USERS data dictionary view. Incorrect Answers: B: DBA_PROFILES view contains information about profiles themselves, not about account expiration dates. C: There is no DBA_EXP_DATES view in Oracle. D: There is no V$ACC_EXPIRATION view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 476-479 Chapter 10: Managing Database Use