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

What is required by oracle rac database to connect to a network?

What is the purpose of scan?

What is the function of cache fusion in oracle rac?

material view and view disadvantages?

1132

How many types of tables supported by oracle?

1127

How to select some rows from a table in oracle?

1130

How to connect to a local oracle 10g xe server?

1038

How to use subqueries with the in operator using oracle?

1143

Can select statements be used on views in oracle?

1088

How to use "while" statements in oracle?

1381

How to sort the query output in oracle?

1077

How to use null as conditions in oracle?

1130

How to use "for" statements in oracle?

1126

How to use group functions in the select clause using oracle?

1136

What is transport network substrate (tns) in oracle?

1099

Un-Answered Questions { Oracle }

How to write text literals in oracle?

1127

Explain the use of control file?

1180

How to store pictures on to the database?

1035

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

696

While taking hot backup (begin end backup) what will happens back end?

608

What is SKM and when we will use this SKM?

722

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

640

What are the system variables can be set by users? Explain them

What is the implicit cursor in oracle?

1175

How to load data from file to file and what are the KM's required for this requirement?

666

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1325

What is query image?

1023

Why is oracle used?

983

What is redo log?

1118

What is oracle full backup?

617

For More Un-Answered { Oracle } Questions Click Here