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?

608

What are the functions of administration?

549

Which database is best to learn?

562

What is main function of database administrator?

564

What are the different types of database users?

566

What does database administrator do?

548

What degree do database administrators need?

543

What is the main function of database?

603

What are the types of schemas?

571

Can we write insert statement in function in oracle?

1077

What is a package in oracle?

1094

What is pragma autonomous transaction in oracle?

1059

What is define in oracle?

1056

Can we write dml statement in function in oracle?

1077

What is a trigger oracle?

1082

Un-Answered Questions { Oracle }

How will you run ms_batch file in forms?

How to check the server version in oracle?

1090

How can I create database in oracle?

1007

What do we mean by hot backup & cold backup and how are they different?

How to create a new table by selecting rows from another table?

1076

What are joins, explain all types of joins?

2287

Name the various constraints used in oracle?

1011

1. What is PO rate variance gain and loss?

2908

How to create a new user account in oracle?

1009

Why more redos are generated when the oracle database is in begin backup mode?

1116

How many types of tables supported by oracle?

1069

What is a user function?

637

What is oracle d2k? Why we use it?

Is oracle a programming language?

982

What are the different pseudo commands? Explain in general?

1072

For More Un-Answered { Oracle } Questions Click Here