Answer / suman

what is indexing
An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-tree indexes.

What are the two types of cursors in pl sql?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 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,

---

How is a PL/SQL code compiled?

0 Answers  

---

What are tables and fields in the database?

0 Answers  

---

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

What is cartesian join in sql?

0 Answers  

---

What is pl sql in oracle?

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

What are schema-level triggers?

0 Answers  

---

What does plv msg allows you to do?

0 Answers  

---