Answer / slokh

Bitmap index is a type of index created on the basis of the
column having low cardinality like. index created on the
column like 'gender' etc.


B-tree or binary index is created on the column contains
wide range of values like 'name' column.

note:- more than one index is created on the table.

Answer / brajesh kr.

Bitmap:- index is special kind of index that uses bitmap .
it significant space and performance advantage over
structure for such data. it is also useful for unique value
data. it use bit arrays and answer queries by performing
bitmap logical operations on these bitmap.

B-Tree:-databse server uses a b-tree strucruyre to organize
index information shows that afully developed b-treee index
is composed of that following
1.Oneroot nodes
2. Two or more branch nodes.

Why use truncate instead of delete?

0 Answers  

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

Can %notfound return null after a fetch?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

How do I run sql profiler?

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

What is a Procedure ?

3 Answers  

---

Which constraints we can use while creating database in sql?

0 Answers  

---

what are null values? : Sql dba

0 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

how to convert character strings to numeric values? : Sql dba

0 Answers  

---