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.

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1984

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

986

---

how can you find out if a table can be redefined?

962

---

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

2662

---

What purpose does the model database server? : sql server DBA

1097

---

how can you process messages in order asynchronously?

930

---

how can you schedule a job in database?

1043

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1051

---

what is ora 24313?what is the procedure to exclude that error?

2519

---

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

2792

---

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

1005

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1661

---

Explain materialized views and how they are used.

2381

---

what is logical system in sap basis

1576

---

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

1040

---