Answer Posted / inderjeet yadav

Primary key:A key which is uniquely indetified a row in a
table and primary key can not be null.

Unique key: A key which is uniquely indetified a row in a
table and but unique key can be null.

Foreign:Primary key of the first table that refering in
second table is know as foreign of second table.

How to do Data integrity testing? Who does this testing (Developer or tester)?

2177

---

What is the role of tester in discovery(in Checklist)?

2018

---

Explain database partitioning. What is its importance?

1255

---

How does non-cluster index functions?

1183

---

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1206

---

Explain entity set?

1066

---

give a simple example of physical and logical data independence

2627

---

what is tkprof tool and how it is used???

2884

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2589

---

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

2083

---

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

2475

---

How to implement database security?

1025

---

What is the relationship that exists inside in E-R diagram?

1155

---

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1979

---

can we delete autodiff back up that we have set through sql server agent.

2255

---