Oracle Interview Question and Answers
11. |
what is null value? |
|
Null Value is neither zero nor it is a blank space. It is some unknown value which occupies 4 bytes of space of memory in SQL. |
12. |
Define transaction? |
|
A transaction is a sequence of SQL statements that Oracle Database treats as a single unit. |
13. |
what is the difference between sql&oracle? |
|
SQL is Stuctured Query Language.Oracle is a Database.SQL is used to write queries against Oracle DB. |
14. |
What are different Oracle database objects? |
|
- TABLES
- VIEWS
- INDEXES
- SYNONYMS
- SEQUENCES
- TABLESPACES
|
15. |
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 on disk. |
Page 3 of 12
12
3456789101112