Answer Posted / avinash

primary key:
primary key could be any key which is able to identify
a specific row in data base in a unique manner.
super key;
different set of attributes which are able to identify
any row in the database is known as super key.

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

1866

---

What is a nested table and how is it different from a normal table?

1052

---

How to add a new column to an existing table with a default value?

1016

---

IS it possible to built the oracle database without setting the kernal parameters?

2348

---

How to update a table row with a record?

1010

---

How to get a create statement for an existing table?

969

---

What is the difference between "as" and "is" in an oracle stored procedure?

993

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2256

---

How to create an oracle testing table?

1069

---

Explain the difference between a procedure and a function?

1172

---

What privilege is needed for a user to create indexes in oracle?

1028

---

What is a partition in oracle?

1122

---

Explain the use of consistent option in exp command.

1068

---

How to retrieve data from an cursor to a record?

1104

---

How to get execution statistics reports on query statements?

1094

---