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

What to do if dba lost the system password?

1172

How to define a record variable to store a table row?

1058

What happens if variable names collide with table/column names?

1191

How to start instance with a minimal initialization parameter file?

1040

How to start your 10g xe server?

1041

How to establish administrator authentication to the server?

1040

What is the quickest way to export a table to a flat file?

968

How to loop through a cursor variable?

1084

How to do clean up if create database failed?

1027

What happens if you lost a data file?

1034

How remove data files before opening a database?

1072

How to export data with a field delimiter?

1037

How to create an initialization parameter file?

1049

What to do if the startbd.bat failed to start the xe instance?

1079

How to view the tablespaces in the current database?

978

Un-Answered Questions { Oracle }

how report can be generated if we have the database designed in oracle 10g?

1886

In the oracle version 9.3.0.5.0, what does each number shows?

1299

Differentiate between function and procedure in oracle.

1075

You see multiple fragments in the system tablespace, what should you check first?

584

What is supporting issues GL AP and AR?

2549

How to store only time; not date and time?

1018

How to return top 5 rows in oracle?

1062

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2694

What is load plan and types of load plans in ODI?

628

Difference between ETL and E_LT?

591

What is split brain syndrome in rac?

What are a collation and state the different types of collation sensitivity?

1167

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

How to define an oracle cursor variable?

1027

State any two functions of oracle?

1045

For More Un-Answered { Oracle } Questions Click Here