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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!