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 is merge statement used for?

1022

Explain the use of consistent option in exp command.

1062

Explain the use of indexes option in imp command.

1173

what is the use of system.effective.date variable in oracle?

1111

Explain the types of exception?

1143

When do you get a .pll extension in oracle? Explain its importance

1039

What are the various types of snapshots ?

1027

Explain the use of ignore option in imp command.

1035

What is the purpose of save points in oracle database?

1110

Difference between open_form and call_form in oracle.

1158

Explain an exception and its types?

1073

What are the different types of record groups in oracle? Explain each of them

1023

Explain the use of record length option in exp command.

1065

What is control file used for?

1200

Explain the use of inctype option in exp command.

1030

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the tools for Oracle ?

1058

How to resolve name conflicts between variables and columns?

1026

What are the benefits of ordbms?

1083

Explain the use of owner option in exp command.

1041

How to start a new transaction in oracle?

1083

How to increment dates by 1 in oracle?

1070

Which is better Oracle or MS SQL? Why?

4933

What are the differences between char and nchar in oracle?

1090

How to write numeric literals in oracle?

1181

Explain what are the advantages of views?

1064

How can we create the complete backup of data in the oracle.

2156

What is rich query?

977

How to grant create session privilege to a user in oracle?

997

What is analyze command used for?

1070

What is the fastest query method to fetch data from the table?

1355

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