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

What is a junior dba?

630

What are the functions of administration?

558

Which database is best to learn?

574

What is main function of database administrator?

574

What are the different types of database users?

573

What does database administrator do?

584

What degree do database administrators need?

552

What is the main function of database?

614

What are the types of schemas?

581

Can we write insert statement in function in oracle?

1097

What is a package in oracle?

1108

What is pragma autonomous transaction in oracle?

1075

What is define in oracle?

1063

Can we write dml statement in function in oracle?

1089

What is a trigger oracle?

1094

Un-Answered Questions { Oracle }

What is difference between logical standby database and physical standby database?

677

What is different types of joins?

1026

How many types of synonyms in Oracle?

1128

Are database administrators in demand?

572

Will you be able to store pictures in the database?explain.

997

How to run the anonymous block again?

1135

Explain oracle insert into command?

1116

What is the purpose of the grep command?

2147

How to define an explicit cursor in oracle?

1046

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

751

How to recover a dropped table in oracle?

1048

Difference between the “verify” and “feedback” command?

1372

What do you mean by redo log file mirroring?

1037

How can you determine the number of sqlnet users logged in to the unix system?

575

What is a relational database management system?

1123

For More Un-Answered { Oracle } Questions Click Here