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?

972

Explain the use of consistent option in exp command.

974

Explain the use of indexes option in imp command.

1088

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

1056

Explain the types of exception?

1083

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

987

What are the various types of snapshots ?

972

Explain the use of ignore option in imp command.

977

What is the purpose of save points in oracle database?

1007

Difference between open_form and call_form in oracle.

1094

Explain an exception and its types?

1012

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

972

Explain the use of record length option in exp command.

1026

What is control file used for?

1102

Explain the use of inctype option in exp command.

978

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Difference between open_form and call_form in oracle.

1094

How can we find out the duplicate values in an oracle table?

996

What types of joins are used in writing subqueries?

939

Name the three major set of files on disk that compose a database in Oracle?

1067

What is a read write transaction in oracle?

1032

What is merge statement used for?

972

In the oracle version 9.3.0.5.0, what does each number shows?

1226

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1967

Can we create database in oracle using command line ?

1031

what is the scenario where you take the database to NoArchivelog mode?

2259

What is a package ? What are the advantages of package ?

1033

what is IDE,DMV in sql server?

2754

What is a proxy class?

969

How to save query output to a local file?

970

What is MTTR advisor in Oracle?

1035

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