Answer / guest

o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

What is a correlated sub-query? : sql server DBA

0 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  

---

How can you gather statistics on a table?

3 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---