Question 1

Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Accepted Answer

A data warehouse is a large database that is specifically designed to store and manage data required for analysis of historical and current transactions. It typically includes data from multiple sources and is optimized for querying and reporting. A data archive is a storage system for rarely accessed or inactive data, while data mining refers to the process of extracting useful information from large datasets. A data market is a platform for buying and selling data.

Question 2

Which term does a user of a relational database use to refer to a record?

Accepted Answer

A row is also known as a record in a relational database. It represents a single instance of data that is stored in a table.

Question 3

Which term does a user of a relational database use to refer to a file?

Accepted Answer

In a relational database, a table is used to store data and is the equivalent of a file in a non-database system.

Question 4

Which of the following statements is FALSE about relational databases?

Accepted Answer

Applications best suited for relational databases are those whose data can be organized into a two-dimensional table, not three-dimensional. Relational databases consist of tables with rows and columns, so it is not possible to have a three-dimensional table.

Question 5

Which of the following contains data about each file in the database and each field in those files?

Accepted Answer

A data dictionary contains metadata about the structure of a database, including information about each file and each field in those files. A data administrator is a person responsible for managing a database, and a DBA (Database Administrator) is responsible for the installation, configuration, and maintenance of a database management system (DBMS). While a DBMS is responsible for managing the database itself, including storing and retrieving data, it does not necessarily contain information about the structure of the database.

Question 6

What company did Larry Ellison help found?

Accepted Answer

Larry Ellison helped found Oracle, which has become one of the world's largest software companies. He served as CEO of Oracle for many years before transitioning to the role of Executive Chairman and Chief Technology Officer.

Question 7

You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

Accepted Answer

The description matches the relational data model, where data is organized into tables with rows, columns, and each row has a primary key. The relational data model is widely used in modern databases, such as MySQL, PostgreSQL, and Microsoft SQL Server. The other options are not suitable for this description – object-oriented data model is used for modeling object-oriented systems, object-relational is a combination of object-oriented and relational models, and multidimensional is used for analytics and reporting on complex data sets.

Question 8

What involves showing users exactly how they will use the new hardware and software in the system?

Accepted Answer

Training involves showing users how to use the new hardware and software in the system. Converting refers to the process of replacing old systems with the new system. Testing involves checking the new system for bugs and errors. Acceptance refers to the confirmation that the new system meets the requirements and expectations of stakeholders.

Question 9

​What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Accepted Answer

A combination of one or more related characters or bytes is commonly known as a field. It is the smallest unit of data a user accesses in a database or a spreadsheet. Bytes refer to a unit of digital information that consists of eight bits, while data can be any collection of raw facts, measurements, and statistics. ID, on the other hand, is a unique identifier assigned to a specific object or entity. It may not necessarily be the smallest unit of data that a user accesses.

Question 10

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Accepted Answer

A data warehouse is specifically designed to store and manage large amounts of data from various sources, making it easier to perform analysis on the data. It is used for historical and current transactions and is an essential tool for businesses to gain insights into their operations, customers, and markets.

Question 11

What is the term for a feature that has a graphical user interface to assist users with retrieving data?

Accepted Answer

QBE (Query by Example) is a graphical user interface that allows users to retrieve data by specifying a sample in the form of a visual table. Users can input criteria in the cells of the table and the system generates a query based on the example. Compared to traditional SQL, QBE is an easier and more intuitive way for users to interact with databases.

Question 12

Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Accepted Answer

Continuous backup is more expensive because it involves constantly saving data changes, allowing for quick recovery of damaged data.

Question 13

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

Accepted Answer

4GL is a nonprocedural language that allows users and software developers to access data in a database without writing procedural code. 4SL and 4DB are not recognized programming languages, and 4AE does not have any known relevance to database access.

Question 14

For a computer to produce correct information, the data that is input into a database must have integrity.

Accepted Answer

Data integrity refers to the accuracy and consistency of data throughout its entire life cycle. If the data entered into a database is incorrect or incomplete, the resulting information produced by the computer will also be incorrect or incomplete. Therefore, it is essential for data to have integrity to ensure that the information produced is correct.

Question 15

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Accepted Answer

The answer of You create a computer-aided design database that...

Question 16

What is a database that stores data in tables that consist of rows and columns?

Accepted Answer

A relational database stores data in tables that consist of rows and columns, and allows users to interact with the data through structured query language (SQL) queries. OODBs store data as objects, distributed databases are spread across multiple physical locations, and multidimensional databases are designed specifically for complex analytical queries.

Question 17

Which of the following statements is NOT true about multidimensional databases?

Accepted Answer

While some multidimensional databases may use a standard query language, it is not a universal feature. Some proprietary database management systems have their own query languages which are specific to their software.

Question 18

Which of the following statements is NOT true about object-oriented databases (OODBs)?

Accepted Answer

The statement that a voice mail system is an example of a groupware database is not related to the topic of object-oriented databases (OODBs). It is a statement about a specific type of application that may or may not be implemented using an OODB. The other three statements are all true about OODBs.

Question 19

In which of the following databases is the physical location of the server on which it is stored is transparent and often unknown, to the user?

Accepted Answer

In a distributed database, data is stored in multiple locations and the physical location of the server may not be known to the user. This allows for greater flexibility in accessing and managing data, but also requires more complex management and coordination between different sites. OODB (Object-Oriented Database) and Relational databases generally have a fixed physical location for the server, and a market database is not a standard type of database.

Question 20

You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?

Accepted Answer

The answer of You store all of your photographs on...

Quiz 11: Building Solutions

Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Which term does a user of a relational database use to refer to a record?

Which term does a user of a relational database use to refer to a file?

Which of the following statements is FALSE about relational databases?

Which of the following contains data about each file in the database and each field in those files?

What company did Larry Ellison help found?

You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

What involves showing users exactly how they will use the new hardware and software in the system?

What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

What is the term for a feature that has a graphical user interface to assist users with retrieving data?

Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

For a computer to produce correct information, the data that is input into a database must have integrity.

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

What is a database that stores data in tables that consist of rows and columns?

Which of the following statements is NOT true about multidimensional databases?

Which of the following statements is NOT true about object-oriented databases (OODBs) ?

In which of the following databases is the physical location of the server on which it is stored is transparent and often unknown, to the user?

You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?

Quiz 11: Building Solutions

Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Which term does a user of a relational database use to refer to a record?

Which term does a user of a relational database use to refer to a file?

Which of the following statements is FALSE about relational databases?

Which of the following contains data about each file in the database and each field in those files?

What company did Larry Ellison help found?

You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

What involves showing users exactly how they will use the new hardware and software in the system?

​What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

What is the term for a feature that has a graphical user interface to assist users with retrieving data?

Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Which of the following is a nonprocedural language that enables users and software developers to access data in a database?

For a computer to produce correct information, the data that is input into a database must have integrity.

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

What is a database that stores data in tables that consist of rows and columns?

Which of the following statements is NOT true about multidimensional databases?

Which of the following statements is NOT true about object-oriented databases (OODBs) ?

In which of the following databases is the physical location of the server on which it is stored is transparent and often unknown, to the user?

You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?

What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?