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 4236

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

3 5175

What is Auditing ?

3 5958

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 4946

What is default tablespace ?

3 5283

What is Tablespace Quota ?

2 4842

What is a profile ?

2 4288

What is a Multi-threaded Server Configuration?

1 4447

What is Shared SQL Area?

Oracle,

1 7254

What is the function of ARCH?

3 6088

What are the functions of SMON?

7 20193

What is Dedicated Server Configuration?

IR Consulting,

2 5408

Un-Answered Questions { Oracle }

What are the differences between blob and clob in oracle?

1080

How can you find all the processes on your system?

566

How do I know if oracle client is installed on windows?

1017

What is literal?

997

What do you understand by redo log file mirroring?

State and explain the different types of data models?

935

Explain oracle data types with examples?

1025

Please explain oracle left join with an example?

1039

What suggestions do you have to reduce the network traffic?

954

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2166

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2213

What are the provisions and resources provided in the oracle’s cloud server?

What do you mean by group by clause?

1042

Why is oracle database so popular?

988

what is dynamic SGA and static SGA

4407

For More Un-Answered { Oracle } Questions Click Here