Answer Posted / suresh kumar

Hi, i give the definitions with easy understand exapmles

A primary key is used to uniquely identify each row in a
table. It can either be part of the actual record itself,
or it can be an artificial field (one that has nothing to
do with the actual record).
A primary key can consist of one or more fields on a table.
When multiple fields are used as a primary key, they are
called a composite key.

EX:If we take EMP table, Empno is the primary key and in
DEPT table, Deptno is the primary keys

A foreign key is a field (or fields) that points to the
primary key of another table.
The purpose of the foreign key is to ensure referential
integrity of the data.
In other words, only values that are supposed to appear in
the database are permitted

EX:In EMP table Deptno field is the foreign key because it
pointing to the Deptno in DEPT table

A Reference key is a field (or fields) that points to the
primary key of the same table

EX:In EMP table Mgr field is the Reference key because it
pointing to the Empno field in the same table

What are a cluster and non-cluster index?

1064

---

What is not equal to in oracle?

1047

---

What are the uses of linked server and explain it in detail?

1117

---

How a tablespace is related to data files?

1162

---

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

1136

---

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

1918

---

What is SQL access advisor in Oracle?

1228

---

Describe varray?

1116

---

How does oracle handle read consistency?

1151

---

how the indexes are stored in the Oracle Database?

2331

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2063

---

What is literal?

1062

---

How to commit the current transaction in oracle?

1178

---

What is difference between truncate and delete?

1093

---

What is recycle bin in Oracle?

1191

---