Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

Explain an ORA-01555

2 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

internal architecture

0 Answers   CSC,

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

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

1 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

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

0 Answers  

---