Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

Diference between Oracle 9i and 10G.

Baidu,

2 8264

What are the consideration at tehe migration of Oracle 9i to 10G.

Baidu,

3122

what are the diffeenes between oracle 9i,oracle 10g

2 6169

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2301

what is correlated subquery

3 5293

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 11615

What is the difference between an Oracle Schema and an Oracle Instance?

IBM,

3 9162

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

IBM,

1 3719

What is the exact use of Collections?

2197

sql command 2 know current database

4 6874

what is the difference between oracle enterprise edition and oracle express edition?

2 7234

when loggined as SYSTEM,how to display all the users of database using sql query?

2 5101

how to create a new database in oracle?

TCS,

6 9065

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

IBM,

1 5485

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

TCS,

3025

Un-Answered Questions { Oracle }

Which files are vital that should be backed up?

653

How to rename an index in oracle?

1177

How to add a new column to an existing table in oracle?

1192

What are the new features in release 11i?

difference of using cursor for loop and open,fetch,close.which one is better

1875

What is different type of rman backup?

722

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.

1998

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

1688

What is the data quality?

673

What does database administrator do?

617

Explain rename?

1048

Can group functions be used in the order by clause in oracle?

1051

Is oracle a language?

994

How can we generate report output in excel format?

1041

What is db_recovery_file_dest in oracle? When do you need to set this value?

1172

For More Un-Answered { Oracle } Questions Click Here