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.

926

Explain constraining triggers.

1042

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

1004

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

945

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

950

Explain oracle’s system global area (sga).

1073

Differentiate between function and procedure in oracle.

1018

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

982

Which are the five query types available in oracle?

895

Explain parameter file in oracle.

969

Is a rollback possible to any savepoint?

997

Give the various rollback segment states.

999

Explain cascading triggers.

1011

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

956

What is oracle and what are its different editions?

1007

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between online and offline backups?

971

What is redo log?

1004

Can multiple cursors being opened at the same time?

1016

How to assign values to data fields in record variables?

973

What are a cluster and non-cluster index?

955

What are joins, explain all types of joins?

2219

State the difference between a primary key and foreign key?

886

How to export your own schema?

968

Explain the use of constraints option in exp command.

989

What is dual table oracle?

924

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2209

How do we get field detail of a table?

1020

How to use "startup" command to start default instance?

962

What are the original export and import utilities?

1056

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2300

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