Answer Posted / ravindra

When alter tablespace begin backup?

Ans:Oracle will write all changes to the datafile by rising
checkpoint and freezes the datafile header with latest SCN.
and backup will take upto latest SCN and transactions are
updating to datafiles also changes will be generate many
archivelogs because all changed transactions information
written to Redologs.

What is transparent data encryption? : sql server DBA

1199

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3767

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1089

---

What the different components in replication and what is their use? : sql server DBA

1057

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1085

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2289

---

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

1111

---

what is a crs resource?

1173

---

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

1581

---

what is the use of ocr?

1036

---

how can you implement fine-grained auditing?

1149

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1120

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1024

---

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

2736

---

What are the different ways you can create databases in sql server? : sql server DBA

1146

---