Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  


Define a temp table?

0 Answers  


Explain the uses of database trigger.

0 Answers  


Can ddl statements be used in pl/sql?

0 Answers  


What are different types of keys?

0 Answers  


Explain mutating table error.

0 Answers  


What is the purpose of primary key?

0 Answers  


Can there be more than one function with a similar name in a pl/sql block?

0 Answers  


How to revise and re-run the last sql command?

0 Answers  


I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,


Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,


How is pl sql different from sql?

0 Answers  


Categories