Answer Posted / priya

Constraints define the conditions or predictions under
which data is valid.
column level constraints are applicable to single column
only like if we want to make Unique constraint on column
level then as shoen below:-
<column Name><data type>Unique
At table level
Unique(<coulmn>,<column>);
Table level constraints means when constraints apply on
more than single column.

How to view the data files in the current database?

1042

---

How to pass a cursor variable to a procedure?

1040

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2086

---

How to turn on or off recycle bin for the session?

1036

---

what is meant by magic query

2136

---

How can we find out the duplicate values in an oracle table?

993

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2259

---

What is the difference between a hot backup and a cold backup in oracle?

957

---

State the various uses of dbcc command?

989

---

What are the logical operations?

1064

---

How to resolve name conflicts between variables and columns?

978

---

How to manage transaction isolation level?

949

---

Explain what are the type of synonyms?

1054

---

Explain about functional dependency and its relation with table design?

952

---

What are the parameters that we can pass through a stored procedure?

997

---