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.

938

Explain constraining triggers.

1052

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

1029

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

959

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

965

Explain oracle’s system global area (sga).

1093

Differentiate between function and procedure in oracle.

1030

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

995

Which are the five query types available in oracle?

915

Explain parameter file in oracle.

985

Is a rollback possible to any savepoint?

1019

Give the various rollback segment states.

1009

Explain cascading triggers.

1025

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

972

What is oracle and what are its different editions?

1019

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a table in oracle?

939

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

2214

How do we get field details of a table?

941

How to select an oracle system id (sid)?

1026

How to insert a new row into a table in oracle?

1116

What is ordinary table in oracle?

1088

How to rename an existing table?

1060

What is truncate oracle?

924

How to get last row id?

948

What language does oracle use?

1061

How to rebuild an index in oracle?

985

How do I connect to oracle database?

1041

Can you tell me how to add new column in existing views?how?How is possible?

1387

Explain the truncate in oracle?

921

what's query optimization and without use of IN AND Exist can we get another way data from query

2099

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