Answer Posted / avik ganguly

select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)

How to use timestamp datatypes

2075

---

What are the main phases of database development?

1027

---

What is an application role and explain a scenario when you would use one?

1056

---

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

1063

---

Explain about query and reporting.

2133

---

What are the three basic rules which are to be followed for the relational model of the database?

1067

---

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

1170

---

Why does this query return 0?

1054

---

How to generate OIDS

2330

---

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

2182

---

What is the maximum length of an extended property?

1034

---

Explain about xml databases?

1113

---

Explain about relational database management systems?

1012

---

How is data stored in dbms?

1008

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1050

---