DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Storage space is wasted & Changing the data in one spot will cause data inconsistency
|
|
|
It can be more easily accessed
|
|
|
Changing the data in one spot will cause data inconsistency
|
|
|
Storage space is wasted
|
Detailed explanation-1: -If a piece of data field value is stored in two places in the database then storage space is wasted and changing the data in one place will not cause data inconsistency.
Detailed explanation-2: -Data redundancy is defined as the storing of the same data in multiple locations. An example of data redundancy is saving the same file five times to five different disks. For example, data can be stored on two or more disks or disk and tape or disk and the Internet.
Detailed explanation-3: -Redundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space b/c you’re storing the same data in multiple places. The extra space results in larger spreadsheets that require more space in memory and on disk that take longer to save and open.
Detailed explanation-4: -Finally, you shouldn’t store credit card information in your database unless you absolutely need to. This includes credit card owner names, numbers, CVV numbers, and expiration dates. There is far too much risk involved.
Detailed explanation-5: -All the information in a database is organized and structured in database tables. These tables are stored on the hard disk of the database server. The database tables are usually divided into columns and rows, just like a regular graphic table.