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 delete a column in an existing table?

1076

How to use an explicit cursor without open statements?

1055

Can multiple cursors being opened at the same time?

1060

How to invoke the data pump import utility?

1162

How to pass a cursor variable to a procedure?

1109

How to view the data files in the current database?

1097

How to turn on or off recycle bin for the session?

1109

What are the logical operations?

1125

How to list all indexes in your schema?

1093

What is the data pump export utility?

1081

How to create a new table in your schema?

1081

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

1059

How to see free space of each tablespace?

1034

How to use "out" parameter properly?

1081

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

1019

Un-Answered Questions { Oracle }

What are the knowledge modules types?

588

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2216

What is the difference between translate and replace?

1060

What is a tns service name?

1006

What is the disadvantage of User defind function?

2290

What are ddl statements in oracle?

1075

Difference between bind parameter and lexical parameter.

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

How to check your oracle database 10g xe installation?

986

Why do we need object libraries?

Explain overloading. Can functions be overloaded?

986

key flexfield structure

2176

What happens when the default and temp tablespace clauses are left out from create user statements?

573

How to define an oracle sub procedure?

1144

Which is the best option used to move database from one server to another serve on same network and why?

547

For More Un-Answered { Oracle } Questions Click Here