« Technical Interview & Viva Questions : KyaPoocha.com home page
« What is a database link?
What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint? »



How will you activate/deactivate integrity constraints?


The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.



Explore posts in the same categories: Oracle Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • Why are the integrity constraints preferred to database triggers?
    • Because it is easier to define an integrity constraint than a database trigger....
  • Give two examples of referential integrity constraints?
    • A primary key and a foreign key. ...
  • What are triggers? How to invoke a trigger on demand?
    • Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place...
  • Advantages of DBMS??Redundancy is controlled.
    • Unauthorised access is restricted. Providing multiple user interfaces. Enforcing integrity constraints. Providing backup and recovery....
  • Define the “integrity rules” .
    • There are two Integrity rules. Ø Entity Integrity: States that “Primary key cannot have NULL value” Ø Referential Integrity: States that “Foreign...
  • What is the use of CONSTRAINTS option in EXP command ?
    • A flag to indicate whether constraints on table need to be exported....
  • What is the difference between Truncate and Delete interms of Referential Integrity?
    • DELETE removes one or more records in a table, checking referential Constraints (to see if there are dependent child records) and...
  • What is Authorization and Integrity manager?
    • It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to...
  • What is Authorization and Integrity manager?
    • It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to...
  • Describe referential integrity ?
    • Referential integrity refers to a feature in DB2 that is used to ensure consistency of the data in the database....

    Comments are closed.