Answer Posted / charu gautam

primary key:- the primary key of a relational table uniquely
identifies each record in the table. it can either be a
normal attribute that is guaranteed to be unique . such as
social security number in a table with no more than record
per person or it can be generated by the D B M S .such as a
globally unique identifier ,or G U I D, in microsoft SQL
server primary key may consist of a single attribute or
multiple attribute in combination.

foreign key:- A foreign key is a field (or fields) that
points to the primary key of another table.The purpose of
the foreign key is to ensure referential integrity of the
data.In other words ,only values that are supposed to appear
in the database are permitted.

Explain the various types of normalization.

1014

---

How do I setup a database connection?

958

---

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

1992

---

Explain normalization in one line?

1040

---

What is the purpose of TNS?

982

---

What is replicaset?

941

---

Explain natural key?

1055

---

What is the difference between database and server?

943

---

How is image stored in database?

986

---

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1686

---

Explain inner and outer joins with examples.

1133

---

What is difference between server and database?

1021

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1505

---

What is Data Modelling?

1028

---

define primary key index, bitmap index, hash index,virtual indwx

3279

---