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

Is it possible to execute a dynamic sql from forms?

1039

what are the oracle forms services components include?

981

Explain how can you use the same lov for 2 columns?

1094

List out the oracle forms configuration files?

1024

what is oracle forms?

1076

Explain how one can iterate through items and records in a specified block?

1053

what is the difference between call_form, new_form and open_form?

1245

what are the new features introduced in oracle form services in 11g release 2?

997

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1256

what are bind variables?

1032

what is the sequence of firing triggers in forms?

1 1534

What do you mean by a tablespace?

994

Explain the blob datatype?

1035

Explain rename?

939

List the various oracle database objects?

1013

Un-Answered Questions { Oracle }

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2223

Teradata: How can we know the indexed column in a table?

1862

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

570

How do I become a database administrator?

536

How to connect ms access to oracle servers?

956

what is IDE,DMV in sql server?

2773

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1920

What is the relation of a user account and a schema in oracle?

1026

Can you create a synonym without having a table?

999

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2914

How do I manually create a database in oracle?

977

What should a dba know?

495

Which flexfields you have customized?

What is varray?

1062

Can a parameter be passed to a cursor?

1072

For More Un-Answered { Oracle } Questions Click Here