Answer / nishi

NO_DATA_FOUND is pre defind exception of oracle. when we can't get any data from the table for any query. In that case we will get error.

%NOT FOUND is one of the attribute of explicit cursor. when can't get any data from explicit cursor in that case

%NOT FOUND will returns true otherwise it returns false.

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

0 Answers  

---

What is a heap related to database ?

1 Answers   TCS, University of Edinburgh,

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers   Oracle,

---

How data locks are respected in oracle?

0 Answers  

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---

8. Display the client name and order date for all orders using the natural join keywords.

1 Answers   Wipro,

---

What privilege is needed for a user to create indexes in oracle?

0 Answers  

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

---

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,

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What are triggers in oracle?

0 Answers  

---

What do you mean by redo log file mirroring?

0 Answers  

---