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?

1041

How to start your 10g xe server?

1042

How to establish administrator authentication to the server?

1043

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

968

How to loop through a cursor variable?

1087

How to do clean up if create database failed?

1028

What happens if you lost a data file?

1036

How remove data files before opening a database?

1074

How to export data with a field delimiter?

1039

How to create an initialization parameter file?

1054

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

1083

How to view the tablespaces in the current database?

979

Un-Answered Questions { Oracle }

how to join query for one source type is oracle another source type is sql server ?

2426

What is the relation of a user account and a schema?

1134

Explain the types of exception?

1144

Mention how oracle flex asm works?

How a database is related to tablespaces?

1032

What is a junior dba?

620

What do you mean by sga and how is it different from pga?

What are the different types of database users?

572

What is a data lock in oracle?

1122

Point the difference between translate and replace?

1089

How is rman better than user-managed backup recovery process?

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2265

Is oracle dba in demand?

594

What are the ansi data types supported in oracle?

947

How do I find my oracle client driver version?

1040

For More Un-Answered { Oracle } Questions Click Here