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.

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

What is cross join in sql server joins?

0 Answers  

---

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

---

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

---

Explain rdbms?

0 Answers  

---

What is left outer join in sql server joins?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

How to find tables without indexes?

0 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---