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

How will you enforce security using stored procedures ?

2 6024

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

2 8808

What are the responsibilities of a Database Administrator ?

3 8218

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

1 3866

What are the database administrators utilities avaliable ?

2 3995

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

1 4003

What is a trace file and how is it created ?

2 4082

What are roles ? How can we implement roles ?

2 5548

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

1 5824

How can you enable automatic archiving ?

2 6080

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

2 7402

What is the use of ANALYZE command ?

3 7266

How can we reduce the network traffic ?

Keane India Ltd,

3 6360

What is snapshots ?

2 6240

What are the various type of snapshots ?

3 5698

Un-Answered Questions { Oracle }

What does dba stand for database?

659

What is define in oracle?

1114

How to rename an existing table?

1228

How to loop through data rows in the implicit cursor?

1122

How to use fetch statement in a loop?

1070

Why oracle is used?

1114

What is a junior dba?

679

How to divide query output into groups in oracle?

1040

Mention what are the key characteristics of rac or why to use rac?

Â How to use an oracle sequence generator in a mapping?

1137

How to rebuild an index in oracle?

1078

What is oracle in java?

1020

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1161

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1962

How to empty your oracle recycle bin?

1079

For More Un-Answered { Oracle } Questions Click Here