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 view would you use to determine free space in a tablespace?

2294

How would you determine who has added a row to a table?

2389

How can you rebuild an index?

1 5351

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 5777

How can you gather statistics on a table?

3 8923

How can you enable a trace for a session?

2 7027

What is the difference between the SQL*Loader and IMPORT utilities?

1 5441

Name two files used for network connection to a database.

1 3389

What is an SQL FORMS ?

Verizon,

2841

What is the maximum size of a form ?

1 4409

Name the two files that are created when you generate the form give the filex extension ?

2 4710

How do you control the constraints in forms ?

1 4688

Commited block sometimes refer to a BASE TABLE ? True or False.

1 3698

Can we create two blocks with the same name in form 3.0 ?

1 5711

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.

2 5271

Un-Answered Questions { Oracle }

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1194

i am writing a query select EmpNo from Emp how can i call in after parameter form

2195

what is difference between inner join & nested query or subqueries

3115

What is transactional trigger property?

how can we store any pdf file in oracle

2223

What is J2EE Agent and port number?

661

Is oracle an open source?

1128

How to fetch the row which has the max value for a column?

1050

How to define an explicit cursor in oracle?

1102

What is oracle in java?

1020

What are the various oracle database objects?

1204

What is split brain syndrome in rac?

What is the use of lockboxes? : oracle accounts receivable

1270

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2152

How to find out what oracle odbc drivers are installed?

1096

For More Un-Answered { Oracle } Questions Click Here