You can use the passwordreusemax clause with a create

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: OFILE 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 122: To select only objects that belong to a specific schema from DBA_OBJECTS, specify a value for the column ___ in the predicate. A. USER B. OWNER C. SCHEMA D. CREATOR Answer: B 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. Or...
View Full Document

Ask a homework question - tutors are online