Answer Posted / vijay

u can create more than one constraint on on column

Vijay Kushwaha

What are the four Oracle system processes that must always be up and running for the database to be useable?

1024

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2193

---

Is oracle a language?

954

---

Explain integrity constraint?

1167

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1992

---

Does oracle partitioning improve performance?

1006

---

Which is better Oracle or MS SQL? Why?

4960

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2275

---

Why does for update in oracle 8 cause an ora-01002 error?

1012

---

How do you bind variables in oracle?

990

---

How do we display rows from the table without duplicates?

980

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2101

---

Please explain oracle data types with examples?

1079

---

What are the uses of linked server and explain it in detail?

1068

---

How to divide query output into groups in oracle?

998

---