Answer / kittu_chintu2005

logical backup: export/import from 10g datapump
physical backup: cold backup, hot backup & RMAN backup

Answer / srinivas

In sqlserver 8 types of backups

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. file and file group backup
7. copy only backup
8. partial backup

Answer / rohit bhosale

In SQL server 2008 we have following types of backup:

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. Partial backup
7. copy only backup
8. split backup
9. compressed backup

Answer / mahinder singh

Type of backup

1. Normal backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)

2. copy backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)

3. incremental backup(A backup of those files which have
changed since the last backup of any type.)

4. differential backup(A backup of those files which have
changes since the last full backup. Should be performed at
regular intervals.)

Answer / suman

three types of backups that is
1.physical backup:cold backup and hot backup
2.logical backup: export/import utility provided by oracle
3.Rman backup

how can you schedule a job in database?

1 Answers   Oracle,

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

1 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

What is the default fill factor value? : sql server DBA

1 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1 Answers  

---