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.

987

Explain constraining triggers.

1093

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

1086

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

1004

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

1020

Explain oracle’s system global area (sga).

1139

Differentiate between function and procedure in oracle.

1074

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

1040

Which are the five query types available in oracle?

949

Explain parameter file in oracle.

1029

Is a rollback possible to any savepoint?

1094

Give the various rollback segment states.

1052

Explain cascading triggers.

1073

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

1015

What is oracle and what are its different editions?

1064

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new table in oracle?

1153

How to use "for" statements in oracle?

1073

How to upsert (update or insert into a table)?

999

How to generate query output in html format?

1116

What is a tns file?

994

What are the differences between interval year to month and interval day to second?

1026

What do you mean by group by clause?

1042

Query to retrieve record for a many to many relationship ?

2518

What is null value in oracle?

1097

Is there a function to split a string in plsql?

1055

what is dynamic SGA and static SGA

4417

How to rename an index in oracle?

1113

How to create a temporary table in oracle?

1267

How to drop a stored procedure in oracle?

1051

What are the system predefined user roles?

1041

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