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?
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
You've reached the end of your free preview.
Want to read all 4 pages?
Constraints,Foreign key,data integrity,ALTER USER command,Immediate Constraints