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 are summary column and placeholder column in reports?

Explain the difference between repeating frame and frame.

Explain the benefits and uses lexical parameter.

What is ole automation?

What is the sequence of firing in report trigger?

What are record groups ?

What is path setting for dll?

What is transactional trigger property?

What are property classes?

What is iapxtb structure? Explain its importance

Difference between lexical and bind varible.

What are open_form,call_form,new_form?

What are the types of windows (window style)?

What are the file systems and volume management techniques used in oracle rac?

What are the conditions kept in mind while connecting the oracle rac with the network?

Un-Answered Questions { Oracle }

What are the different types of failures that occur in Oracle database?

1067

Explain how to close periods in ar. : oracle accounts receivable

1312

What are the types of Generic profiles types in ODI?

728

How do you store pictures in a database?

1004

what is insert all statement in sql

6513

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

In oracle there is column command, how will you explain that?

1053

What is data block in Oracle?

1116

Who is dba in dbms?

581

What are set operators?

1082

What is the exact use of Collections?

2143

State the various uses of dbcc command?

1060

What is a snapshot log?

1003

How much money does a dba make?

580

What is the difference between "as" and "is" in an oracle stored procedure?

988

For More Un-Answered { Oracle } Questions Click Here