Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

what are actual and formal parameters?

1104

Differentiate between translate and replace?

1110

Explain the use of rows option in imp command.

1083

Explain the use of rows option in exp command.

1086

Explain the use of tables option in exp command.

1115

Differentiate between post-database commit and post-form commit?

1033

Explain the use of full option in exp command.

1113

Difference between pre-select and pre-query

1101

Explain an exception?

991

What are the varoius components of physical database structure of oracle database?

1004

Explain the use of online redo log files in oracle.

1036

Explain the use of grant option in exp command.

1061

What is a sub query? What are its various types?

1172

Explain enable novalidate constraint.

1075

What is a synonym? What are its various types?

1106

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a Garbage Collection? and what is full recursive Garbage collection?

2898

How do I learn what codesets are available in oracle?

1036

does the query needs a hint to access a materialized view?

1857

What is an oracle user account?

986

What is Segment Advisor in Oracle?

1101

What is a system tablespace?

1067

Explain oracle’s system global area (sga).

1137

Why does oracle 9i treat an empty string as null?

1052

How to create a table index in oracle?

1132

Can we commit inside a function in oracle?

962

What is a cursor and what are the steps need to be taken?

1198

Give the advantages and disadvantages of clusters.

1050

What are the different windows events activated at runtime ?

2898

Explain how you would restore a database using RMAN to Point in Time?

2141

How to use an explicit cursor without open statements?

1051

For More Un-Answered { Oracle General } Questions Click Here