What is the difference between a database and instance? What is the relation between them?

579

How to write a left outer join with the where clause in oracle?

1082

Is it possible to have multiple layouts in a report?

1021

What is a dba?

583

List out the oracle forms configuration files?

1068

What operating systems are supported by oracle database 10g xe?

1032

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

600

What are the types of data contol?

607

Can group functions be mixed with non-group selection fields?

1015

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1769

How do you prevent output from coming to the screen?

521

what are actual and formal parameters?

1104

Please explain drop constraint oracle?

1095

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2955

Give the different types of rollback segments.

1026