Unformatted text preview: you query? (Choose two)
Answer: B, E
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
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
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 439-440
Chapter 9: Managi...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09