Answer / shwetha

During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---

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

0 Answers  

---

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

when does an alert gets signaled?

0 Answers   Oracle,

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

Name a tablespace automatically created when you create a database.

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

---