You can use this statement to set the mode for a list of constraint names or

You can use this statement to set the mode for a list

This preview shows page 4 - 7 out of 8 pages.

You can use this statement to set the mode for a list of constraint names or for constraints. The SET CONSTRAINTS mode lasts for the duration of the transaction or UNTIL ANOTHER SET CONSTRAINTS statement resets the mode. The SET CONSTRAINTS statement is disallowed inside triggers. The ALTER SESSION statement also has clauses to SET CONSTRAINTS to IMMEDIATE or DEFERRED. These clause imply setting ALL deferrable constraints (list of constraint names cannot be specified). The ALTER SESSION SET CONSTRAINTS statement applies to a current session only. ALTER SESSION
Image of page 4
SET CONSTRAINT[S] .. {IMMEDIATE|DEFERRED|DEFAULT} SET CONSTRAINT | CONSTRAINTS {constraint |ALL} {IMMEDIATE|DEFERRED} ANSWER 5: Create the EXCEPTIONS table by running the utlexcpt1.sql script. Execute the ALTER TABLE statement with EXCEPTIONS option. Use sub-query on EXCEPTIONS to locate rows with invalid data. Rectify the errors. Re-execute ALTER TABLE to enable the constraint. ANSWER 6: A profile is a named set of the password and resource limits. Profiles are assigned to users by the CREATE USER or ALTER USER command. Can be enabled or disabled. Can relate to the DEFAULT profile. A profile is a named set of the following password and resource limits Password aging and expiration Password history Password complexity verificaiton Account locking CPU time I/O operations Idle time Connect time Memory space(private SQL area for MTS only) Concurrent sessions After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the database server limits the database usage and resources to the defined profile of the user. The database server automatically creates a DEFAULT profile when the database is created.
Image of page 5
The users who have not been explicitly assigned a specific profile conform to all the limits of the DEFAULT profile. All limits of the DEFAULT profile are initially unlimited. The database administrator can change the values so that limits are applied to all users by default. Profile Usage Restrict users from performing some operations that require heavy use of resources Ensure that users log off the database when they have left their session idle for some time Enable group resource limits for similar users Easily assign resource limits for users Manage resource usage in large,,complex multiuser database systems
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 8 pages?

  • Spring '18
  • Constraints, administrator, Database management system, Constraint

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture