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.

Answer / j

Alter table table_name ENABLE constraint constraint_name;

Alter table table_name DISABLE constraint constraint_name;

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

Can you join a table to itself?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What is exception? What are the types of exceptions?

0 Answers  

---

What programs use sql?

0 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

Explain foreign key in sql?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---