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

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

Explain CREATE DATABASE syntax?

2 Answers  

---

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

2 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

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

0 Answers   Patni,

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

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

1 Answers   IBM,

---