DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Enforces user security and data privacy
|
|
|
Stores definitions of the data elements and their relationships
|
|
|
Ensures efficient performance of the database in terms of storage and access speed
|
|
|
Transforms entered data to conform to required data structures
|
Detailed explanation-1: -The DBMS transforms entered data in to required data structures. The DBMS relieves you of the chore of making a distinction between the logical data format and the physical data format. That is, the DBMS formats the physically retrieved data to make it conform to the user’s logical expectations.
Detailed explanation-2: -A DBMS must furnish a means to ensure that both the data in the database and changes to the data follow certain rules.
Detailed explanation-3: -The most frequently used data structures for one-dimensional database indexes are dynamic tree-structured indexes such as B/B+-Trees and hash-based indexes using ex-tendible and linear hashing. In general, hash-based indexes are especially good for equality searches.
Detailed explanation-4: -B-trees are the most commonly used data structures for indexes as they are time-efficient for lookups, deletions, and insertions. All these operations can be done in logarithmic time. Data that is stored inside of a B-tree can be sorted.