What command would you use to create a backup control file?

2 Answers  

---

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

1 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

What types of replication are supported in sql server? : 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  

---

what is incremental checkpoint?

1 Answers   CTS,

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

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

1 Answers  

---