Oracle Interview Questions
Questions Answers Views Company eMail

What is Object Auditing ?

2 4169

What is Privilege Auditing ?

1 3452

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

3 3868

What is Auditing ?

3 4647

What are the different Levels of Auditing ?

1 6250

What are Roles ?

2 4126

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

1 4153

What is default tablespace ?

3 4009

What is Tablespace Quota ?

2 3845

What is a profile ?

2 3430

What is a Multi-threaded Server Configuration?

1 3340

What is Shared SQL Area?

Oracle,

1 5812

What is the function of ARCH?

3 4744

What are the functions of SMON?

7 17808

What is Dedicated Server Configuration?

IR Consulting,

2 4262


Un-Answered Questions { Oracle }

What is recycle bin in Oracle?

720


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

625


Explain the purpose of forms_ddl.

1


I have applied the following commands: now what will happen, will the database will give an error / it will work?

254


What is the disk migration? what is the steps involved in oracle disk migration?

719






Can a parameter be passed to a cursor?

600


Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

345


What are the five main functions of a database administrator?

298


What do you understand by row chaining?

1


What is a trace file and how is it created in oracle?

554


What privilege is needed for a user to connect to oracle server?

555


What is temporary Interface( Yellow Interface) ?

287


How would you determine what sessions are connected and what resources they are waiting for?

1614


What is save point in oracle database?

725


What is materialized view in Oracle?

630