Answer Posted / daid kumar

bitmap Index is Used mainly in decision support systems
because it returns value in bit like 0 and 1.

Example
CREATE BITMAP JOIN INDEX <index_name>
ON <table_name> (<table_name.column_name>)
FROM <table_name, table_name>
WHERE <join_condition>

When do we use group by clause in a sql query?

1000

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4303

---

What are the parameters that we can pass through a stored procedure?

1007

---

What is an oracle cursor variable?

1021

---

What is primefaces used for?

1015

---

Can multiple columns be used in group by in oracle?

937

---

How to get execution path reports on query statements?

936

---

Can group functions be used in the order by clause in oracle?

947

---

How can we find out the current date and time in oracle?

1043

---

What are the original export and import utilities?

1072

---

What happens to the current transaction if a ddl statement is executed?

958

---

Which is better Oracle or MS SQL? Why?

4843

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2861

---

Explain the use of control file?

1068

---

What is a table in oracle?

935

---