Chapter 4 - Quiz

The DBMS language that builds the data dictionary is called A.DDL. B.XBRL. C.DQL. D.DML.

A.DDL.

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a A.local key. B.primary key. C.foreign key. D.secondary key.

C.foreign key.

The central organizing tenant of the file-oriented approach is to store data related to A.a transaction cycle. B.a business division. C.an entity. D.a specific program.

D.a specific program.

A set of interrelated, centrally coordinated data files that are stored with as little data redundancy as possible is called A.an AIS. B.a database. C.a data set. D.a file set.

B.a database.

The text mentions four guidelines for developing a properly structured relational database. Which of the following is not one of these guidelines? A.Each object identified by the primary key must have at least three non-key attributes B.Primary keys cannot be null. C.All non-key attributes must describe the object identified by the primary key D.Every column in a row must be single valued.

A.Each object identified by the primary key must have at least three non-key attributes

Which of the following statements about database systems is (are) true? (Check all that apply.) A.Encourages data sharing B.Increases data inconsistency C.Provides data independence D.Minimizes data redundancy

A.Encourages data sharing C.Provides data independence D.Minimizes data redundancy

An update anomaly can occur if A.an instance of the same data is stored in two or more places in the database. B.a user incorrectly changes a value. C.a data element is deleted and causes the loss of information about a different data element. D.a data element is left out of an update.

A.an instance of the same data is stored in two or more places in the database.

External level schemas A.are where rights are set for individual users. B.are only available to the DBA. C.define the entire database. D.include details about record layouts and definitions.

A.are where rights are set for individual users.

The organization-wide view of the entire database that lists all data elements and the relationships between them is called A.conceptual-level schema. B.subschema. C.internal-level schema. D.external-level schema.

A.conceptual-level schema.

Normalization is the process of ______ A.designing a database to avoid anomalies. B.querying data. C.cleaning data. D.revising incorrect data.

A.designing a database to avoid anomalies.

The referential integrity rule states that A.foreign keys must have values that correspond to the value of a primary key in another table. B.in a two-dimensional table, each row is a unique entity and each column is a field where data are stored. C.a non-null primary key should ensure that every row in a table represents something that can be identified. D.a database table row must contain data about a specific item.

A.foreign keys must have values that correspond to the value of a primary key in another table.

Which of the following statements about data aggregation is (are) true? (Check all that apply.) A.A record usually has more than one field. B.A column in a database table contains multiple attributes of an instance of that entity. C.A file usually has more than one database. D.A database usually has more than one file.

A.A record usually has more than one field. D.A database usually has more than one file.

Which of the following are access rights that can be granted in a subschema? (Check all that apply.) A.Delete B.Edit C.Read D.Update E.Create

A.Delete C.Read D.Update E.Create

The problem of not being able to add records to a database is called A.database anomaly. B.update anomaly. C.insert anomaly. D.delete anomaly.

C.insert anomaly.

Which data structure provides support for analytical processing by storing both detailed and summarized data? A.Data warehouse B.Customer table C.File-oriented data structures D.Online transaction processing database (OLTP)

A.Data warehouse

One of the benefits of using a database is to allow an organization to change its data in one location without concern of affecting its data in another location. This benefit is called A.data redundancy minimization. B.data independence. C.data integration. D.data sharing.

B.data independence.

The data manipulation language ______ A.simplifies report creation and shows items stored in a file, including the order and length of data fields. B.builds the data dictionary, creates the database, describes logical views, and specifies security constraints. C.changes database content, including updates, insertions, and deletions. D.contains powerful, easy-to-use commands that can retrieve, sort, order, and display data.

C.changes database content, including updates, insertions, and deletions.

A schema is defined as a(an) A.organization-wide view of all fields that lists important fields and relationships between them. B.individual user's view of portions of a database. C.description of data elements in a database, relationships among them, and logical model used to organize and describe data. D.low-level view of entire database describing how data are actually stored and accessed.

C.description of data elements in a database, relationships among them, and logical model used to organize and describe data.

The database used for processing current business transactions is called the A.data warehouse. B.data lake. C.online analytical processing database (OLAP). D.online transaction processing database (OLTP).

D.online transaction processing database (OLTP).

The National Butterfly Society maintains a database of all types of butterflies within the United States. One database table will store the butterfly species name and family classification number, with each species uniquely identified by a registration number. A second table will contain butterfly families, uniquely identified by the family classification number, and will be linked to the species table by means of the family classification number. The primary key of the species table is A.registration number. B.species number. C.butterfly number. D.family classification number.

A.registration number.

The database view that allows a sales manager to view all customer information as if stored in a table is called A.the logical view. B.the physical view. C.the custom view. D.the detail view.

A.the logical view.

The logical view of data is: A.Description of data elements in a database, relationships among them, and logical model used to organize and describe data B.Information about the database structure; includes description of each data element C.Way data are arranged and stored in the computer D.How people organize, view, and understand relationships among data items

D.How people organize, view, and understand relationships among data items

In most business environments, who is responsible for coordinating, controlling, and managing the database? A.The CFO B.The database administrator C.The CISO D.The accountants

B.The database administrator

Annie Walker is a sales associate for Drug Co. Annie uses her company issued computer to access Drug Co.'s accounting information system when she travels across the country. She has access to view customer and product information. She also has access that allows her to enter and cancel customer orders. Annie's right to access those portions of Drug Co.'s AIS represents a(n) ________ in the company's database management system. A.internal-level schema. B.external-level schema. C.data dictionary. D.conceptual-level schema.

B.external-level schema.

Mary Grossman has been selling cupcakes for the past few years. She keeps meticulous record of every cupcake that she has ever made and sold. She has also kept records of customers' comments on all her cupcakes. These have been entered into a computerized accounting information system that her accountant refers to as a "data warehouse." Mary is considering rebranding her cupcake business and has asked her accountant to identify the top-selling cupcakes for the past few years. Mary wants her accountant to engage in A.product resource management. B.data exploring. C.product auditing. D.data mining.

D.data mining.