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

What is Object Auditing ?

2 5191

What is Privilege Auditing ?

1 4247

What are the system resources that can be controlled through Profile ?

3 5194

What is Auditing ?

3 5992

What are the different Levels of Auditing ?

1 7055

What are Roles ?

2 5158

How to prevent unauthorized use of privileges granted to a Role ?

1 4955

What is default tablespace ?

3 5304

What is Tablespace Quota ?

2 4860

What is a profile ?

2 4306

What is a Multi-threaded Server Configuration?

1 4467

What is Shared SQL Area?

Oracle,

1 7269

What is the function of ARCH?

3 6114

What are the functions of SMON?

7 20246

What is Dedicated Server Configuration?

IR Consulting,

2 5414

Un-Answered Questions { Oracle }

How to get maxsal , minsal, ename department wise in single query

1549

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

What is using clause and give example?

1038

Is Odi used in oracle products?

668

What is oracle latest version?

1095

Explain table?

1113

key flexfield structure

2176

How to get execution statistics reports on query statements?

1091

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

631

What is a database instance?

589

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1193

What is a data lock in oracle?

1118

Explain each trigger related to mouse.

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

What is the load balancing advisory?

For More Un-Answered { Oracle } Questions Click Here