Answer / sonali

oracle 10g has introduced data pump,awr addm etc

Answer / krishna

oracle 10g has many features compare to 9i like
asm,swr,addm,flaskback recovery,data pump..
generating snap shot is much more flxible in 10 g compare to 9i

Answer / mohan

it also has grid computing capabalities

Answer / ramesh

ASM,procative performance monitoring,initialization
parameter add and absolute(sga_target).

Answer / paaru ninar

The main differences b/w oracle 9i and 10g both are one and
the same but 10g has some additional features like RECYCLE
BIN (like purge and flashback) and IIMESTAMPS

Answer / ranjith

first you read properly then give your ideas plz

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

What is blob datatype?

1 Answers  

How to create a table index?

1 Answers  

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1 Answers  

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1 Answers  

master table and child table performances and comparisons in Oracle ?

1 Answers  

What is difference between sid and service name in oracle?

1 Answers  

What is the fastest query method to fetch data from the table?

1 Answers  

What the is the diff between local index and global index. give some example.

1 Answers   TCS,

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,

How to create a new table in your schema?

1 Answers  

How are the index updates?

1 Answers