Answer / sudarsan

check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.

Answer / sreeramch9

Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.

Answer / kittu_chintu2005

A checkpoint is a mandatory background process which signals to DBWn

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

How can you rebuild an index?

6 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

Describe what redo logs are.

1 Answers  

---