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 5900

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

2 8680

What are the responsibilities of a Database Administrator ?

3 8073

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

1 3782

What are the database administrators utilities avaliable ?

2 3859

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

1 3918

What is a trace file and how is it created ?

2 3984

What are roles ? How can we implement roles ?

2 5421

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

1 5744

How can you enable automatic archiving ?

2 5980

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

2 7297

What is the use of ANALYZE command ?

3 7138

How can we reduce the network traffic ?

Keane India Ltd,

3 6203

What is snapshots ?

2 6133

What are the various type of snapshots ?

3 5572

Un-Answered Questions { Oracle }

How to store pictures on to the database?

975

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

Is there a combination of "like" and "in" in sql?

1065

What view would you use to determine free space in a tablespace?

2224

How do I escape a reserved word in oracle?

1198

When system tablespace is created?

1041

How can we identify the resources for which the sessions are waiting?

Does oracle database need java?

1007

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

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

582

Can you tell me how to add new column in existing views?how?How is possible?

1446

What is procedure overloading in oracle?

1061

What do you mean by oracle dba?

570

Mention how can you determine what protocol is being used for interconnect traffic?

For More Un-Answered { Oracle } Questions Click Here