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?

1023

What is a named program unit?

1027

How to open a cursor variable?

982

What happens to indexes if you drop a table?

1117

How to test null values?

1051

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

974

How to do a full database export?

1053

How to bring a tablespace online?

1012

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

970

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

1069

How many file formats are supported to export data?

1147

Why cursor variables are easier to use than cursors?

1028

How to insert a record into a table?

1027

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

943

How to invoke the original export import utilities?

990

Un-Answered Questions { Oracle }

When do you get a .pll extension in oracle? Explain its importance

991

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2277

Is postgres faster than oracle?

978

How many knowledge modules you used?

565

Can group functions be used in the order by clause in oracle?

947

What are the types of schemas?

539

When should you increase copy latches?

590

If you are working Microsoft excel, which type of file you used .excel or .csv?

604

What is the difference between single instance environment and rac environment?

What is main function of database administrator?

525

Explain the difference between sap and oracle?

984

Point the difference between translate and replace?

1032

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1155

What do you understand by database schema and what does it hold?

1186

various types of hints and their usage

2633

For More Un-Answered { Oracle } Questions Click Here