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

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

how can you initialize log miner?

0 Answers   Oracle,

---

What is the dataguard background process??

1 Answers   iGate,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---