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?

1075

How to open a cursor variable?

1031

What happens to indexes if you drop a table?

1169

How to test null values?

1105

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

1029

How to do a full database export?

1107

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?

1068

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

988

How to invoke the original export import utilities?

1062

Un-Answered Questions { Oracle }

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

610

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

575

What to do if the binary spfile is wrong for the default instance?

1069

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

which one is currently in used software cmpanies.

2152

How to drop an existing table in oracle?

1058

What is the difference between sharding and replication?

1047

What's dateware house and what's clustor with practicle example

2175

What is MTTR advisor in Oracle?

1090

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2254

What is bulk load in oracle?

1069

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

564

How to check your oracle database 10g xe installation?

986

How much money does a dba make?

580

What happens to the data files if a tablespace is dropped?

1059

For More Un-Answered { Oracle } Questions Click Here