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

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

Explain the use of table functions.

1 Answers  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

what is logical system in sap basis

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---