Answer Posted / sonya jalil khan

candidate key:if it qualifies to uniquely select a specific
row in the table such that the data in that table depend
completely on that key and nothing else is required.the
candidate key cannot hold NULLS.the candidte key should
never change it must holds the same value for a given
occurence of an entity for the lifetime of that
entity.
example:
EMP ID , NAME,JOB,DEPARTEMENT ID
here emp id is a candidate key.becouse a minimal set of
columns that can be used to identify a single row

Explain about the hierarchical model of the database?

1112

---

What is dbms explain in brief?

1026

---

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

2853

---

Explain about normal forms?

1054

---

How to use online Backups?

2198

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2426

---

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

2492

---

What is normalization? Explain different levels of normalization?

63099

---

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

2202

---

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.

2054

---

Explain about xml databases?

1064

---

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

2207

---

Explain the cube operator?

1000

---

In which table collections errors are stored.

2406

---

What is DB Development software?

2069

---