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 private procedure oracle?

962

How many types of tables are there in oracle?

1011

What is parameterized cursor in oracle?

1074

How do I spool in oracle?

950

How do I recompile a procedure in oracle?

915

Can we call procedure inside function in oracle?

1031

What are the data types in oracle?

989

What is set verify off in oracle?

1038

What is oracle data type?

908

How do I connect to oracle database?

1033

What is enter substitution variable in oracle?

994

Can we use bind variables in oracle stored procedure?

902

What is execute immediate in oracle?

959

Why do we use bulk collect in oracle?

1016

How do I find the database name in oracle?

990

Un-Answered Questions { Oracle }

How to start an oracle instance?

959

Give syntax for SQL and ORACLE joins.

1050

How to invoke the original export import utilities?

990

How to create a stored function in oracle?

1049

What is chargeback invoice? How do we create it? : oracle accounts receivable

1295

What are four common errors found in an alert .log?

511

How many dba can you have?

500

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

519

Â How to use an oracle sequence generator in a mapping?

1025

Mention what is split brain syndrome in rac?

What is the use of file param in imp command?

1123

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1944

Explain the use of dde package in d2k.

what is normalisation?what are its uses?

2217

What is dba training?

501

For More Un-Answered { Oracle } Questions Click Here