Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is private procedure oracle?

1051

How many types of tables are there in oracle?

1118

What is parameterized cursor in oracle?

1228

How do I spool in oracle?

1065

How do I recompile a procedure in oracle?

1018

Can we call procedure inside function in oracle?

1153

What are the data types in oracle?

1103

What is set verify off in oracle?

1165

What is oracle data type?

1013

How do I connect to oracle database?

1203

What is enter substitution variable in oracle?

1099

Can we use bind variables in oracle stored procedure?

989

What is execute immediate in oracle?

1080

Why do we use bulk collect in oracle?

1112

How do I find the database name in oracle?

1090

Un-Answered Questions { Oracle }

What flow of MSExcel in odi?

634

What is oracle used for?

1075

What is the difference between a database and instance? What is the relation between them?

626

How to create a table index?

1234

Explain do view contain data?

1052

When you used JKM ?

649

Can we protect our pl/sql source code?

1086

What are the various configuration files that are used by oracle forms?

1076

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2269

Can a parameter be passed to a cursor?

1182

What is the sid in oracle?

1036

What is catalog in Oracle?

1443

How many redo logs should you have and how should they be configured for maximum recoverability?

606

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1914

How to work with data objects interactively?

1045

For More Un-Answered { Oracle } Questions Click Here