Differentiate between delete and truncate table?

0 Answers  

---

What is ole db ado?

0 Answers  

---

Can a database table exist without a primary key?

0 Answers  

---

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.

0 Answers   Amazon,

---

Explain the record term used in database.

0 Answers  

---

What is the function of cluster index?

0 Answers   Alcatel-Lucent,

---

how do you do sql tuning?

0 Answers   Systel,

---

1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?

1 Answers   Wipro,

---

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

0 Answers   BDI Systems, Google,

---

Integrity constraints means..? how many and what are they?

4 Answers   AZTEC,

---

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers  

---

What is dialect in database?

0 Answers  

---