What happens on checkpoint? : sql server DBA

0 Answers  

---

What is the default fill factor value? : sql server DBA

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  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

How can you enable a trace for a session?

1 Answers  

---

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

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---