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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What are transaction isolation levels supported by oracle?

1119

How to write a query with an inner join in oracle?

1102

How to connect the oracle server as sysdba?

1134

What is a cursor in oracle?

1232

How to calculate date and time differences in oracle?

1099

What is a select query statement in oracle?

1033

What is a initialization parameter file in oracle?

1089

How to unlock the sample user account in oracle?

1079

How to rollback the current transaction in oracle?

1107

What are the differences between date and timestamp in oracle?

1099

How to pass parameters to procedures in oracle?

1086

What is system global area (sga) in oracle?

1041

How to delete an existing row from a table in oracle?

1134

How to write numeric literals in oracle?

1238

How to write a query with a full outer join in oracle?

1 1550

Un-Answered Questions { Oracle }

Explain master-detail relationship with some examples.

1058

What is the disk migration? what is the steps involved in oracle disk migration?

1274

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

637

What is a user account in oracle?

1173

When do I need to use a semicolon vs a slash in oracle sql?

1150

How oracle flex asm works?

Explain the use of ignore option in imp command.

1090

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1130

What is an oracle transaction?

1234

What is bulk load in oracle?

1135

How do I become a database administrator?

626

Explain enable novalidate constraint.

1136

What happens to the current transaction if the session is ended?

1140

query optmization techniques and quwry analyser+projects+ppts

2470

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2250

For More Un-Answered { Oracle } Questions Click Here