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

Where in the Oracle directory tree structure are audit traces placed?

2629

Explain materialized views and how they are used.

2 6363

When a user process fails, what background process cleans up after it?

1 4896

What background process refreshes materialized views?

1 4747

How would you determine what sessions are connected and what resources they are waiting for?

2125

Describe what redo logs are.

1 3846

How would you force a log switch?

1 3633

Give two methods you could use to determine what DDL changes have been made.

1 6764

What does coalescing a tablespace do?

2 19608

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 22528

Name a tablespace automatically created when you create a database.

HCL,

3 8867

When creating a user, what permissions must you grant to allow them to connect to the database?

4 7190

How do you add a data file to a tablespace?

1 3792

How do you resize a data file?

2 5288

What view would you use to look at the size of a data file?

1 3958

Un-Answered Questions { Oracle }

Explain about the analyze command in oracle?

1046

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2057

How to invoke the data pump export utility?

1179

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

551

What are the uses of Database Trigger ?

1708

What is iapxtb structure? Explain its importance

What are the uses of Oracle Rollback Segment?

1121

How to assign data of the deleted row to variables?

1070

What does the no logging option do? Why would we use it? Why would we be careful of using it?

548

What is tkprof and how is it used?

606

How many types of km's?

582

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

2128

What is the difference between internal & external schema?

747

difference between global n context sensitive segments?

2667

How can we collect the statistics of different database objects?

For More Un-Answered { Oracle } Questions Click Here