Deck 1: Introduction to Database Management

Question 1

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

Answer 1

C

Question 2

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

Answer 2

True

Question 3

Increased complexity is one advantage of database processing.

Answer 3

False

Question 4

An attribute is known as a row in most databases.

Question 5

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

Question 6

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

Question 7

Which aspect of an entity becomes the columns in the database table?

A) attributes
B) relationships
C) data files
D) E-R diagrams

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

Which of the following is called a field or column in many database systems?

A) attribute
B) entity
C) data file
D) relationship

Question 14

Each table in a database represents two or more entities.

Question 15

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

Question 16

A client is an example of an attribute.

Question 17

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

Question 18

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

Question 19

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

Question 20

Redundancy makes changing data more cumbersome and time-consuming.

Question 21

In an E-R diagram, lines represent _________________________ between connected entities.

Question 22

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

Question 23

In an E-R diagram rectangles represent _________________________.

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?

A) E-R diagrams
B) DBAs
C) data files
D) DBMSs

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

What should an administrator use to more easily assign database access permissions to multiple users?

A) groups
B) classes
C) attributes
D) clusters

Question 36

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

Question 37

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

Question 38

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.

Question 39

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.

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

List the advantages of database processing.

Question 45

Explain why the impact of failure is greater in database processing, compared with the nondatabase approach.

Question 46

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.

Question 47

Discuss how the database approach and the nondatabase approach differ in terms of ensuring the security of the database.

Question 48

Explain why it is better to try to control redundancy rather than eliminate it.

Question 49

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

Question 50

List the disadvantages of database processing.