What two data dictionary tables should you query

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: you query? (Choose two) A. ALL_CONSTRAINTS B. DBA_CONSTRAINTS C. USER_CONSTRAINTS D. ALL_CONS_COLUMNS E. DBA_CONS_COLUMNS F. USER_CONS_COLUMNS Answer: B, E 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: Managi...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online