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?

1024

What is a named program unit?

1030

How to open a cursor variable?

985

What happens to indexes if you drop a table?

1117

How to test null values?

1052

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

976

How to do a full database export?

1054

How to bring a tablespace online?

1012

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

971

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

1070

How many file formats are supported to export data?

1148

Why cursor variables are easier to use than cursors?

1028

How to insert a record into a table?

1029

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

943

How to invoke the original export import utilities?

992

Un-Answered Questions { Oracle }

How to use attributes of the implicit cursor in oracle?

961

What is the difference between media recovery & crash recovery?

from where do u receive the information to develop report

1969

how to remove the duplicate in odi?

583

What are temporal data types in oracle?

1076

How to create a new user account in oracle?

964

What is meant by joins?

1023

What is oracle real application clusters?

How much money does a dba make?

546

Have you attend the client meetings?

570

What is clustered table in Oracle?

1119

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

Is oracle a language?

903

A scenario for amount correction & how to use amount correction functionality in AP invoices

2093

What are the different types of modules in oracle forms?

957

For More Un-Answered { Oracle } Questions Click Here