How to start a new transaction in oracle?

0 Answers  

---

How to load data through external tables?

0 Answers  

---

Differentiate between function and procedure in oracle.

0 Answers  

---

What are the attributes that are found in a cursor?

0 Answers  

---

How do we display rows from the table without duplicates?

0 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

How to convert dates to characters in oracle?

0 Answers  

---

What is data block in Oracle?

0 Answers   MCN Solutions,

---

What is a relational database management system?

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

How to establish administrator authentication to the server?

0 Answers  

---