Briefly describe what are guidelines for defining Constraints The SET

Briefly describe what are guidelines for defining

This preview shows page 3 - 5 out of 5 pages.

04) Briefly describe what are guidelines for defining Constraints?
Image of page 3
05) Briefly describe how you can use the exceptions table to find out invalid data? Create the EXCEPTIONS table by running the utlexcpt1.sql script • Execute the ALTER TABLE statement with EXCEPTION OPTION • Use subquery on EXCEPTIONS to locate rows with invalid data • Recitify the errors • Re-execute ALTER TABLE to enable the constraint. 06) Briefly describe what is Profile? A profile is a named set of the following password and resource limits
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Summer '19

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes