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?

1124

What is a named program unit?

1092

How to open a cursor variable?

1041

What happens to indexes if you drop a table?

1172

How to test null values?

1113

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

1037

How to do a full database export?

1117

How to bring a tablespace online?

1082

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

1025

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

1134

How many file formats are supported to export data?

1222

Why cursor variables are easier to use than cursors?

1096

How to insert a record into a table?

1076

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

993

How to invoke the original export import utilities?

1069

Un-Answered Questions { Oracle }

Explain the difference between repeating frame and frame.

What is index in Oracle?

1078

What is recycle bin in Oracle?

1154

How to write date and time literals in oracle?

1003

How do we represent comments in oracle?

1057

What is a flashback query and when should it be used?

how to handle exceptions in post production

1433

What is a junior dba?

630

please explain.. DB architecture ...

2029

Why we use oracle d2k?

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2225

How to load data from file to file and what are the KM's required for this requirement?

615

How to delete a user account in oracle?

980

How to insert a new row into a table in oracle?

1166

How to create a testing table in oracle?

995

For More Un-Answered { Oracle } Questions Click Here