Answer Posted / anamika niit

Primary key and unique are Entity integrity constraints

Primary key allows each row in a table to be uniquely
identified and ensures that no duplicate rows exist and no
null values are entered.

Unique key constraint is used to prevent the duplication of
key values within the rows of a table and allow null
values. (In oracle, one null is not equal to another null).

How to unlock the sample user account in oracle?

916

---

What is coalesce function?

1003

---

What is the best way to do multi-row insert in oracle?

1012

---

What are the various oracle database objects?

1091

---

types of indexes and the rationale behind choosing a particular index for a situation.

2443

---

What is materialized view in Oracle?

1042

---

Can we call procedure inside function in oracle?

1018

---

How to use subqueries with the exists operator in oracle?

968

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2413

---

How to list all user accounts in oracle?

979

---

How to create a stored procedure in oracle?

1027

---

How to start an oracle instance?

951

---

What is concurrency in oracle?

946

---

How to use null as conditions in oracle?

1001

---

How to work with data objects interactively?

924

---