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 dictionary cache ?

2 5723

What is meant by recursive hints ?

1 6518

What is meant by redo log buffer ?

2 7817

What are the factors causing the reparsing of SQL statements in SGA?

1 4498

Can you truncate a table in a procedure in Oracle Forms?

2 8512

What is AppCore and AppCore2 ?

1 6391

Can a sigle canvas be used by different blocks ?

2 5718

What is the order of the triggers fired once the form is opened?

3 6305

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 3610

Is it possible to attach same library to more than one form?

1 4631

What is a predefined exception available in forms 4.0?

2 4354

What are the built_in used to trapping errors in forms 4?

1 3762

What is a library in Forms 4.0?

1 4306

What built-in is used for showing the alert during run-time?

1 4275

What is user Account in Oracle database ?

2 4935

Un-Answered Questions { Oracle }

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1262

How to export your own schema?

1051

How to create a stored program unit?

1325

11. Display the client number and name and the client number and name of the person who referred that client.

2394

What are advantages of dateset in datastage?

2313

What is variable? What is Flow of variable?

670

how report can be generated if we have the database designed in oracle 10g?

1945

what is profile in odi?

702

What are the variable types?

684

What happens to indexes if you drop a table?

1230

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1980

How to create a new oracle data file?

1078

How to create a new tablespace in oracle?

1041

Explain procedure to change characterset of a database.

683

Is oracle an open source?

1128

For More Un-Answered { Oracle } Questions Click Here