IT UNIT 2 Quiz

What is the main advantage of using a Database over a Traditional File for storing data?

• Limited data integrity and security

• Scattered information

• Offline data storage/access

• Structured

Which type of file organization is most common for large files and is typically processed in its entirety?

• Random or Direct

• Sequential

• Serial

• Indexed Sequential

What is the purpose of a Transaction File in relation to a Master File?

• To eliminate redundancies

• To recover the master file and for auditing purposes

• To support modern high-speed requirements for quick records access

• To store unstructured data

What is the main issue with Data Warehouses in terms of query performance?

• Data redundancy is typical high

• Immediate access to records is possible

• Query speeds may vary as data warehouses are usually large and growing

• Searching a record in a huge database is quick and easy

What is the characteristic of a Hierarchical Database Model that makes it difficult to update?

• Data accuracy - primary key and foreign key are used so there will be no duplication of data

• Fast and efficient data retrieval

• Limited flexibility - adding new fields or records can change the whole structure

• Easy to understand and navigate

What is the purpose of Data Mining in organizations?

• To analyze existing information in databases to find potentially useful information

• To eliminate redundancies

• To improve decision-making by providing valuable business insights

• To store and organize data

Which type of file access is normally used by magnetic tapes and can only be accessed serially?

• Sequential

• Random or Direct

• Indexed Sequential

• Serial

What is the advantage of using Data Marts over Data Warehouses in terms of performance?

• Improved performance: data marts are smaller than data warehouses which make them query faster

• More flexible connections can be made

• Data may be accidentally erased/overwritten

• Gives managers useful information to make decisions for the future

What is the main purpose of a Staging Area in a Data Warehouse?

• Services that organize and analyze data warehouse information and make it available to client applications

• Area where data is extracted from various data sources and is prepared for use in a data warehouse

• Various sources of organizational data typically used in data warehouses

• Groups data in data warehouse for specific purposes

What is the main advantage of using a Relational Database Model?

• Easier to understand logically

• Easier to model advanced real world objects

• Can store unstructured data

• Time consuming for queries to run if there are many tables