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.

what is a Nested Loop join?

2117

---

Explain oracle’s server parameter file.

995

---

How to synchronize 2 schema's objects?

2181

---

How will you write a query to get a 5th rank student from a table student_report?

1866

---

Explain the use of record length option in exp command.

1067

---

How to convert times to characters in oracle?

1027

---

What is bulk copy or bcp in oracle?

1124

---

Explain the use of indexes option in imp command.

1179

---

Explain what are clusters?

1108

---

What is set operator oracle?

980

---

Explain enable novalidate constraint.

1083

---

Differentiate between translate and replace?

1122

---

What is the max number of columns in an oracle table?

1001

---

How to manage transaction isolation level?

1006

---

how may join possible between (requisition with purchase order)

2252

---