DB CH1

_________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.

Big data

A client is an example of an attribute.

False

A spreadsheet is a screen object used to maintain and view data from a database.

False

An attribute is known as a row in most databases.

False

Each table in a database represents two or more entities.

False

Increased complexity is one advantage of database processing.

False

Programs created with Visual Basic, Java, Perl, PHP, or C++ can interact with the database directly.

False

There is a greater impact of failure in a nondatabase, file-oriented system.

False

A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.

True

An entity is a person, place, object, event, or idea for which you want to store and process data.

True

Redundancy makes changing data more cumbersome and time-consuming.

True

Redundancy wastes space because you are storing multiple copies of the same data.

True

users never interact with a database directly; database interaction is always through the DBMS.

True

Which of the following statements is correct? a. In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files. b. User data cannot be combined and shared among authorized users. c. Database users should not have access to the same information. d. Controlling redundancy is easier with the nondatabase approach.

a. In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.

Which of the following is considered a disadvantage of a database system? a. a larger file size b. data dependence c. reduced integrity d. reduced productivity

a. a larger file size

Which of the following is called a field or column in many database systems? a. attribute b. entity c. data file d. relationship

a. attribute

Which aspect of an entity becomes the columns in the database table? a. attributes b. relationships c. data files d. E-R diagrams

a. attributes

How does the use of a database facilitate data consistency? a. by controlling redundancy b. by reducing security c. by eliminating integrity constraints d. by providing data independence

a. by controlling redundancy

Which advantage of database processing makes it easier to make a change in the database structure? a. data independence b. integrity constraints c. redundancy control d. security controls

a. data independence

What should an administrator use to more easily assign database access permissions to multiple users? a. groups b. classes c. attributes d. clusters

a. groups

Which of the following are screen objects used to maintain, view, and print data from a database? a. Fields b. Forms c. Data files d. Entities

b. Forms

Which database property lets you change the structure of the database without requiring you to change the programs that access the database? a. database design b. data independence c. integrity constraint d. data dependence

b. data independence

Which type of rule ensures that changes made to the database do not result in a loss of data consistency? a. redundancy constraint b. integrity constraint c. conflict requirement d. security requirement

b. integrity constraint

Which term can be described as the duplication of data and storing it in multiple locations? a. data independence b. redundancy c. data integrity d. security

b. redundancy

In database terms, what is the analogy to an ordinary paper file you might keep in a file cabinet or an accounting ledger? a. database b. spreadsheet c. data file d. attribute

c. data file

During which process does a database expert determine the structure of the required database? a. data security b. database integrity c. database design d. database selection

c. database design

How are multiple entities stored in a database? a. each entity is stored as a row b. each entity is stored as an attribute c. each entity is stored as a table d. each entity is stored as a column

c. each entity is stored as a table

Which database term is a person, place, object, event, or idea for which you want to store and process data? a. attribute b. DBMS c. entity d. DBA

c. entity

What tool can you use to visually represent and analyze a database? a. multi-sheet workbook b. DBMS table identifier c. entity-relationship diagram d. DBA column analyzer

c. entity-relationship diagram

Which factor can mitigate the problems of increased complexity that come with using a DBMS? a. writing complex access rules b. using large file sizes c. sound database design d. using no integrity constraints

c. sound database design

What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server? a. E-R diagrams b. DBAs c. data files d. DBMSs

d. DBMSs

Which of the following is true about big data? a. unstructured big data doesn't contain metadata b. a Twitter tweet is an example of structured big data c. all big data can be handled with traditional DBMS tools d. big data may be structured or unstructured

d. big data may be structured or unstructured

Which advantage of using a DBMS frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data? a. controlling redundancy b. referential integrity c. data independence d. increased productivity

d. increased productivity

A program, or collection of programs, through which users interact with a database is known as a(n)_________________________ management system.

database

In an E-R diagram rectangles represent _________________________.

entities

If a user is authorized to access database data, the user will always be able to make changes to the data.

false

A good DBMS provides data _________________________, which is a property that lets you change the structure of a database without requiring you to change the programs that access the database.

independence

A database file requires a large amount of disk space and internal ____________________.

memory

In a(n) ____________________ relationship between two entities, an entity is associated with multiple other entities such as when a consultant is associated with multiple clients.

one-to-many

The problem of inconsistency in data is a direct result of ____________________.

redundancy

____________________ integrity is a relational database concept stating that table relationships must be consistent and follow integrity constraints.

referential

In an E-R diagram, lines represent

relationships

An advantage of using the database approach to processing is that it facilitates consistency.

true

The relationship between different entities (in different tables) is handled by their common columns.

true

_________________________ data is not organized or easily interpreted by traditional databases or data models.

unstructured