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

Oracle General Interview Questions

Questions Answers Views Company eMail

Please explain drop constraint oracle?

1101

Who developed oracle & when?

999

Explain oracle left join with an example?

1007

Explain joins in oracle?

1033

What is oracle latest version?

1092

What is an oracle and why it is used?

1145

What is the dynamic sql in oracle?

1069

Please explain joins in oracle?

1059

What are the types of trigger in oracle?

975

Explain oracle 12c new features for developers?

1056

Please explain compound trigger in oracle?

1055

Explain drop constraint oracle?

1057

What is an oracle?

1010

What is the difference between primary key and unique key and foreign key in oracle?

974

what is the difference between substr and instr function in oracle?

1082

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Reduced List of Values?

2160

How to get the Installed Oracle Version Information ?

1119

What is a private synonym?

1584

How can I create database in oracle?

1014

What are the system predefined user roles?

1041

Is oracle an operator?

923

How do I learn what codesets are available in oracle?

1036

What is ceil and floor in oracle?

1069

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1778

How data locks are respected in oracle?

1065

Give syntax for SQL and ORACLE joins.

1092

How to retrieve data from an explicit cursor?

1058

How to create id with auto_increment on oracle?

986

What is an oracle user role?

984

what are bitmap indexes? How does they work?

2235

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