Answer / swapna

Types of backups you can create in SQL Sever 7.0+ are Full
database backup, differential database backup, transaction
log backup, filegroup backup.

Answer / raghuram

different types of BACKUPS available in sql server are full
database backup, differential database backup,
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and
if the the database is in full database backup type,then we
do differential database backup or transactional log backup.
if the database size is too heavy means the database is
VLDB then we go for files and filegroup database backup.

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

What are types of subqueries?

0 Answers  

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

What are the five major components of a dbms?

0 Answers  

---

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---

List the advantages of using stored procedures?

0 Answers  

---

Explain how to integrate the ssrs reports in application?

0 Answers  

---