Answer Posted / kishore singh bisht

primary key is a uniquely identified key,in primary key we use only a single attribute to identify a row.......
example:- roll no. of an student, employee id etc.
primary key=unique+not null.
and super key is a combination of two or more attributes which make the uniqueness.......
ex:-name+d.o.b+contact no...
these three attributes make the uniqueness by which we can easily identify.............

What is the purpose of save points in oracle database?

1198

---

What is the usage of save points in oracle database?

1011

---

 What are the oracle DML commands possible through an update strategy?

1101

---

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

1091

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1890

---

What is the implicit cursor in oracle?

1168

---

What is MTTR advisor in Oracle?

1135

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2544

---

Describe varray?

1116

---

What operating systems are supported by oracle database 10g xe?

1083

---

What is oracle host variable?

1129

---

List out the difference between commit, rollback, and savepoint?

1088

---

Differentiate between translate and replace?

1186

---

What is a data lock in oracle?

1178

---

How to create a temporary table in oracle?

1329

---