Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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?

2707

Explain materialized views and how they are used.

2 6483

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

1 5003

What background process refreshes materialized views?

1 4847

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

2181

Describe what redo logs are.

1 3954

How would you force a log switch?

1 3731

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

1 6857

What does coalescing a tablespace do?

2 19741

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

2 22671

Name a tablespace automatically created when you create a database.

HCL,

3 8997

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

4 7355

How do you add a data file to a tablespace?

1 3923

How do you resize a data file?

2 5433

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

1 4030

Un-Answered Questions { Oracle }

Mention what is the difference between single instance environment and rac environment?

Give the various rollback segment states.

1092

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1509

what systems can odi extract and load data into?

659

What is supporting issues GL AP and AR?

2621

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2094

Is insert autocommit in oracle?

1134

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4682

what is difference between inner join & nested query or subqueries

3115

How to use existing values in update statements using oracle?

1120

What is a view and how is it different from a table?

1138

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1710

What is the difference between online and offline backups?

1136

What are temporal data types in oracle?

1171

When do you get a .pll extension in oracle? Explain its importance

1103

For More Un-Answered { Oracle } Questions Click Here