Question 1

The raw data necessary to make sound business decisions is stored in a variety of locations and formats.

Accepted Answer

This statement is true. Raw data can be stored in various places such as databases, spreadsheets, reports, and files. It may also come in different formats like CSV, Excel, PDF, XML, and JSON. It is important for businesses to gather, organize, and analyze this data to make informed decisions.

Question 2

The DBMS serves as an interface between an application program and the database.

Accepted Answer

The DBMS (Database Management System) acts as a mediator between an application program and the database by providing a way for the application to access and manipulate the data in the database. This allows the application program to interact with the data in the database without having to know the specifics of how the data is stored and managed.

Question 3

Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.

Accepted Answer

This statement is true. Most organizations do use the database approach to data management, which allows for multiple information systems to share a pool of related data. This approach helps to ensure data consistency and reduces the risk of data duplication or inconsistency.

Question 4

The domain for pay rate would include both positive and negative numbers.

Accepted Answer

Pay rates are typically non-negative, as they represent compensation for work done, and negative pay rates do not make sense in this context.

Question 5

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and data to be organized more logically.

Accepted Answer

Relational databases are designed to allow tables to be linked through relationships based on common data elements. By linking tables, it reduces data redundancy and allows for more efficient data management and organization.

Question 6

A database need not reflect the business processes of the organization.

Accepted Answer

A database is designed to capture and store data that reflects the business processes of the organization. A database that does not reflect the business processes would not be useful or relevant for the organization.

Question 7

Entity-relationship diagrams are a useful database design tool.

Accepted Answer

Entity-relationship diagrams are a visual representation of entities and their relationships to one another, allowing for effective database design. Therefore, they are a useful tool for database designers.

Question 8

Oracle is currently the market leader in general-purpose databases, with about three-quarters of the multibillion-dollar database market.

Accepted Answer

As of the latest data, Oracle is a major player but not the market leader with three-quarters of the market share. Other companies like Microsoft and IBM also hold significant portions of the database market.

Question 9

Identifying who will have access to a database has little impact on organizing a database.

Accepted Answer

Identifying who will have access to a database is a crucial aspect of organizing a database. It helps in defining user roles, setting up user authentication and authorization, and implementing security measures to protect the database from unauthorized access.

Question 10

A record is a collection of fields about a specific object.

Accepted Answer

A record is a collection of fields that contain information about a specific object, such as a person, a product, or an event. Each field represents a piece of data, such as a name, an address, or a date, that describes the object in more detail. Records are commonly used in databases, spreadsheets, and other types of software applications to organize and store data in a structured format.

Question 11

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Accepted Answer

The relational model describes data using tables called relations, which are two-dimensional, not three-dimensional. Each relation is the logical equivalent of a file and is organized into rows and columns.

Question 12

In the relational model, each row of a table represents a data entity or record and each column of the table represents an attribute or field.

Accepted Answer

This statement is true. In the relational model, a table is a collection of rows (also known as tuples or records) and each row represents a single entity in the database. Each column in the table represents a specific attribute or field of that entity.

Question 13

One of the first steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

Accepted Answer

This statement is true. Defining the logical and physical structure of the data and its relationships is part of the database schema design process, which is typically the initial step in creating a new database. This information must be communicated to the DBMS so that it can properly store, organize, and retrieve data as needed by users.

Question 14

Data centres are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a "lights out" environment.

Accepted Answer

With the development of advanced automation technology and Artificial Intelligence, data centres are moving towards a more self-sufficient model where they can operate without the need for human intervention. This is often referred to as a "lights out" environment where the data centre can be monitored and managed remotely.

Question 15

The database administrator decides the contents of the database with little or no input from the users of the database.

Accepted Answer

The database administrator may make decisions regarding the structure and organization of the database, but they should work closely with the users to determine their needs and requirements to ensure that the database effectively fulfills its intended purpose.

Question 16

Database management systems cost in excess of $1,000.

Accepted Answer

The cost of database management systems can vary widely, with some being free or open-source, while others may cost more than $1,000 depending on features and licensing.

Question 17

Business and technology vendors are working to develop blue data centres that run more efficiently and require less energy for processing and cooling.

Accepted Answer

The answer of Business and technology vendors are working to...

Question 18

Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

Accepted Answer

Databases can be stored on servers, which can be smaller and less powerful than mainframe computers.

Question 19

Projecting involves eliminating columns in a table.

Accepted Answer

Projecting involves retaining certain columns in a table and getting rid of the others.

Question 20

Carrying summary totals in the data records is an example of planned data redundancy.

Accepted Answer

Carrying summary totals in the data records is a deliberate and purposeful practice of incorporating redundancy in the data, which is known as planned data redundancy. This redundancy enables faster and easier data analysis and retrieval, especially when dealing with large datasets.

Quiz 5: Database Systems, Data Centres, and Business Intelligence