Oracle Interview questions


Total available count: 35
Subject - Databases
Subsubject - Oracle

What is hash cluster?

A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together/with each other on disk.




Next 5 interview question(s)

1
Difference between an implicit & an explicit cursor.?
2
How you will avoid your query from using indexes?
3
When you use WHERE clause and when you use HAVING clause?
4
How will you delete duplicating rows from a base table?
5
What is difference between SQL and SQL*PLUS?