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

How to create tables for odbc connection testing?

1210

What is a named program unit?

1140

How to open a cursor variable?

1093

What happens to indexes if you drop a table?

1230

How to test null values?

1159

How to define a data source name (dsn) in odbc manager?

1085

How to do a full database export?

1154

How to bring a tablespace online?

1147

Can group functions be mixed with non-group selection fields?

1073

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

1181

How many file formats are supported to export data?

1271

Why cursor variables are easier to use than cursors?

1146

How to insert a record into a table?

1124

How to define a variable to match a table column data type?

1040

How to invoke the original export import utilities?

1139

Un-Answered Questions { Oracle }

Is truncate autocommit in oracle?

1155

What is coalesce function?

1149

What is a Garbage Collection? and what is full recursive Garbage collection?

2961

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

4002

What do you mean by merge in oracle and how can you merge two tables?

1010

Explain what are the uses of rollback segment?

1069

What is ASM (Automatic Storage Management) in Oracle?

1247

Does oracle partitioning improve performance?

1053

Who is dba in dbms?

629

What is the anchoring in reports?

What is oracle used for?

1075

How do you analyze table partition using oracle provided package?

559

What is explain plan and how is it used?

657

What happens to the current transaction if the session is ended?

1140

What is ADDM Advisor in Oracle?

1227

For More Un-Answered { Oracle } Questions Click Here