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?

1042

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 }

How do I connect to oracle database?

1119

What is the usage of analyze command in oracle?

1093

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

610

What do you understand by database schema and what does it hold?

1230

How do I spool to a csv formatted file using sqlplus?

1033

Can we protect our pl/sql source code?

1042

How to load data from external tables to regular tables?

1062

Compare and contrast between sql and sql server and explain its various functions?

964

What is the sequence of firing in report trigger?

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2461

Mention what is cluster?

How to load a large xml file?

1055

Explain an integrity constrains?

1149

What is a dba why is this position necessary?

573

Differentiate between pre-select and pre-query?

1106

For More Un-Answered { Oracle } Questions Click Here