Answer Posted / manumole

Candidate key:

Candidate keys for a table includes the set of columns
which satisfies the criteria of a primary key.

Primary key : a column/combination of columns which
uniquely identifies a row and whose values are not null.

Clustered Key:when a combination of columns becomes a
primary key it is called as clustered key.

Alternate keys:the set of columns which is avialble in the
candidate keys and are not selected as primary key.

Eg:Customer table
candidate keys:{ CustomerID, MobNo(defined as not null) }

primary key: if Db designer selected as CustomerID,then
Alternate key is MobNo
Clustered key:if both combination CustomerID- MobNo is
taken as primary key,it is nothing but a clustered key

Explain about relational database management systems?

971

---

Explain about post-relational databases?

1027

---

Explain about the hierarchical model of the database?

1118

---

How to generate OIDS

2261

---

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?

968

---

How can I detect whether a given connection is blocked?

1055

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2170

---

What is database design and development?

1022

---

What are the types of database model?

1098

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2857

---

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).

2219

---

Explain about query and reporting.

2096

---

What is normalization? Explain different levels of normalization?

63127

---

Explain the process of the user request and data generating?

1095

---

State the acid rules?

1137

---