READ Free Dumps For Oracle- 1z0-023
| Question ID 8845 | You want to obtain information about all constraints on tables in the PROD user's schema, including their status and what columns they invoke. You have access to all data dictionary views, but you do not know the password for the PROD user. What two data dictionary tables should you query? (Choose two)
|
| Option A | ALL_CONSTRAINTS
|
| Option B | DBA_CONSTRAINTS
|
| Option C | USER_CONSTRAINTS
|
| Option D | ALL_CONS_COLUMNS
|
| Option E | DBA_CONS_COLUMNS
|
| Option F | USER_CONS_COLUMNS
|
| Correct Answer | BE |
Explanation Explanation/Reference: Explanation: Answers B and E are correct. DBA_CONSTRAINTS view lists detailed information about all constraints in the system. DBA_CONS_COLUMNS view is used to display detailed information about every column associated with a constraint Incorrect Answers: A: Using ALL_CONSTRAINTS you can see only constraints for objects accessible by current user. So if you don't know PROD user password you will not be able to see constraints on tables in its schema. C: USER_CONSTRAINTS shows information only about constraints on tables from current user schema, not PROD user schema. D: ALL_CONS_COLUMNS will show information about columns in constraints for objects accessible by current user, not all constraints. E: USER_CONS_COLUMNS will show information about columns in constraints for user objects only. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 439-440 Chapter 9: Managing Database Objects II
| Question ID 8846 | You want to retrieve information about password expiration from the data dictionary. Which view do you use?
|
| Option A | DBA_USERS
|
| Option B | DBA_ROLES
|
| Option C | DBA_PASSWORDS
|
| Option D | V$PW_EXPIRATION
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. DBA_USERS view shows all information about users. It contains username, Oraclegenerated ID number, encrypted password, default and temporary tablespace information, and the user profile that specified in the ID creation statements or any alteration that may be followed. GRACE_DATE column identifies the date by which the user must change the password or the account will be locked. Incorrect Answers: B: DBA_ROLES view is used to show information about roles, not about password expiration. C: There is no DBA_PASSWORDS view in Oracle. D: There is no V$PW_EXPIRATION view in Oracle Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 470-471 Chapter 10: Managing Database Use