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 are the roles of dba?

1034

Differentiate between pre-select and pre-query?

1063

What is save point in oracle database?

1257

What is hot backup and logical backup?

1010

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

1314

What do you mean by a tablespace?

994

Explain the blob datatype?

1033

Explain rename?

933

List the various oracle database objects?

1010

Explain the use of show option in imp command.

1062

What suggestions do you have to reduce the network traffic?

915

Explain the use of grant option in imp command.

973

Explain the dml?

928

Explain alias?

1092

Explain the use of constraints option in exp command.

1007

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new oracle data file?

991

definition of cluster and non-clustered index?

2979

Explain integrity constraints?

1074

Explain a synonym?

983

Explain the use of show option in imp command.

1062

What is the data type of dual table?

935

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2327

How to assign values to data fields in record variables?

987

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1686

How does the on-delete-cascade statement work?

1069

How to list all user accounts in oracle?

989

Give the various exception types.

955

What is the relationship among database, tablespace and data file?

942

Explain table?

1076

what is dynamic SGA and static SGA

4350

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