What is a server parameter file in oracle?

1004

How to synchronize 2 schema's objects?

2117

What is redo log?

1006

How to drop an index?

910

What are the uses of synonyms?

1084

What do you understand by database schema and what does it hold?

1179

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1326

What is the data pump import utility?

969

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2291

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4295

Explain index?

1204

Difference between varchar and varchar2 data types?

1117

Explain the use of tables option in exp command.

1054

Is truncate autocommit in oracle?

1024