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 a junior dba?

677

What are the functions of administration?

612

Which database is best to learn?

616

What is main function of database administrator?

616

What are the different types of database users?

622

What does database administrator do?

617

What degree do database administrators need?

601

What is the main function of database?

646

What are the types of schemas?

622

Can we write insert statement in function in oracle?

1156

What is a package in oracle?

1169

What is pragma autonomous transaction in oracle?

1128

What is define in oracle?

1114

Can we write dml statement in function in oracle?

1129

What is a trigger oracle?

1143

Un-Answered Questions { Oracle }

How to create a single index for multiple columns?

1086

How to define an anonymous block?

1249

Which is the best option used to move database from one server to another serve on same network and why?

583

What is table partitioning and why is it required?

How to view the tablespaces in the current database?

1029

How to connect asp pages to oracle servers?

1125

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

What are the restrictions on external table columns?

1116

Can multiple cursors being opened at the same time?

1119

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

Please explain compound trigger in oracle?

1111

Explain the various modes of normalization?

586

How can you determine if an oracle instance is up from the operating system level?

606

What is an Oracle index?

1707

3. Steps in UAT?

2482

For More Un-Answered { Oracle } Questions Click Here