Question 1

The most popular type of database today is the:
A)Hierarchical database
B)Tree database
C)Green database
D)Relational database
E)Piecemeal database

Accepted Answer

Relational databases are currently the most widely used type of database. They organize data into tables with rows and columns, and utilize a system of relations between tables to manage complex data structures. Relational databases are highly versatile and can be used in a variety of applications, including enterprise systems, e-commerce platforms, and data analytics.

Question 2

Which of the following is an open source DBMS?
A)Microsoft Access
B)SQL Server
C)MySQL
D)Excel
E)CASE

Accepted Answer

MySQL is an open source DBMS, while Microsoft Access, SQL Server, Excel, and CASE are not.

Question 3

Which is NOT a type of database file?
A)Hierarchical databases
B)Relational databases
C)Object databases
D)Multidimensional databases
E)Federal database

Accepted Answer

There is no such thing as a "federal database." While the other options are types of database files, "federal database" is not a recognized category.

Question 4

This type of file is used to update a master file:
A)Roster Files
B)Training files
C)Master files
D)Transaction files
E)Integrated files

Accepted Answer

Transaction files are used to update a master file by adding, deleting or modifying data in the existing master file.

Question 5

Which of the following is a concept not generally associated with decision support systems?
A)Data warehouses
B)Data marts
C)Aggregated data
D)Object orientation
E)Multidimensional databases

Accepted Answer

Object orientation is not typically associated with decision support systems, which tend to focus on data analysis and manipulation.

Question 6

The two basic formats for data storage:
A)Spreadsheets and documents
B)Files and databases
C)Databases and presentations
D)Flash and web forms
E)ERDs and Use cases

Accepted Answer

The two basic formats for data storage are files and databases. Files are typically used for storing unstructured data, such as documents, images, and videos. Databases, on the other hand, are used for storing structured data, such as customer information or transaction records. Together, files and databases form the backbone of modern data storage and management systems.

Question 7

This type of file records "before" and "after" images of data as the data gets altered.
A)Intelligent files
B)Audit files
C)Master files
D)Raw files
E)Prime files

Accepted Answer

Audit files are used to track changes made to data, including "before" and "after" images, making them the best choice for this question. Intelligent files, master files, raw files, and prime files do not necessarily have this same function.

Question 8

Which of the following is NOT a file type described in the textbook?
A)History files
B)Audit files
C)Look-up files
D)Algebra files
E)Transaction files

Accepted Answer

History files, audit files, look-up files, and transaction files are all described in the textbook as common types of files used in computer systems. Algebra files are not mentioned as a type of file.

Question 9

The acronym for the standard language used to access data in relational databases is:
A)ERD
B)CRM
C)ERP
D)BPR
E)SQL

Accepted Answer

The acronym for the standard language used to access data in relational databases is SQL (Structured Query Language). ERD (Entity Relationship Diagram), CRM (Customer Relationship Management), ERP (Enterprise Resource Planning), and BPR (Business Process Reengineering) are all related to database and business management, but do not specifically refer to the language used to access data in relational databases.

Question 10

Which of the following is not a characteristic of Big Data?
A)Huge volume
B)Rapid velocity
C)Great variety
D)All are characteristics
E)None are characteristics

Accepted Answer

The answer of Which of the following is not a...

Question 11

Legacy databases might include ________ and ______________
A)Master files and transaction files
B)Audit files and look-up files
C)Hierarchical databases and network databases
D)Tree databases and leaf databases
E)Red databases and Green databases

Accepted Answer

Legacy databases often refer to older database models that were used before the widespread adoption of relational databases. Hierarchical and network databases are examples of such legacy systems.

Question 12

Which of the following is not a RDBMS?
A)Oracle
B)NoSQL
C)SQL
D)MySQL
E)None of these

Accepted Answer

NoSQL is not a RDBMS, it is a non-relational database management system. The other options (Oracle, SQL, MySQL) are all examples of RDBMS.

Question 13

This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).
A)History Files
B)Audit files
C)Master files
D)Transaction files
E)Intelligent files

