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 5176

What is Privilege Auditing ?

1 4237

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

3 5175

What is Auditing ?

3 5959

What are the different Levels of Auditing ?

1 7043

What are Roles ?

2 5141

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

1 4947

What is default tablespace ?

3 5284

What is Tablespace Quota ?

2 4844

What is a profile ?

2 4288

What is a Multi-threaded Server Configuration?

1 4448

What is Shared SQL Area?

Oracle,

1 7255

What is the function of ARCH?

3 6088

What are the functions of SMON?

7 20194

What is Dedicated Server Configuration?

IR Consulting,

2 5408

Un-Answered Questions { Oracle }

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

555

How many types of km's?

579

What is Redo Log Buffer in Oracle?

1198

what is the odi console?

622

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2065

what is reindexing?

1665

How to work with data objects interactively?

972

How to get a list of all background sessions in the database?

988

How many types of auditing in Oracle?

1030

How many types of segments in Oracle?

1063

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1944

What are the types of partitions in oracle?

1034

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1131

Explain parameter file in oracle.

1020

What is Data Dictionary Cache in Oracle?

1160

For More Un-Answered { Oracle } Questions Click Here