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 are the different file extensions that are created by oracle reports?

1 8690

From which designation is it preferred to send the output to the printed?

1 3793

Is it possible to disable the parameter from while running the report?

1 4533

What is lexical reference?How can it be created?

1 4544

What is bind reference and how can it carate?

1 3827

What use of command line parameter cmd file?

1 3782

Where is a procedure return in an external pl/sql library executed at the client or at the server?

1 3757

Where is the external query executed at the client or the server?

Wipro,

2 5445

What are the default parameter that appear at run time in the parameter screen?

1 4390

Which parameter can be used to set read level consistency across multiple queries?

1 3535

What is term? What is use of term?

1 3973

Is it possible to insert comments into sql statements return in the data model editor?

1 3765

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

1 4983

What are the sql clauses supported in the link property sheet?

1 4305

To execute row from being displayed that still use column in the row which property can be used?

1 3434

Un-Answered Questions { Oracle }

What happens to the current transaction if the session is killed?

1043

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

1183

How will you run ms_batch file in forms?

Can multiple cursors being opened at the same time?

1119

What is Restricted Mode of Instance Startup in Oracle?

1236

Have you attended the client meetings?

662

What are the skills required for oracle dba?

708

how to join query for one source type is oracle another source type is sql server ?

2481

How to define an anonymous block?

1251

What view would you use to determine free space in a tablespace?

2296

How to create a stored program unit?

1325

How to write a query with a right outer join in oracle?

1226

When should you increase copy latches?

682

What are a cluster and non-cluster index?

1071

can you convert or reverse engineer a fmx back to a fmb file?

1229

For More Un-Answered { Oracle } Questions Click Here