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

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

Oracle Interview Questions

Questions Answers Views Company eMail

Use of an integrity constraint is better to validate data. Explain

998

Explain the importance of .pll extension in oracle?

964

Explain the use of indexes option in exp command.

1088

When do you get a .pll extension in oracle?

1094

Can we protect our pl/sql source code?

1007

What is analyze command used for?

1027

What is merge statement used for?

985

Explain the use of consistent option in exp command.

1001

Explain the use of indexes option in imp command.

1115

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

1070

Explain the types of exception?

1101

When do you get a .pll extension in oracle? Explain its importance

999

What are the various types of snapshots ?

990

Explain the use of ignore option in imp command.

992

What is the purpose of save points in oracle database?

1038

Un-Answered Questions { Oracle }

How to use "out" parameter properly?

1040

Is oracle a relational database?

888

Have you attended the client meetings?

571

What is where clause in oracle?

997

How to call a sub procedure?

1048

How to create an oracle database?

989

what does the no logging option do? Why would we use it?

523

Explain the use of constraints option in exp command.

1009

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2661

What is the load plans in odi?

603

Explain about the analyze command in oracle?

1014

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

527

What is a dba?

556

What is confine mode and flex mode?

Explain oracle left join with an example?

963

For More Un-Answered { Oracle } Questions Click Here