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 5202

What is Privilege Auditing ?

1 4255

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

3 5211

What is Auditing ?

3 6003

What are the different Levels of Auditing ?

1 7063

What are Roles ?

2 5182

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

1 4963

What is default tablespace ?

3 5319

What is Tablespace Quota ?

2 4869

What is a profile ?

2 4317

What is a Multi-threaded Server Configuration?

1 4480

What is Shared SQL Area?

Oracle,

1 7278

What is the function of ARCH?

3 6130

What are the functions of SMON?

7 20273

What is Dedicated Server Configuration?

IR Consulting,

2 5429

Un-Answered Questions { Oracle }

When should you increase copy latches?

649

Give the constructs of a package, function or a procedure.

1053

What are roles in oracle?

581

What do you understand from cache fusion?

Why do you use stored procedures and state some of its disadvantages?

1028

Difference between ETL and E_LT?

600

Explain about the analyze command in oracle?

1056

various types of hints and their usage

2700

How many knowledge modules you used?

599

How to start a new transaction in oracle?

1088

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

751

What is MTTR advisor in Oracle?

1091

What are advantages of dateset in datastage?

2264

How to pass a cursor variable to a procedure?

1113

What is connection pooling in oracle?

975

For More Un-Answered { Oracle } Questions Click Here