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

How can you Enforce Referential Integrity in snapshots ?

1 2824

What is a SNAPSHOT ?

1 2705

What is a shared pool?

1 2413

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 2664

Give the Types of modules in a form?

1 2638

What is PL/SQL ?

3 1927

What are advantages fo Stored Procedures?

1 3147

What are the uses of Database Trigger ?

1638

What is Database Trigger ?

1 2919

Can the default values be assigned to actual parameters?

1 2638

Can a primary key contain more than one columns?

2 3661

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3338

Differentiate between TRUNCATE and DELETE?

2 2928

What is difference between a formal and an actual parameter?

1 2618

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2616

Un-Answered Questions { Oracle }

What is the difference between hot backup and cold backup in oracle?

969

Can i create more than one Master Repository in ODI?

562

What is Restricted Mode of Instance Startup in Oracle?

1155

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1638

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2478

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4481

How do I connect to oracle database?

1038

Explain how you would restore a database using RMAN to Point in Time?

2108

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

1885

What is a nvl function?

966

How would you go about increasing the buffer cache hit ratio?

2554

How to export data with a field delimiter?

980

How do you install statspack?

643

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1952

How different is ms access and oracle?

993

For More Un-Answered { Oracle } Questions Click Here