Answer / kittu

1) ORACLE_BASE has been introduced
2) ADR(Automatic Diagnostic Repository) added ( instead of udump, bdump, cdump in oracle 10g)
3) Case sensitive passwords
4) Data recovery advisor in RMAN
5) For db cloning in RMAN "from active database" command
6) SYSASM system level privilege has been introduced
7) New initialization parameter memory_target (instead of sga_target & pga_target)

Answer / sam

online patching,Tables can changed to read only,In datapump
parameter compression can have following values 1)
data_only,2)metadata_only,3)all,4)none

how can you schedule a job in database?

0 Answers   Oracle,

---

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

1 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

Name three advisory statistics you can collect.

1 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---