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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain user account with reference to oracle.

1026

Explain constraining triggers.

1159

What is the maximum limit on the number of columns in a table?

1148

Why do you create or replace procedures rather that drop and recreate.

1066

How would you change old and new values in an insert, delete and update triggers?

1072

Explain oracle’s system global area (sga).

1184

Differentiate between function and procedure in oracle.

1149

Give the constructs of a package, function or a procedure.

1093

Which are the five query types available in oracle?

994

Explain parameter file in oracle.

1079

Is a rollback possible to any savepoint?

1146

Give the various rollback segment states.

1083

Explain cascading triggers.

1118

Can we convert a date to char in oracle and if so, what would be the syntax?

1062

What is oracle and what are its different editions?

1118

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2304

Write a trigger example in oracle?

1110

Explain the use of consistent option in exp command.

1130

What is the difference between sharding and replication?

1128

What is the quickest way to export a table to a flat file?

1008

What is the Tune Query

2344

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

1127

what is a Nested Loop join?

2169

What happens if recursive calls get out of control?

1136

What is query image?

1022

Explain constraining triggers.

1159

What is the difference between online and offline backups?

1128

What is oracle database client?

1080

How to shutdown your 10g xe server?

1199

What is a cursor variable?

1213

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