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

2 5578

What is meant by recursive hints ?

1 6374

What is meant by redo log buffer ?

2 7680

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

1 4410

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

2 8394

What is AppCore and AppCore2 ?

1 6291

Can a sigle canvas be used by different blocks ?

2 5587

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

3 6146

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

1 3531

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

1 4547

What is a predefined exception available in forms 4.0?

2 4228

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

1 3679

What is a library in Forms 4.0?

1 4207

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

1 4204

What is user Account in Oracle database ?

2 4827

Un-Answered Questions { Oracle }

Can we convert a date to char in oracle and if so, what would be the syntax?

1008

How do you run ms_batch file in forms?

What is clustered table in Oracle?

1187

What are different types of transactions in ar? : oracle accounts receivable

1285

How to rollback the current transaction in oracle?

1049

How to start instance with a minimal initialization parameter file?

1035

How to end the current transaction in oracle?

1021

what's query optimization and without use of IN AND Exist can we get another way data from query

2139

What are transaction isolation levels supported by oracle?

1062

What is bind variable in oracle 11g?

1037

What is a dba why is this position necessary?

571

Why are recursive relationships bad? How do you resolve them?

575

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

996

Give the various exception types.

989

What are the uses of a database trigger?

991

For More Un-Answered { Oracle } Questions Click Here