Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

LIS 3784 > Ch. 1 & Ch. 2 > Flashcards

Ch. 1 & Ch. 2 Flashcards

1
Q

Processed data, or ________, can be used as the foundation for decision making.

a. raw data
b. information
c. queries
d. DP

A

b. information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Accurate, relevant, and timely ________ is the key to good decision making.

a. processing
b. data
c. information
d. relationships

A

c. information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the name for data about data?

a. metadata
b. raw data
c. superdata
d. unique data

A

a. metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Data management is a discipline that focuses on ________.

a. the management of end users
b. the help items to be used by end users
c. the proper generation, storage, and retrieval of data
d. the proper generation, storage, and retrieval of information

A

c. the proper generation, storage, and retrieval of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a benefit of using a DBMS?

a. It helps create an environment for end users to have access to more data.
b. It provides full security to data using private/public key encryption.
c. It provides seamless Internet access to database data.
d. It creates automatic backups.

A

a. It helps create an environment for end users to have access to more data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The ________ receives all application requests and translates them into the complex operations required to fulfill requests.

a. DBMS
b. workgroup
c. DB
d. query

A

a. DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

An ad hoc query is a ________. a. spur of the moment question b. question that will not return any results

c. pre- scheduled question
d. pre-planned question

A

a. spur of the moment question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the name for an answer to a query that the DBMS sends back to the application?

a. query result set
b. DBMS result
c. data result
d. question result

A

a. query result set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A single-user database that runs on a personal computer is called a(n) ________ database. a. workgroup

b. desktop
c. enterprise
d. distributed

A

b. desktop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A database that supports data distributed across several different sites is called a(n) ________ database.

a. workgroup
b. enterprise
c. desktop
d. distributed

A

d. distributed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A ________ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.

a. data warehouse
b. workgroup database
c. production database
d. distributed database

A

a. data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Another name for a production database is a ________ database.

a. development
b. transactional
c. data mining
d. warehouse

A

b. transactional

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.

a. create a new query
b. utilize the Database Wizard c. create a new table
d. create a new form

A

a. create a new query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following products do not provide an enterprise database?

a. MS Access
b. IBM DB2
c. MS SQL Server
d. Oracle RDBMS

A

a. MS Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

The design of a ________ database recognizes the use of historical and aggregated data. a. production

b. data warehouse
c. multiuser
d. single-user

A

b. data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Data processing (DP) specialists are in existence because of ________.

a. the increase in the number of computers
b. the need to speed up processing of data
c. the need to track data and produce required reports
d. the advent of database management systems

A

c. the need to track data and produce required reports

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

A ________ system is composed of software, hardware, data, procedures and people.

a. database
b. computer
c. software
d. file

A

a. database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A record consists of a ________.

a. collection of related records b. set of one or more fields
c. group of files
d. character

A

b. set of one or more fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

All fields for a specific entity can be grouped together as a ________.

a. record
b. file
c. database
d. field

A

a. record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A(n) ________ allows the user to specify what must be done without specifying how it must be done.

a. object-oriented language
b. script
c. procedural language
d. nonprocedural language

A

d. nonprocedural language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data.

a. mining
b. integrity
c. inconsistency
d. independence

A

d. independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Because all data access programs are subject to change when any of the file’s data storage characteristics change (that is, changing the data type), the file system is said to exhibit ________.

a. data dependence
b. logical data format
c. data independence
d. physical data format

A

a. data dependence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

________ independence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.

a. Logical
b. Structural
c. Physical
d. Fragmentation

A

b. Structural

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Data ________ exists when the same data are stored unnecessarily at different places.

a. dependency
b. fragmentation
c. redundancy
d. inconsistency

A

c. redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

A data ________ develops when all of the required changes in the redundant data are not made successfully.

a. anomaly
b. redundancy
c. dependence
d. inconsistency

A

a. anomaly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

________ are the people who use application programs to run the organization’s daily operations.

a. End users
b. Data practitioners
c. Database programmers
d. Managers

A

a. End users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

________ are considered database architects.

a. Systems administrators
b. Database designers
c. Systems analysts and programmers
d. Database administrators

A

b. Database designers

28
Q

Where does the DBMS store the definitions of data elements and their relationships?

a. data file
b. data dictionary
c. data map
d. index

A

b. data dictionary

29
Q

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.

a. development
b. upgrades
c. enhancements
d. tuning

A

d. tuning

30
Q

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.

a. access control
b. security system
c. table generator
d. query language

A

d. query language

31
Q

________ is the de facto query language and data access standard supported by the majority of DBMS vendors. a. Structured Query Language b. 4GL

c. Access Query Language
d. DBMS

A

a. Structured Query Language

32
Q

A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.

a. analysis
b. review
c. footprint
d. blueprint

A

d. blueprint

33
Q

A customer ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.

