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.

929

Explain constraining triggers.

1045

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

1010

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

947

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

953

Explain oracle’s system global area (sga).

1076

Differentiate between function and procedure in oracle.

1022

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

984

Which are the five query types available in oracle?

897

Explain parameter file in oracle.

974

Is a rollback possible to any savepoint?

1001

Give the various rollback segment states.

1000

Explain cascading triggers.

1013

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

960

What is oracle and what are its different editions?

1007

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what are steps for interface? where is exchange rate defined in which table?

2058

How to create a table in a specific tablespace?

916

How to download oracle database 10g xe?

960

Explain what are clusters?

1041

Explain self joins in oracle?

951

How to build data dictionary view an new database?

960

How to drop a stored function?

1084

What is the difference between PFILE and SPFILE in Oracle?

996

Why do we use bulk collect in oracle?

1012

What to do if the startbd.bat failed to start the xe instance?

1017

State and explain the different types of data models?

896

Why is oracle so popular?

943

How to drop an existing table in oracle?

1015

What is blob datatype?

1056

Explain the use of compress option in exp command.

969

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