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

Oracle General (1809)
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 8131

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

Baidu,

3051

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

2 6042

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

2230

what is correlated subquery

3 5142

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

7 11347

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

IBM,

3 9009

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 3633

What is the exact use of Collections?

2140

sql command 2 know current database

4 6662

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

2 7111

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

2 4999

how to create a new database in oracle?

TCS,

6 8805

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

IBM,

1 5404

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

TCS,

2966

Un-Answered Questions { Oracle }

Name the three major set of files on disk that compose a database in Oracle?

1119

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

5404

What is CDC and explain complete CDC process flow?

586

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2132

What do you understand by the term 'system change number (scn)'?

580

What are the differences between blob and clob in oracle?

1082

What are the different types of record groups in oracle? Explain each of them

1023

What privilege is needed for a user to insert rows to tables in another schema?

1013

what is the difference between data migration and production migration.

2341

How do you put database is archivelog mode, explain procedure?

545

Is it possible to split the print reviewer into more than one region ?

2279

How to export data with a field delimiter?

1037

What do you understand by lov and how can it be used?

1080

How to convert the oracle reports to excel sheet from oracle?

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1043

For More Un-Answered { Oracle } Questions Click Here