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

What is Object Auditing ?

2 5279

What is Privilege Auditing ?

1 4330

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

3 5347

What is Auditing ?

3 6151

What are the different Levels of Auditing ?

1 7133

What are Roles ?

2 5272

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

1 5032

What is default tablespace ?

3 5436

What is Tablespace Quota ?

2 4972

What is a profile ?

2 4424

What is a Multi-threaded Server Configuration?

1 4574

What is Shared SQL Area?

Oracle,

1 7389

What is the function of ARCH?

3 6247

What are the functions of SMON?

7 20540

What is Dedicated Server Configuration?

IR Consulting,

2 5526

Un-Answered Questions { Oracle }

What is the difference between Delete, Truncate and Drop in Oracle?

1187

Calculate difference between 2 date / times in oracle sql?

1101

What is logical backup in oracle?

1087

Why do you create or replace procedures rather that drop and recreate.

1074

What is a view and how is it different from a table?

1137

How will you run ms_batch file in forms?

Explain the use of file option in exp command.

1180

What are the common oracle dba tasks?

1205

Differences between package and loadplans?

630

What is a database instance?

633

What is recycle bin in Oracle?

1200

What is the oracle implicit cursor?

1115

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

What are the Types of Scd's?

630

How to drop a tablespace?

1089

For More Un-Answered { Oracle } Questions Click Here