Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 53788

what is the use of rank function?

1 6398

How many different types of indexes we have in oracle?

IBM, TCS,

24 193497

what are pseudocolumns?

4 11136

what is the use of composite key constraint?

2 8639

what is a cartition product?

4 11819

what is the use of ondelete cascade?

3 8468

what is cartesian product?

2 8286

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

IBM, TCS,

14 88062

Can we create index on views?

CTS, Syntel, TCS,

19 126579

Can we create more than one index on particular column?

1 6449

What is a cluster?

2 5813

What is the difference between implicit index and explicit index?

TCS,

2 24312

What are virtual columns?

TCS,

2 7415

What is a materialised view?

5 8854

Un-Answered Questions { Oracle }

How to connect to oracle using service name instead of sid?

1077

Explain the purpose of oracle real application clusters (rac)?

What is the difference between truncate and delete? Why is one faster?

706

What do you know about normalization? Explain in detail?

1005

How can you determine the space left in a file system?

692

What is save point in oracle database?

1370

How to update values in a table in oracle?

1084

Where do we use connected and un connected lookups?

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1839

How do you set up your tablespace on installation level: low?

602

Explain the method to debug errors in an oracle application.

How to create tables for odbc connection testing?

1212

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2322

What do you understand by database schema and what does it hold?

1310

What are the differences between interval year to month and interval day to second?

1070

For More Un-Answered { Oracle } Questions Click Here