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

1040

Explain the importance of .pll extension in oracle?

1011

Explain the use of indexes option in exp command.

1149

When do you get a .pll extension in oracle?

1146

Can we protect our pl/sql source code?

1043

What is analyze command used for?

1072

What is merge statement used for?

1024

Explain the use of consistent option in exp command.

1066

Explain the use of indexes option in imp command.

1179

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

1116

Explain the types of exception?

1143

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

1042

What are the various types of snapshots ?

1029

Explain the use of ignore option in imp command.

1035

What is the purpose of save points in oracle database?

1118

Un-Answered Questions { Oracle }

ABOUT IDENTITY?

2057

What is oracle rowcount?

1084

How to use values from other tables in update statements using oracle?

1079

What is a select query statement in oracle?

968

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2043

What is the importance of batch source set up in ar? : oracle accounts receivable

1264

Is there any link between pr form(purchse requisition)and po form(purchase order)

2725

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2351

Differentiate between function and procedure in oracle.

1076

What is oracle data type?

963

What is the difference between sga and pga?

618

What is sharded cluster?

1015

What is different types of joins?

1022

How to bring a tablespace online?

1079

What is a named program unit?

1083

For More Un-Answered { Oracle } Questions Click Here