Question

Q8. Which mechanism is used to define multiple levels of data in the database? *
Deadlock
O Single Granuarity
O Multiple Granularity
Data store
Option 2​

Answer 1

Answer:

Apex Corporation is designing a database for all its employees. The designers want to store the passport sized photograph of each employees to their respective names. ... I would opt for the file system approach and putting the paths in the SQL query as its quicker than storing the entire pic in the db itself

Answer 2

Answer:

Granularity – It is the size of data item allowed to lock. Now Multiple Granularity means hierarchically breaking up the database into blocks which can be locked and can be track what need to lock and in what fashion. Such a hierarchy can be represented graphically as a tree.