Question: Any help on the multiple choice would be greatly appreciated. Removing redundant or duplicate data stored in a single table, such as price of an
Any help on the multiple choice would be greatly appreciated.
Removing redundant or duplicate data stored in a single table, such as price of an item in an order record is an attempt to ensure _____.
| A. | 1NF | |
| B. | 2NF | |
| C. | 3NF | |
| D. | 4NF
|
Which of the following statements is not one of major outcomes of Normalization?
| A. | Normalized DB helps in creating an efficient data structure with related tables. | |
| B. | Normalized DB decreases the propensity of inconsistent and orphan data. | |
| C. | Normalized DB ensures security and privacy of information. | |
| D. | Normalized DB influences the seek time to be faster because the processor is searching smaller tables.
|
In generic terms, Data-type may not include which of the following?
| A. | Bibliographic | |
| B. | Text | |
| C. | Hyperlinks | |
| D. | Numeric | |
| E. | Geographic
|
Removing repeating groups of data from one table and breaking down into two tables is an attempt to ensure ______.
| A. | 1NF | |
| B. | 2NF | |
| C. | 3NF | |
| D. | 4NF
|
Referential integrity of a relational database is ensuring that there is not a single record in a table that is a(n):
| A. | Independent record. | |
| B. | Non-unique record. | |
| C. | Unrelated record. | |
| D. | Orphan record.
|
When all fields in all tables are fully dependent on the primary key and not any other field is an attempt to ensure ______.
| A. | 1NF | |
| B. | 2NF | |
| C. | 3NF | |
| D. | 4NF
|
Because of the super explosion in the volume of data we need to handle, we talk today in terms of ________.
| A. | Gigabytes | |
| B. | Terabytes | |
| C. | Petabytes | |
| D. | Zettabytes
|
ISAM (Indexed Sequential Access Method) is a file management system developed at _____ that allows records to be accessed either sequentially (in the order they were entered) or randomly (with an index).
| A. | Microsoft | |
| B. | Oracle | |
| C. | MySQL | |
| D. | IBM
|
Just in the U.S. alone, over ______ have been breached, violated or stolen over the past two years.
| A. | 900 million to a billion records | |
| B. | 250 to 300 million records | |
| C. | 150 to 200 million records | |
| D. | 100 to 150 million records
|
Originally, data was stored as ___ files in a pure sequential format.
| A. | Relational | |
| B. | Text | |
| C. | Flat | |
| D. | Linier
|
We dedicate fast, powerful and architecturally different types of computers just to host the database systems called _______.
| A. | Data Servers | |
| B. | File Servers | |
| C. | Database Servers | |
| D. | SQL-Servers
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
