Answer Posted / mapuka mueller

A unique key in sql signifies an attribute of an entity in a
table with the unique constraint, which simply implies that,
that a record(value) of that attribute can not be entered
more than once in that column (except null).
A further assignment of the primary key constraint to that
attribute (or a composite of two or more attributes(columns)
from values on the same row) makes it the unique identifier
of the record(row) in that table.

"It's sometimes hard to express what's in your mind but i
hope i tried"

What happens to the current transaction if the session is killed?

988

---

What is oracle rowcount?

1084

---

What is oracle host variable?

1061

---

How do I recompile a procedure in oracle?

964

---

How to use null as conditions in oracle?

1084

---

How to do paging with oracle?

999

---

How to invoke the original export import utilities?

1064

---

State the difference between a primary key and foreign key?

935

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2311

---

How to get maxsal , minsal, ename department wise in single query

1549

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2008

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1971

---

What are the ansi data types supported in oracle?

947

---

Explain the use of indexes option in exp command.

1149

---

How to define a data source name (dsn) in odbc manager?

1032

---