Briefly describe what is constraint checking You can defer checking constraints

Briefly describe what is constraint checking you can

This preview shows page 2 - 4 out of 4 pages.

03) Briefly describe what is constraint checking?You can defer checking constraints for validity until the end of transaction. 04) Briefly describe what are guidelines for defining constraints?
Image of page 2
05)Briefly describe how you can use the exceptions table to find out invalid data?Use subquery on EXCEPTIONS to locate rows with invalid data. Identify invalid data by using a subquery on the EXCEPTIONS table:SELECT rowed, id, last_name, dept_id FROM hr employee WHERE ROWID in (SELECT row_id exceptions) FOR UPDATE;06)Briefly describe what is Profile?A profile is a named set of the following password and resource limits. FROM
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Summer '19
  • Constraints, Foreign key, data integrity, ALTER USER command, Immediate Constraints

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture