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

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

1029

---

What is a database development?

901

---

What is the maximum length of an extended property?

923

---

How to replace not in with not exist?

1978

---

Explain about the storage and physical database design?

865

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1000

---

How to customize error conditions.

2096

---

In which table collections errors are stored.

2338

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2153

---

What is normalization? Explain different levels of normalization?

62697

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1989

---

Explain about a primary key?

928

---

Explain what a database is?

978

---

What are the types of database model?

1025

---

What are the main phases of database development?

914

---