Answer / iliyas ali

1.To take both the bkp the db should be in Archive log
2.Rman doesn't put tablespace in bkp mode.
3.the biggest advantage of Rman is that it takes the bkp of the used space/blocks of database.where user managed bkp takes the bkp of complete data file.
4.Rman will automatically detect block corruption,which is not possible in Hot bkp.
5.In Rman we can take incremental bkp,which is not possible in User managed bkp.
6.Rman is FRA aware.We can perform table space point in time recovery,as block change tracking also which is not possible in user managed backup.
7.Most importantly,Rman will re-read the data block until it gets the consistent image of it.

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

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

0 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

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

0 Answers  

---