READ Free Dumps For Oracle- 1z0-023
| Question ID 8876 | Which clause can be used with a CREATE PROFILE command?
|
| Option A | PASSWORD_REUSE_MAX
|
| Option B | PASSWORD_NEVER_EXPIRE
|
| Option C | PASSWORD_LOCK_ACCOUNT
|
| Option D | PASSWORD_ALWAYS_PROTECT
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. You can use the PASSWORD_REUSE_MAX clause with a CREATE PROFILE command. Other possible clauses: FAILED_LOGIN_ATTEMPTS, PASSWORD_LIFE_TIME, PASSWORD_REUSE_TIME, PASSWORD_LOCK_TIME, PASSWORD_GRACE_TIME, PASSWORD_VERIFY_FUNCTION. Incorrect Answers: B: There is no PASSWORD_NEVER_EXPIRE clause in a CREATE PROFILE command. C: There is no PASSWORD_LOCK_ACCOUNT clause in a CREATE PROFILE command. D: There is no PASSWORD_ALWAYS_PROTECT in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 479-480 Chapter 10: Managing Database Use
| Question ID 8877 | To select only objects that belong to a specific schema from DBA_OBJECTS, specify a value for the column ___ in the predicate.
|
| Option A | USER
|
| Option B | OWNER
|
| Option C | SCHEMA
|
| Option D | CREATOR
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. To select only objects that belong to a specific schema, specify a value for the column OWNER in the predicate. Incorrect Answers: A: There is no USER column in the DBA_OBJECTS table. C: There is no SCHEMA column in the DBA_OBJECTS table. D: There is no CREATOR column in the DBA_OBJECTS table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 401 Chapter 8: Managing Database Objects I