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.

Write a trigger example in oracle?

1065

---

How are extents allocated to a segment?

1125

---

What to do if the binary spfile is wrong for the default instance?

1069

---

What is a connect identifier?

1039

---

What is the use of oracle?

1030

---

In oracle there is column command, how will you explain that?

1057

---

interview questions with answer for cts

2583

---

What is Undo Management Advisor in Oracle?

1099

---

What is the usage of analyze command in oracle?

1093

---

How to call a stored function in oracle?

1018

---

Why is oracle used?

938

---

What is query image?

981

---

How to execute the package in oracle?

1083

---

Explain the use of full option in exp command.

1116

---

How to drop a stored function?

1137

---