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

Oracle Interview Questions

Questions Answers Views Company eMail

Mention what are the main components of an oracle rac system?

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How do you run ms_batch file in forms?

What is oracle d2k?

Which flexfields you have customized?

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How I can use srw.run_report in reports6i?

Are you familiar with user exits in reports?

What is the anchoring in reports?

How many concurrent programs you have customized, can you name some of them?

Have you used lexical parameters in reports?

How to make the project as .exe file in oracle forms & reports(d2k)?

Were you involved in any data conversion, which one?

Un-Answered Questions { Oracle }

Have you used lexical parameters in reports?

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1391

if you ctreate table identity

2374

Is there any function in oracle similar like group_concat of mysql?

1053

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

659

What is a scenario in odi?

576

What is confine mode and flex mode?

Why does Oracle not permit the use of PCTUSED with indexes?

2424

How many concurrent programs you have customized, can you name some of them?

What is the data type of dual table?

995

How to rollback the current transaction in oracle?

1054

How to specify default values in insert statement using oracle?

1104

How can we collect the statistics of different database objects?

How to connect to a local oracle 10g xe server?

992

What is proxy method?

971

For More Un-Answered { Oracle } Questions Click Here