Answer / yasaswini

the major differences between Oracle9i and Oracle10g:

Major changes to SQL optimizer internals

Oracle Grid computing

AWR and ASH tables incorporated into Oracle Performance
Pack and Diagnostic Pack options

Automated Session History (ASH) materializes the Oracle
Wait Interface over time

Data Pump replaces imp utility with impdp

Automatic Database Diagnostic Monitor (ADDM)

SQLTuning Advisor

SQLAccess Advisor

Rolling database upgrades (using Oracle10g RAC)

dbms_scheduler package replaces dbms_job for scheduling

How to get unique records from a table?

1 Answers  

---

Difference between global and parameter variables?

1 Answers   TCS,

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

Can a table contain multiple primary key’s?

1 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

1 Answers  

---

Can we update views in sql?

1 Answers  

---

how to create a new view in mysql? : Sql dba

1 Answers  

---

Define union, minus, union all, intersect ?

1 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

What is a relationship and what are they?

1 Answers  

---

What is procedure and function?

1 Answers  

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1 Answers  

---