Answer / chowdary

Buffer Cache Advice, Segment Level Statistics and Timed
Statistics

Hot backup procedure?

2 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

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?

1 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 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,

---

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

1 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---