Answer Posted / gyana ranjan behera

Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.

How to connect to oracle using service name instead of sid?

1025

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

---

How to retrieve data from an cursor to a record?

1103

---

Calculate difference between 2 date / times in oracle sql?

1040

---

How do we represent comments in oracle?

1048

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2354

---

Is oracle a programming language?

986

---

How to convert characters to dates in oracle?

1100

---

What are the predefined tablespaces in a database?

1081

---

What is a dynamic performance view in oracle?

991

---

How do I start tns listener?

1044

---

Explain parameter file in oracle.

1029

---

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

988

---

6. Display the client name and order date for all orders using the traditional method.

2306

---