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 can we make an if statement within a select statement?

1 Answers  

---

How many types of normalization are there?

1 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

What are tables and fields?

1 Answers  

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1 Answers  

---

What are the components of a PL/SQL block ?

3 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1 Answers  

---

What is the primary use of normalization?

1 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

Is and as keyword in pl sql?

1 Answers  

---

Explain the rollback statement?

1 Answers  

---