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 is a radio Group?

1 3797

How many maximum number of radio buttons can you assign to a radio group?

1 5771

can you change the default value of the radio button group at run time?

1 6080

What triggers are associated with the radio group?

1 4844

What is a visual attribute?

1 3579

What are the types of visual attribute settings?

1 4084

What is a window?

2 5049

What are the differrent types of windows?

1 4189

Can a root window be made modal?

1 3848

List the buil-in routine for controlling window during run-time?

1 3722

List the windows event triggers available in Forms 4.0?

1 3996

What built-in is used for changing the properties of the window dynamically?

1 3705

What is a canvas-view?

1 3709

What are the types of canvas-views?

1 4407

What is the content view and stacked view?

2 5295

Un-Answered Questions { Oracle }

How to create a single index for multiple columns?

1088

List out the components of logical database structure of oracle database.

1098

Are truncate and delete commands same? If so why?

1207

How to load data through external tables?

1192

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2316

Explain the purpose of oracle real application clusters (rac)?

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2369

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

What is integrity and what is constraint??Explain with example

2347

What is ora-1555 snapshot too old error? Explain in detail?

739

How to get last row id?

1062

What is PL/SQL ?

2223

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2119

How to do a full database export?

1155

What is the difference between post-database commit and post-form commit?

1289

For More Un-Answered { Oracle } Questions Click Here