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 5888

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

2 8667

What are the responsibilities of a Database Administrator ?

3 8058

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

1 3778

What are the database administrators utilities avaliable ?

2 3846

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

1 3914

What is a trace file and how is it created ?

2 3969

What are roles ? How can we implement roles ?

2 5406

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

1 5735

How can you enable automatic archiving ?

2 5970

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

2 7282

What is the use of ANALYZE command ?

3 7127

How can we reduce the network traffic ?

Keane India Ltd,

3 6192

What is snapshots ?

2 6127

What are the various type of snapshots ?

3 5559

Un-Answered Questions { Oracle }

How can you determine the number of sqlnet users logged in to the unix system?

572

What are the various configuration files that are used by oracle forms?

1027

How would you begin to troubleshoot an ORA-3113 error?

2077

What is SQL access advisor in Oracle?

1185

Explain the types of exception?

1139

Explain the dml?

973

How to insert multiple rows with one insert statement in oracle?

1080

What is responsibility and how u attach How to create user and how u attach with responsibility.

2037

How will you run ms_batch file in forms?

what are savepoint mode and cursor mode properties ?

How to lock and unlock a user account in oracle?

1099

types of receipts and detail desription about recipts and tables effected by receipts?

2070

Explain oracle’s server parameter file.

986

how do u place it in required folder

1928

What are the advantages of oracle?

1024

For More Un-Answered { Oracle } Questions Click Here