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 will you enforce security using stored procedures ?

2 5811

What are the dictionary tables used to monitor a database spaces ?

2 8558

What are the responsibilities of a Database Administrator ?

3 7939

What are the roles and user accounts created automatically with the database ?

1 3737

What are the database administrators utilities avaliable ?

2 3751

What are the minimum parameters should exist in the parameter file (init.ora) ?

1 3855

What is a trace file and how is it created ?

2 3902

What are roles ? How can we implement roles ?

2 5335

What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?

1 5669

How can you enable automatic archiving ?

2 5893

How can we specify the Archived log file name format and destination ?

2 7199

What is the use of ANALYZE command ?

3 7043

How can we reduce the network traffic ?

Keane India Ltd,

3 6089

What is snapshots ?

2 6056

What are the various type of snapshots ?

3 5442

Un-Answered Questions { Oracle }

Name the three major set of files on disk that compose a database in Oracle?

1083

Why oracle forms required?

994

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1302

What are the different types of trigger and explain its various uses and functions?

1028

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

572

How view is different from a table?

981

How can we generate report output in excel format?

953

What are the constraints are used in Ur project?

518

What are the differences between lov and list item?

1011

When configuring sqlnet on the server what files must be set up?

594

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

539

Can we invoke one form from another in a multi-forms application?

1097

How much memory your 10g xe server is using?

1065

How to create a server parameter file?

1095

What is the difference between bind and lexical parameter?

1029

For More Un-Answered { Oracle } Questions Click Here