Which join is like inner join?

0 Answers  

---

Write a query to find second highest salary of an employee.

27 Answers  

---

What is Raise_application_error ?

1 Answers  

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

What are the basic techniques of indexing?

0 Answers  

---

What are schema-level triggers?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

What is the basic structure of an sql?

0 Answers  

---

What are sql constraints?

0 Answers  

---

What is set serveroutput on?

0 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---