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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain the use of owner option in exp command.

994

Explain integrity constraints?

1060

What do you mean by a deadlock?

1009

Will you be able to store pictures in the database?explain.

931

Explain the function of optimizer in oracle?

1057

What are the uses of synonyms?

1085

Explain the use of record option in exp command.

949

Explain the use of analyse option in exp command.

1067

List the types of joins used in writing subqueries?

944

What is meant by recursive hints in oracle?

1029

List out the components of logical database structure of oracle database.

986

Explain the use of file option in exp command.

1081

material view and view disadvantages?

1020

How many types of tables supported by oracle?

1020

How to select some rows from a table in oracle?

1008

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain coalesce function?

1119

What are the differences between primary key and unique key?

949

Name the various constraints used in oracle?

971

What is difference between truncate and delete?

977

How to write a query with a right outer join in oracle?

1113

How would you go about verifying the network name that the local_listener is currently using?

1996

Is oracle a language?

900

Difference between the “verify” and “feedback” command?

1309

Who developed oracle & when?

945

Explain oracle’s system global area (sga).

1076

Is oracle an operator?

885

What is memory advisor in Oracle?

1027

Explain the use of rows option in imp command.

1042

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2434

Explain index?

1205

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