Oracle Interview Questions
Questions Answers Views Company eMail

How will you enforce security using stored procedures ?

2 4907

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

2 7414

What are the responsibilities of a Database Administrator ?

3 7021

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

1 3161

What are the database administrators utilities avaliable ?

2 3001

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

1 3164

What is a trace file and how is it created ?

2 3129

What are roles ? How can we implement roles ?

2 4525

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

1 5049

How can you enable automatic archiving ?

2 4789

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

2 6334

What is the use of ANALYZE command ?

3 6043

How can we reduce the network traffic ?

Keane India Ltd,

3 4917

What is snapshots ?

2 5078

What are the various type of snapshots ?

3 4597


Un-Answered Questions { Oracle }

How to define an anonymous procedure without variables?

535


How to lock and unlock a user account in oracle?

600


Difference between Row Id and Row Num?

373


What is open database communication (odbc) in oracle?

534


How many types of canvases are there.

1






What is Sequences?

321


What is a recovery catalog?

1


What is sequence?

614


Can we create trigger on materialized view in oracle?

552


Is postgres faster than oracle?

547


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

576


What Are Cross Validation & Adi?

669


How to define and use table alias names in oracle?

501


How do you generate file output from sql?

258


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2162