How will you a activate/deactivate integrity constraints?

Answers were Sorted based on User's Feedback



How will you a activate/deactivate integrity constraints?..

Answer / muralidhar v

To Activate any integrity constraint, use Enable command
with Alter and to deactivate use disable with Alter.

To drop any constraint other than NOT NULL, use Drop
command with Alter. We can't drop not null, but we can
change it to NULL with Alter --Modify option.

Is This Answer Correct ?    5 Yes 1 No

How will you a activate/deactivate integrity constraints?..

Answer / j

Alter table table_name ENABLE constraint constraint_name;

Alter table table_name DISABLE constraint constraint_name;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a function in oracle pl sql?

0 Answers  


What does where 1 1 mean in sql?

0 Answers  


what is the difference between cluster and non cluster index? : Sql dba

0 Answers  


What are two parts of package ?

2 Answers   Infosys,


What is the difference between null value, zero, and blank space?

0 Answers  






what is dbms? : Sql dba

0 Answers  


how can i read files from a pl/sq l program

3 Answers  


How do you run a query?

0 Answers  


Can one improve the performance of sql*loader? : aql loader

0 Answers  


Is sql procedural language?

0 Answers  


Advantages and disadvantages of stored procedure?

0 Answers  


What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,


Categories