Answer Posted / banoj swain

cursor is nothing but a pointer pointing to the context area assigned by oracle for processing of sql statement.pl/sql programs control context area by using cursor.
types:1)static 2)dynamic or ref cursor
again static is of two types
1)explicit 2)implicit
dynamic of two types:
1)strong 2)weak

How can you log an error to the server event log from a stored procedure?

794

---

Explain about the hierarchical model of the database?

787

---

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

1877

---

Explain what a database is?

799

---

Where is dbms used?

820

---

What is dbms explain in brief?

765

---

What is database design and development?

789

---

Write the fastest query to find out how many rows exist in a table?

881

---

Explain the process of the user request and data generating?

863

---

Which four data types cannot be used as a return type from a user-defined function?

794

---

fact table and dimension table containg one to many relationship or many to one relastionship

2264

---

Can an extended stored procedure be called from inside a user-defined function?

822

---

Explain about the storage and physical database design?

701

---

Write short notes on manual refreshes.

2487

---

Explain about relational database management systems?

737

---