READ Free Dumps For Oracle- 1z0-023
| Question ID 8849 | Which clause CANNOT be used with a CREATE PROFILE command?
|
| Option A | ACCOUNT_LOCK_TIME
|
| Option B | PASSWORD_LIFE_TIME
|
| Option C | PASSWORD_CHANGE_NEW
|
| Option D | FAILED_LOGIN_ATTEMPTS
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. It is not possible to use ACCOUNT_LOCK_TIME with a CREATE PROFILE command. Incorrect Answers: A: You can set PASSWORD_LIFE_TIME during creation profile. This parameter shows number of days a password will remain active. Default is 60. C: PASSWORD_CHANGE_NEW can be used with CREATE PROFILE command. D: FAILED_LOGIN_ATTEMPTS is number of unsuccessful attempts at login a user can make before account locks. Default is 3. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 479-480 Chapter 7: Managing the Physical Database Structure
| Question ID 8850 | What are two components of an Oracle database? (Choose two)
|
| Option A | The SGA
|
| Option B | The control files
|
| Option C | The shared pools
|
| Option D | The redo log files
|
| Option E | The SMON process
|
| Correct Answer | BD |
Explanation Explanation/Reference: Explanation: Answers B and D are correct. The control files and the redo log files are components of an Oracle database. All others are Oracle instance structures. Incorrect Answers: A: The SGA is System Global area, it's memory component of Oracle instance. C: The SHARED POOL is part of SG A. System Global area also contains dictionary or row cache and library cache. E: The SMON process is Oracle instance process, not a component of an Oracle database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 257-261 Chapter 6: Basics of the Oracle Database Architecture