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 a snapshot log?

1003

Can objects of the same schema reside in different tablespace?

1062

How index is implemented in oracle database?

1006

How are extents allocated to a segment?

1125

How does one create a new database?

590

What database block size should I use?

733

How does one coalesce free space?

550

What are the attributes of cursor?

1054

What are set operators?

1082

What is blob datatype?

1129

What are a cluster and non-cluster index?

1018

How do we create privileges in oracle?

1046

State and explain about oracle instance?

991

What is the data type of dual table?

995

What is using clause and give example?

1044

Un-Answered Questions { Oracle }

What is the sequence of firing in report trigger?

What is da in database?

543

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

2286

What is oracle full backup?

570

Explain the various types of oracle report?

1075

Explain the use of tables option in exp command.

1116

Compare and contrast between sql and sql server and explain its various functions?

964

You see multiple fragments in the system tablespace, what should you check first?

584

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

555

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.

2116

What is oracle thin client?

1023

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2521

How to start instance with a minimal initialization parameter file?

1040

What is explain plan and how is it used?

607

what we specify the in XML data server and parameters for to connect to xml file?

700

For More Un-Answered { Oracle } Questions Click Here