Answer Posted / sandeep desai

B-Tree:-Is made of Branch nodes and Leaf nodes
where
Branch nodes hold the prefix key value and also the link to
Leaf node
whereas,
Leafe node is contains Indexed value and ROWID.

Bitmap:-It consists of the bits for every distinct value

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1983

---

How to declare a local variable?

1109

---

What is recovery manager in Oracle?

1050

---

How do I manually create a database in oracle?

1016

---

does the query needs a hint to access a materialized view?

1857

---

How can windows applications connect to oracle servers?

1050

---

What is backup in Oracle?

998

---

What is a nvl function? How can it be used?

1019

---

What is bind variable in oracle 11g?

1037

---

What is the difference between count (*), count (expression), count (distinct expression)?

1002

---

How many types of synonyms in Oracle?

1115

---

How to define a variable to match a table column data type?

982

---

What is the difference between a hot backup and a cold backup in oracle?

1013

---

What is the data pump import utility?

1030

---

What is the maximum number of triggers that can be applied to a single table?

1019

---