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?

1136

Differentiate between pre-select and pre-query?

1153

What is save point in oracle database?

1361

What is hot backup and logical backup?

1111

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

1411

What do you mean by a tablespace?

1089

Explain the blob datatype?

1122

Explain rename?

1041

List the various oracle database objects?

1108

Explain the use of show option in imp command.

1144

What suggestions do you have to reduce the network traffic?

1018

Explain the use of grant option in imp command.

1078

Explain the dml?

1041

Explain alias?

1193

Explain the use of constraints option in exp command.

1079

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to drop an existing view in oracle?

992

What is not equal to in oracle?

1047

What is index in Oracle?

1128

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2285

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2309

if you ctreate table identity

2426

What is a select query statement in oracle?

1024

How to shutdown your 10g xe server?

1201

Explain do view contain data?

1047

What is the string concatenation operator in oracle?

1228

What is parameterized cursor in oracle?

1219

What is the usage of merge statement?

1202

What are the differences between char and nchar in oracle?

1140

Explain what are the uses of rollback segment?

1064

Explain the use of consistent option in exp command.

1131

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