What is the use of non clustered index?

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

What do you mean by query optimization?

0 Answers  

---

Is time a data type in sql?

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

What is an oracle stored procedure?

0 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

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,

---

Can a primary key be a foreign key?

0 Answers  

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---