Answer Posted / raman

select DBTIMEZONE from dual;

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

1984

---

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

1106

---

what do you understand by fine-grained auditing?

1014

---

how can you enable flashback feature?

894

---

How can you control the amount of free space in your index pages? : sql server DBA

1233

---

What happens on checkpoint? : sql server DBA

1032

---

What are the recovery models for a database? : sql server DBA

1065

---

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

1040

---

What is the importance of a recovery model? : sql server DBA

967

---

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?

1915

---

What is dcl? : sql server DBA

1185

---

how can you communicate with operating system files from oracle?

982

---

How would you go about verifying the network name that the local_listener is currently using?

3157

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2365

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1885

---