Answer Posted / ramesh

Oracle is a such database management system where we can
have full security and flexibility. In oracle we cant do
even a single event with out the permission of DBA

Explain the use of rows option in imp command.

1085

---

What is a database table in oracle?

1021

---

What is a subquery?

1120

---

How to assign values to variables?

1101

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2291

---

Explain integrity constraints?

1102

---

How to write a query with a right outer join in oracle?

1168

---

How to define a data field as not null?

1107

---

What operating systems are supported by oracle database 10g xe?

1034

---

Explain the difference between a procedure and a function?

1169

---

How to open and close an explicit cursor in oracle?

1058

---

how to handle exceptions in post production

1424

---

What is a trace file and how is it created in oracle?

1057

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

---

How oracle handles dead locks?

1065

---