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

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---