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 5194

What is Privilege Auditing ?

1 4247

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

3 5196

What is Auditing ?

3 5993

What are the different Levels of Auditing ?

1 7055

What are Roles ?

2 5165

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

1 4955

What is default tablespace ?

3 5306

What is Tablespace Quota ?

2 4860

What is a profile ?

2 4308

What is a Multi-threaded Server Configuration?

1 4469

What is Shared SQL Area?

Oracle,

1 7271

What is the function of ARCH?

3 6118

What are the functions of SMON?

7 20250

What is Dedicated Server Configuration?

IR Consulting,

2 5416

Un-Answered Questions { Oracle }

What is the page protect in reports?

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1045

Please explain oracle left join with an example?

1045

Difference between bind parameter and lexical parameter.

Explain what are the different type of segments?

965

how to write the sub-queries in odi?

704

What are nested tables?

1174

Explian File steps in ODI?

625

What are the five functions of a database?

607

What are property classes?

What are the different types of record groups in oracle? Explain each of them

1025

In topology manager where the data are stored?

677

How to invoke the data pump import utility?

1162

What are parameter files? Where do we use them?

What is redo log?

1064

For More Un-Answered { Oracle } Questions Click Here