Answer Posted / patel gopikumar

PRIMARY KEY : it is a key that not allow null value in database tables field....

UNIQUE KEY : it is a key that store or manage data uniquely...

FOREIGN KEY : it is key that use is...connect two fields in the different tables........with foreign key......


thnks........

s-150907-007 PATEL GOPIKUMAR

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1388

---

What is the use of default key?

632

---

If the master device is full, how do I make the master database bigger?

524

---

what is the role of auditor in auditing data oriented applications?

1935

---

What is difference between clustered, non-clustered and unique index?

609

---

---

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

2850

---

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

1984

---

What is the purpose of firebase?

550

---

Explain the table term used in database.

577

---

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

1312

---

What is the best database software for small businesses?

507

---

Is data lake a database?

567

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1432

---

What is the function of cluster index?

617

---

What is meant by distributed system?

539

---