Oracle Interview Questions
Questions Answers Views Company eMail

Difference between inner join vs where ?

583

How to store only time; not date and time?

540

What is the minimum client footprint required to connect c# to an oracle database?

541

Is there a combination of "like" and "in" in sql?

556

How can I introduce multiple conditions in like operator?

533

How to load a large xml file?

559

What is the difference between "as" and "is" in an oracle stored procedure?

514

is there a tool to trace queries, like profiler for sql server?

574

What is the difference between a user and a schema in oracle?

539

What are the oracle differences between nvl and coalesce

493

What is the best way to do multi-row insert in oracle?

537

How do I spool to a csv formatted file using sqlplus?

526

What exactly do quotation marks around the table name do?

524

How to do paging with oracle?

554

How do I limit the number of rows returned by an oracle query after ordering?

593


Un-Answered Questions { Oracle }

what is oracle forms?

578


Discuss row chaining, how does it happen? How do you correct it?

274


Where do you use decode and case statements?

528


Explain what are the different type of segments?

553


Explain the use of dde package in d2k.

1






Is there any link between pr form(purchse requisition)and po form(purchase order)

2112


What is the relationship among database, tablespace and data file?

514


How many types of km's?

284


What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4050


How to use subqueries with the exists operator in oracle?

586


What is the scope of a local variable?

561


How do you use automatic pga memory management with oracle 9i and above?

269


If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

265


How to compare dates in oracle sql?

631


What is db_recovery_file_dest in oracle? When do you need to set this value?

627