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

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

What is replication? : sql server DBA

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

what r the types of backup?

5 Answers   CSC,

---

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

1 Answers  

---

Why would you use sql agent? : sql server DBA

0 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 do you add a data file to a tablespace?

3 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

What is dbcc? : sql server DBA

0 Answers  

---