Un-Answered Questions { Oracle General }

How will you differentiate between varchar & varchar2?

594


What are the set operators union, union all, minus & intersect meant to do?

566


What is a nvl function? How can it be used?

565


What is the use of aggregate functions in oracle?

581


What do you mean by a database transaction & what all tcl statements are available in oracle?

553


What is a data dictionary and how can it be created?

617


Why do we need integrity constraints in a database?

588


Write a trigger example in oracle?

575


Explain the difference between sql and oracle?

582


Please explain oracle left join with an example?

587


Explain the truncate in oracle?

551


How to execute the package in oracle?

572


Explain oracle insert into command?

632


Explain the difference between replace() and translate() functions in oracle?

582


Explain the features of oracle?

602