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

How to create tables for odbc connection testing?

1117

What is a named program unit?

1086

How to open a cursor variable?

1038

What happens to indexes if you drop a table?

1171

How to test null values?

1107

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

1034

How to do a full database export?

1111

How to bring a tablespace online?

1079

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

1020

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

1134

How many file formats are supported to export data?

1220

Why cursor variables are easier to use than cursors?

1094

How to insert a record into a table?

1070

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

988

How to invoke the original export import utilities?

1064

Un-Answered Questions { Oracle }

What is the purpose of scan?

Difference between pre-select and pre-query

1113

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1047

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

What is an agent and What are the types of agents?

633

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947

Explain what are the advantages of views?

1069

How to select an oracle system id (sid)?

1064

Explain the payment term in ar. : oracle accounts receivable

1106

Hi Can any one tell me what are the API's used in requisition import.

1923

What is ordinary table in oracle?

1159

What are the key components of oracle’s maximum availability architecture?

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

How to write a left outer join with the where clause in oracle?

1084

What is File steps?

620

For More Un-Answered { Oracle } Questions Click Here