a. relationship
b. model
c. constraint
d. entity

A

d. entity

34
Q

The basic building blocks of all data models are entities, attributes, relationships, and ________.

a. queries
b. constraints
c. business rules
d. multiples

A

b. constraints

35
Q

What type of relationship is expressed with the phrase “Painter paints Painting”?

a. M:N
b. M:1
c. 1:M
d. 1:1

A

c. 1:M

36
Q

What type of relationship is expressed with the phrase “Employee manages Store”?

a. 1:M
b. 1:1
c. M:N
d. M:1

A

b. 1:1

37
Q

What type of relationship is expressed with the phrase “Student takes Class”?

a. M:N
b. 1:1
c. 1:M
d. M:1

A

a. M:N

38
Q

What is the fastest and most direct source of business rules? a. company documentation

b. a database design document c. interviews with end users
d. the Internet

A

c. interviews with end users

39
Q

A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

a. attribute
b. entity
c. constraint
d. business rule

A

d. business rule

40
Q

As a general rule, a noun in a business rule will translate into a(n) ________ in the model.

a. constraint
b. entity
c. relationship
d. attribute

A

b. entity

41
Q

The hierarchical database model is based on a ________. a. lack of a child segment

b. matrix
c. lack of a parent segment
d. tree structure

A

d. tree structure

42
Q

The hierarchical database model depicts a set of ________ relationships.

a. many-to-one
b. one-to-many
c. many-to-many
d. one-to-one

A

b. one-to-many

43
Q

A ________ is the equivalent of a file system’s record type. a. child

b. parent
c. segment
d. root

A

c. segment

44
Q

Which data model was developed most recently?

a. network model
b. relational
c. XML
d. file system

A

c. XML

45
Q

Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator.

a. subschema
b. data management language c. schema
d. DBTG

A

c. schema

46
Q

A relational database is a collection of ________.

a. field values
b. tables
c. common fields
d. records

A

b. tables

47
Q

A relation is a matrix consisting of a series of row and column ________.

a. intersections
b. models
c. links
d. systems

A

a. intersections

48
Q

One of the advantages of a relational data model is ________.

a. structural dependence
b. easier database design
c. complex database design
d. conceptual complexity

A

b. easier database design

49
Q

For most relational database software, the query language is ________.

a. RDBMS
b. 4GL
c. String Query Language (SQL)
d. Structured Query Language (SQL)

A

d. Structured Query Language (SQL)

50
Q

From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________.

a. relationships between the tables
b. business rules
c. RDBMS
d. SQL engine

A

d. SQL engine

51
Q

Each row in the relational table is known as an entity ________.

a. relationship
b. instance
c. model
d. attribute

A

b. instance

52
Q

How is an entity represented in an ERD?

a. diamond
b. triangle
c. circle
d. rectangle

A

d. rectangle

53
Q

What is the name for the most current (and most used) notation of the ERD?

a. Chen model
b. SQL
c. Crow’s Foot notation
d. Date model

A

c. Crow’s Foot notation

54
Q

In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ________.

a. attribute
b. object
c. entity
d. constraint

A

b. object

55
Q

Classes are organized as a class ________.

a. object
b. system
c. hierarchy
d. method

A

c. hierarchy

56
Q

In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON’s name.

a. interface
b. method
c. inheritance
d. hierarchy

A

b. method

57
Q

The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications.

a. educational
b. personal
c. non-commercial Internet
d. very specialized engineering and scientific

A

d. very specialized engineering and scientific

58
Q

Database models can be grouped into two categories: conceptual models and ________ models.

a. query
b. physical
c. logical
d. implementation

A

d. implementation

59
Q

XML databases have emerged to address the need to manage ________ data within the native XML format.

a. structured
b. relational
c. unstructured
d. object-oriented

A

c. unstructured

60
Q

Data models were developed to ________.

a. allow DBMSs to maintain loose control over the database activities
b. deposit data within a single file
c. model real-world objects or events
d. keep data within multiple data repositories

A

c. model real-world objects or events

61
Q

Which model represents the end users’ view of the data environment?

a. internal
b. conceptual
c. physical
d. external

A

d. external

62
Q

The most widely used conceptual model is the ________ model.

a. OO
b. implementation
c. E-R
d. internal

A

c. E-R

63
Q

The ________ model presents a global view of the entire database.

a. logical
b. conceptual
c. network
d. physical

A

b. conceptual

64
Q

A(n) ________ model is independent of both hardware and software.

a. developmental
b. conceptual
c. external
d. logical

A

b. conceptual

65
Q

Which model operates at the lowest level of abstraction?

a. internal
b. conceptual
c. external
d. physical

A

d. physical

66
Q

Which model is the representation of the database as “seen” by the DBMS?

a. internal
b. conceptual
c. physical
d. external

A

a. internal

LIS 3784 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions