Answer Posted / ram

alter database backup controlfile '\path';
alter database backup controlfile to trace;

Which autogrowth database setting is good? : sql server DBA

1143

---

How do you trace the traffic hitting a sql server? : sql server DBA

1549

---

What are the operating modes in which database mirroring runs? : sql server DBA

1170

---

What the different types of replication and why are they used? : sql server DBA

1167

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1089

---

which background process invoke at the time of upgradation tell me???

2716

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1188

---

how can you enable flashback feature?

941

---

What are statistics, under what circumstances they go out of date, how do you update them?

2238

---

How do you open a cluster administrator? : sql server DBA

1086

---

Why would you call update statistics? : sql server DBA

983

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2454

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1968

---

What are the steps you will take to improve performance of a poor performing query?

2843

---

What are the commands used in dcl? : sql server DBA

1058

---