Answer Posted / orawhiz

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to be
performed on dependent data as a result of any action on
referenced data.

What is hot backup and logical backup?

999

---

candidate key is subset of super key but not vice-verse explain

2015

---

How to convert dates to characters in oracle?

982

---

How to check database size in Oracle?

1115

---

Explain the blob datatype?

1013

---

How to pass a cursor variable to a procedure?

1040

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2144

---

How to drop a tablespace?

982

---

How to loop through a cursor variable?

1011

---

What do you understand by a database object? Can you list a few of them?

970

---

State and explain about oracle instance?

928

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

967

---

Can a formula column referred to columns in higher group ?

2455

---

What is execute immediate in oracle?

949

---

How to invoke the original export import utilities?

974

---