Answer / gogune suresh kumar

All data changes to the database are stored in redo-log
buffers.

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

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

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

what is incremental checkpoint?

1 Answers   CTS,

---

how can you record information about current session?

0 Answers   Oracle,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---