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?

1103

What is a named program unit?

1066

How to open a cursor variable?

1029

What happens to indexes if you drop a table?

1164

How to test null values?

1097

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

1022

How to do a full database export?

1099

How to bring a tablespace online?

1070

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

1014

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

1125

How many file formats are supported to export data?

1209

Why cursor variables are easier to use than cursors?

1087

How to insert a record into a table?

1065

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

979

How to invoke the original export import utilities?

1052

Un-Answered Questions { Oracle }

How does one coalesce free space?

545

What is meant by recursive hints in oracle?

1083

Have you attended the client meetings?

595

What is bulk copy or bcp in oracle?

1114

What is the purpose of the grep command?

2133

Is there an oracle sql query that aggregates multiple rows into one row?

968

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1080

How do I become a data manager?

522

Can you drop an index associated with a unique or primary key constraint?

1014

How to view existing locks on the database?

1047

What is the oracle implicit cursor?

1052

How can we force the database to use the user specified rollback segment?

1140

What is a data dictionary and how can it be created?

1137

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

548

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1083

For More Un-Answered { Oracle } Questions Click Here