Answer / naresh

DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.

Explain the functionalities that views support?

0 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

How many index keys possible for a table

6 Answers  

---

What to check if a User database is locked?

0 Answers   TCS,

---

What is a function? Give some example?

3 Answers  

---

What is constraints and its types?

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

What is the difference between implicit and explicit transaction?

0 Answers  

---