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 the difference between simple view and complex view?

13 53327

what is the use of rank function?

1 6301

How many different types of indexes we have in oracle?

IBM, TCS,

24 192588

what are pseudocolumns?

4 10932

what is the use of composite key constraint?

2 8540

what is a cartition product?

4 11636

what is the use of ondelete cascade?

3 8351

what is cartesian product?

2 8185

What is the difference between column level constraints and table level constraints?

IBM, TCS,

14 87448

Can we create index on views?

CTS, Syntel, TCS,

19 125857

Can we create more than one index on particular column?

1 6348

What is a cluster?

2 5687

What is the difference between implicit index and explicit index?

TCS,

2 24161

What are virtual columns?

TCS,

2 7236

What is a materialised view?

5 8649

Un-Answered Questions { Oracle }

Explain drop constraint oracle?

1055

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

568

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2281

How to write an inner join with the where clause in oracle?

1042

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

968

How to rollback the current transaction in oracle?

1050

While taking hot backup (begin end backup) what will happens back end?

555

Can we call procedure inside function in oracle?

1080

Can a View based on another View in Oracle?

1027

Explain the truncate in oracle?

963

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1083

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2108

What is new feature in oracle asm 12c?

what are savepoint mode and cursor mode properties ?

What are nested tables?

1167

For More Un-Answered { Oracle } Questions Click Here