Accepted Answer

Master files store core information that is important to the business, such as customer mailing lists. They are used by applications to keep track of this information. History files store records of past transactions, audit files track changes to data and user actions, transaction files record current transactions, and intelligent files use artificial intelligence to automatically categorize and prioritize data.

Question 14

In most cases,decision support systems are best at:
A)Finding particular records that are stored in legacy databases
B)Finding processes that are stored in object databases
C)Finding aggregated data
D)Analyzing audit (or log)files for possible intrusion and security breaches
E)Red and green linked list processing

Accepted Answer

Decision support systems are often used to analyze and present aggregated data in a meaningful way, allowing decision-makers to identify patterns and trends. While they can be used for other purposes, such as finding specific records or analyzing logs, their strength lies in handling large amounts of data and helping users make informed decisions based on that data.

Question 15

Most relational database systems support:
A)Referential integrity
B)Pop-up menus
C)Customizable user-interface colors and graphics
D)The 'three-clicks' rule
E)Broadband connectivity

Accepted Answer

Relational database systems typically support referential integrity to maintain consistency between related tables. Pop-up menus, customizable user-interface colors and graphics, and the 'three-clicks' rule are not specific features of relational database systems. Broadband connectivity is a requirement for accessing databases remotely, but it is not a specific feature of a database system itself.

Question 16

Document-oriented databases have the following characteristics,except:
A)Large bit files
B)Audio files
C)Video files
D)Files with uniform structure
E)image files

Accepted Answer

Document-oriented databases are known for handling a wide variety of data types including large bit files, audio files, video files, and image files, but they do not require files to have a uniform structure. Instead, they are designed to store, retrieve, and manage document-oriented information, which can be structured in many different ways.

Question 17

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zip code,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.
A)Multidimensional
B)Hierarchical
C)Legacy
D)Object
E)Relational

Accepted Answer

The best choice for Omar's order database would be a relational database as the data is fairly simple and structured, with clear relationships between the different types of data (e.g. customer information and car information). A relational database would allow for easy querying, sorting, and accessing of the data, as well as efficient updates and maintenance.

Question 18

Juan is using a file that is created by an older,legacy system.It is likely that the data is:
A)Unusable
B)In a proprietary format
C)In a standard format (like comma separated value)
D)Is sorted by customer's middle name
E)In an object-oriented structure like Ariel

Accepted Answer

It is likely that the data is in a proprietary format because the system is old and legacy. This means that the file may only be readable by the original system or a specific program designed to access its contents.

Question 19

New databases collectively referred to as NoSQL databases have appeared in recent years.Which of the following are categorized as a NoSQL database?
A)Document-oriented database
B)Wide column stores
C)Graph databases
D)Extensible record stores
E)Relational Database system

Accepted Answer

The answer of New databases collectively referred to as NoSQL...

Question 20

Which of the following is not a general function of any application program?
A)Data storage
B)Presentation logic
C)Data access logic
D)Linked-list modules
E)Application logic

Accepted Answer

Linked-list modules are not a general function of any application program. The other choices - data storage, presentation logic, data access logic, and application logic - are all common functions of application programs.

Quiz 11: Data Storage Design

The most popular type of database today is the:

Which of the following is an open source DBMS?

Which is NOT a type of database file?

This type of file is used to update a master file:

Which of the following is a concept not generally associated with decision support systems?

The two basic formats for data storage:

This type of file records "before" and "after" images of data as the data gets altered.

Which of the following is NOT a file type described in the textbook?

The acronym for the standard language used to access data in relational databases is:

Which of the following is not a characteristic of Big Data?

Legacy databases might include and ______

Which of the following is not a RDBMS?

This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists) .

In most cases,decision support systems are best at:

Most relational database systems support:

Document-oriented databases have the following characteristics,except:

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zip code,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

Juan is using a file that is created by an older,legacy system.It is likely that the data is:

New databases collectively referred to as NoSQL databases have appeared in recent years.Which of the following are categorized as a NoSQL database?

Which of the following is not a general function of any application program?