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.

975

Explain constraining triggers.

1090

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

1081

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

1003

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

1017

Explain oracle’s system global area (sga).

1137

Differentiate between function and procedure in oracle.

1073

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

1035

Which are the five query types available in oracle?

948

Explain parameter file in oracle.

1023

Is a rollback possible to any savepoint?

1094

Give the various rollback segment states.

1049

Explain cascading triggers.

1071

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

1011

What is oracle and what are its different editions?

1064

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a proxy object?

1061

What is the difference between formal parameters and actual parameters?

1081

Calculate difference between 2 date / times in oracle sql?

1040

How to view the data files in the current database?

1094

What is the best way to do multi-row insert in oracle?

1065

What are dml statements in oracle?

1089

How to load data from external tables to regular tables?

1060

What does sharding mean?

994

What are the differences between primary key and unique key?

1005

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

965

What is query image?

981

What is an oracle tablespace?

1034

How do I call oracle stored procedures that take no parameters?

1106

When do we use group by clause in a sql query?

1035

What is dynamic proxy?

1002

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