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 52947

what is the use of rank function?

1 6216

How many different types of indexes we have in oracle?

IBM, TCS,

24 191887

what are pseudocolumns?

4 10776

what is the use of composite key constraint?

2 8456

what is a cartition product?

4 11478

what is the use of ondelete cascade?

3 8234

what is cartesian product?

2 8092

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

IBM, TCS,

14 87003

Can we create index on views?

CTS, Syntel, TCS,

19 125351

Can we create more than one index on particular column?

1 6278

What is a cluster?

2 5621

What is the difference between implicit index and explicit index?

TCS,

2 24049

What are virtual columns?

TCS,

2 7107

What is a materialised view?

5 8490

Un-Answered Questions { Oracle }

What are the various configuration files that are used by oracle forms?

1006

How many types of tables supported by oracle?

1033

What is the purpose of tables, private synonyms and public synonyms in Oracle?

997

Difference between cartesian join and cross join?

983

What is data file?

1059

How are extents allocated to a segment?

1084

How can we identify the resources for which the sessions are waiting?

Explain the use of rows option in exp command.

1044

What is oracle d2k? Why we use it?

What is split brain syndrome in rac?

What are temporal data types in oracle?

1084

What are the parameters that we can pass through a stored procedure?

1011

if some data is not transfered where it will get stored

1898

How to check the server version in oracle?

1055

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

For More Un-Answered { Oracle } Questions Click Here