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

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 type of index should you use on a fact table?

1 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

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 are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

---

how can you schedule a job in database?

0 Answers   Oracle,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

what r the types of backup?

5 Answers   CSC,

---

How many memory layers are in the shared pool?

3 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---