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

Differentiate simple and complex, snapshots ?

2 5110

What dynamic data replication ?

2 6560

How can you Enforce Refrencial Integrity in snapshots ?

1 4266

What are the options available to refresh snapshots ?

2 6001

what is snapshot log ?

2 7642

When will the data in the snapshot log be used ?

2 5335

What are the benefits of distributed options in databases ?

1 4472

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33492

Define Transaction ?

5 10596

When does a Transaction end ?

2 7515

What does COMMIT do ?

4 10539

What is SAVE POINT ?

5 9588

What is Read-Only Transaction ?

3 6572

What is the function of Optimizer ?

1 4462

What are the different approaches used by Optimizer in choosing an execution plan ?

2 5199

Un-Answered Questions { Oracle }

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

2270

How to use subqueries with the exists operator in oracle?

1027

What is the meaning of database backup?

626

What is MTTR advisor in Oracle?

1090

Explain the use of file option in exp command.

1130

Explain the use of record option in exp command.

1006

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2322

What is oracle in java?

970

What are record groups ? Explain the types of record group.

What is tns service name?

1126

How to do clean up if create database failed?

1028

What is snapshot is too old? Give and example for better understand.

1603

How to use an explicit cursor without open statements?

1055

What is proxy method?

972

What is raw datatype?

1136

For More Un-Answered { Oracle } Questions Click Here