DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
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
|
|
|
Enforces user security and data privacy
|
Detailed explanation-1: -Database performance tuning refers to a group of activities DBAs perform to ensure databases operate smoothly and efficiently. It helps re-optimize a database system from top to bottom, from software to hardware, to improve overall performance.
Detailed explanation-2: -Performance tuning is the improvement of system performance. Typically in computer systems, the motivation for such activity is called a performance problem, which can be either real or anticipated. Most systems will respond to increased load with some degree of decreasing performance.
Detailed explanation-3: -To improve the speed of data retrieval options The more data you have, the slower data retrieval can be if your database is not optimized. Performance tuning lets you build indexes and eliminate problems which could cause your data retrieval to be slower than it has to be.