Answer Posted / viresh rajput

primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.

Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.

Composite key:- A primary key that consistsof two or more
attributes is known as composite key

candidate key:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be a primary key.


Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.

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

2077

---

Explain the role of indexing in databases?

1066

---

What are the 18 schemas?

1046

---

Explain about the database management systems.

917

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2159

---

I have a few records all are same structures data, I want to store data in multiple targets how

2585

---

How to use timestamp datatypes

1965

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1968

---

Explain about relational database management systems?

914

---

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

2441

---

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

949

---

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

1029

---

How to generate OIDS

2168

---

Why does this query return 0?

967

---

Explain the process of the user request and data generating?

1031

---