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

Oracle General Interview Questions

Questions Answers Views Company eMail

Can we write insert statement in function in oracle?

1042

What is a package in oracle?

1040

What is pragma autonomous transaction in oracle?

1005

What is define in oracle?

1020

Can we write dml statement in function in oracle?

1040

What is a trigger oracle?

1048

Is oracle a programming language?

948

Is truncate autocommit in oracle?

1037

Why we use bulk collect in oracle?

984

What is procedure overloading in oracle?

1003

Is oracle a language?

904

How do you bind variables in oracle?

939

Is insert autocommit in oracle?

1028

What is data type in oracle?

1055

Why packages are used in oracle?

1011

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle database 10g express edition?

1080

What are the set operators union, union all, minus & intersect meant to do?

947

What is an Oracle Instance?

1081

How to resolve name conflicts between variables and columns?

988

What are the ways tablespaces can be managed and how do they differ?

2286

How do you tell what your machine name is and what is its IP address?

2018

How to add a new column to an existing table with a default value?

982

Explain the use of Merge statement in oracle 11g

985

What is the disadvantage of User defind function?

2252

What is a sub query and what are the different types of subqueries?

1080

Whether any commands are used for months calculation? If so, what are they?

1049

What is null value in oracle?

1050

What is meant by an index?

1070

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.

1717

Explain joins in oracle?

989

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