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 5914

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

2 8691

What are the responsibilities of a Database Administrator ?

3 8079

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

1 3786

What are the database administrators utilities avaliable ?

2 3870

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

1 3921

What is a trace file and how is it created ?

2 3991

What are roles ? How can we implement roles ?

2 5434

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

1 5750

How can you enable automatic archiving ?

2 5991

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

2 7304

What is the use of ANALYZE command ?

3 7148

How can we reduce the network traffic ?

Keane India Ltd,

3 6219

What is snapshots ?

2 6143

What are the various type of snapshots ?

3 5579

Un-Answered Questions { Oracle }

What is the Cdc?

707

what is a Nested Loop join?

2120

What is a flashback query and when should it be used?

What does an oracle dba do?

608

Have you attend the client meetings?

623

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1121

Have you attended the client meetings?

605

How to sort output in descending order in oracle?

1049

What are the uses of linked server and explain it in detail?

1061

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

644

What is Trigger in Oracle?

1179

Explain the oracle grid infrastructure?

material view and view disadvantages?

1079

Explain the difference between repeating frame and frame.

How to convert dates to characters in oracle?

1044

For More Un-Answered { Oracle } Questions Click Here