Answer Posted / mithilesh mishra

Select Max(sal) from emp where sal not in (select max(sal)
from emp)

explain detail about ftp in datastage?

2235

---

What is a database development?

954

---

Explain about xml databases?

1049

---

What are the 18 schemas?

1104

---

In which table collections errors are stored.

2396

---

Explain the process of the user request and data generating?

1080

---

What is DB Development software?

2057

---

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

2132

---

What is normalization? Explain different levels of normalization?

63005

---

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

992

---

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

1086

---

What are the constraints on severity level in raiseerror?

974

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

997

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

946

---

What is the maximum length of an extended property?

973

---