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

List the parts of a database trigger.

997

Explain oracle’s server parameter file.

953

Explain overloading. Can functions be overloaded?

944

Give the advantages and disadvantages of clusters.

1004

Define oracle database

1000

Explain oracle instance.

1117

What is ceil and floor in oracle?

1018

Can a parameter be passed to a cursor?

1059

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1021

Explain user account with reference to oracle.

934

Explain constraining triggers.

1047

What is the maximum limit on the number of columns in a table?

1021

Why do you create or replace procedures rather that drop and recreate.

954

How would you change old and new values in an insert, delete and update triggers?

959

Explain oracle’s system global area (sga).

1087

Un-Answered Questions { Oracle }

When should you increase copy latches? What parameters control copy latches?

534

What is null value in oracle?

1044

What is the advantage of using rman?

670

Mention what is olr?

Mention what is oracle real application clusters?

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2268

Mention in rac what files should be created on shared storage?

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2102

If you see statistics that deal with "undo" what are they really talking about?

612

What is the most common database language that a db administrator needs to know?

529

How many dba can you have?

500

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1101

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1994

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

523

Is primary key indexed by default in oracle?

937

For More Un-Answered { Oracle } Questions Click Here