Un-Answered Questions { Oracle General }

What is a nested table?

628


How view is different from a table?

550


What do you understand by a database object?

582


What is meant by raw datatype?

565


When do we use group by clause in a sql query?

567


Where do we use decode and case statements?

557


How can we find out the duplicate values in an oracle table?

602


What is the difference between truncate & delete command?

613


How will you identify oracle database software release?

525


What are the attributes that are found in a cursor?

643


What do you understand by a database object? Can you list a few of them?

602


What is a nvl function?

559


Why do we use coalesce function in oracle?

627


What is the quickest way to fetch the data from a table?

564


How translate command is different from replace?

542