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 5076

What is Privilege Auditing ?

1 4174

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

3 5066

What is Auditing ?

3 5828

What are the different Levels of Auditing ?

1 6974

What are Roles ?

2 5035

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

1 4876

What is default tablespace ?

3 5161

What is Tablespace Quota ?

2 4753

What is a profile ?

2 4195

What is a Multi-threaded Server Configuration?

1 4355

What is Shared SQL Area?

Oracle,

1 7142

What is the function of ARCH?

3 5971

What are the functions of SMON?

7 19937

What is Dedicated Server Configuration?

IR Consulting,

2 5301

Un-Answered Questions { Oracle }

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

1081

What is data file?

1056

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

523

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1200

How to rebuild an index in oracle?

980

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?

1155

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1994

What is an agent and What are the types of agents?

582

State and explain the different types of data models?

899

How to add another datafile to a tablespace?

998

What is concurrency in oracle?

955

What do you understand by row chaining?

What happens if the update subquery returns multiple rows?

1055

What are the constraints are used in Ur project?

514

How to use existing values in update statements using oracle?

1017

For More Un-Answered { Oracle } Questions Click Here