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.

990

Explain constraining triggers.

1096

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.

1006

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

1022

Explain oracle’s system global area (sga).

1139

Differentiate between function and procedure in oracle.

1077

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

1045

Which are the five query types available in oracle?

949

Explain parameter file in oracle.

1029

Is a rollback possible to any savepoint?

1096

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?

1066

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

How would you begin to troubleshoot an ORA-3113 error?

2079

What is a cursor variable?

1131

How to save query output to a local file?

1026

State and explain the different types of data models?

944

How to initialize variables with default values?

1243

How to omit columns with default values in insert statement in oracle?

1046

what is the use of system.effective.date variable in oracle?

1116

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2125

What is the difference between 10g OEM and 11g OEM?

965

What is PL/SQL ?

2069

How to create a table index?

1151

List out the types of joins.

1159

How to Truncate Table in Oracle

1156

What is a select query statement in oracle?

968

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