Answer / sandeep desai

No.
Eg:-
Consider Table emp
Assume there are only 5 records in emp
and in emp_sal column values are (1200,1400,4500,2000).
Now if I try to create a check constraint on emp_sal column
for the range between 2000 and 4000 then an error is thrown
since values below this range also exist in emp_sal column.

Answer / orawhiz

No.

Describe Referential Integrity ?

1 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 Answers  

---

What is query image?

0 Answers  

---

Explain view?

0 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers   HCL,

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

What is Trace File ?

4 Answers   Thermotech,

---

Can you use a commit statement within a database trigger?

4 Answers  

---

What is an index associated with a constraint?

0 Answers  

---

What are privileges and grants?

0 Answers  

---