1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How will you a activate/deactivate integrity constraints?

Question Posted / guest

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 crud stand for?

0 Answers  

What is a transaction?

5 Answers  

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

what is global table

7 Answers   iFlex,

Explain what is a view?

0 Answers  




What is a procedure in pl sql?

0 Answers  

which types of join is used in sql widely? : Sql dba

0 Answers  

How to install oracle sql developer?

0 Answers  

How can we optimize a sql query?

0 Answers  

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

0 Answers  

What is PL/SQL table ?

6 Answers  

What is the difference between microsoft access and sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories