Deck 5: Database Processing

Question 1

The most complex type of a relationship is the__________ relationship.

A) N:1
B) N:M
C) 1:1
D) 1:N

Answer 1

N:M

Question 2

A database administrator may be called a(n)__________ .

A) office of database administration
B) DA
C) DAD
D) DBA
E) DB

Answer 2

DBA

Question 3

One example of a popular DBMS is:

A) Excel
B) OEM.
C) Java.
D) SQL Server.
E) )NET.

Answer 3

D

Question 4

An entity has an unique attribute which is known as the:

A) identifier.
B) index field.
C) key attribute.
D) foreign key.

Question 5

_____________is the most popular diagramming tool for database applications.

A) Workflow
B) E- R
C) UML
D) O- O

Question 6

SQL stands for:

A) Standard Query Language.
B) Structured Query Language.
C) Standard Question Language.
D) Simple Query Language.
E) Structured Question Language.

Question 7

_____________is an example of a personal DBMS

A) Access
B) Oracle
C) DB2
D) SQL Server

Question 8

A new information system enables user to perform in new ways, which leads to further changes in the system __________that the users couldn't visualize before.

A) indexes
B) queries
C) reports
D) forms
E) requirements

Question 9

A vertical bar on a line in crow's- foot notation means that there:

A) may be more than one of the entity.
B) might be one of the entity.
C) must be one of the entity.
D) is a mistake...there should not be anything but the crow's feet.

Question 10

Every normalized table has:

A) multiple topics..
B) data integrity problems.
C) a single theme.
D) duplicated data.
E) none of the above.

Question 11

In a relational database, a collection of related records is a(n):

A) file.
B) application.
C) table.
D) kilobyte.
E) field.

Question 12

A(n) ___________ DBMS is designed to process large organizational and workgroup databases.

A) relational
B) object- oriented
C) personal
D) enterprise
E) network

Question 13

A person, place or object would be represented in a database application as a(n):

A) table.
B) record.
C) class.
D) object.
E) entity.

Question 14

Students need to_____________ learn how to data models, because the will be asked which model best captures their world in the future.

A) process
B) update
C) interpret
D) design
E) adapt

Question 15

Databases contain:

A) Metadata.
B) Integrated records.
C) Data.
D) all of the above.
E) none of the above.

Question 16

Bytes are grouped into columns, which are grouped into ______________.

A) bits
B) rows
C) files
D) fields

Question 17

Data entry forms:

A) add, subtract, modify, delete
B) read, insert, modify, delete
C) insert, delete, change, add
D) read, change, add, delete
E) insert, delete, add, subtract

Question 18

__________is used to indicate a many- to- many relationship.

A) 1:M
B) 1:1
C) M:1
D) M:N
E) N:M

Question 19

Sometimes employees such as salespeople prefer not to use the centralized database application because they are unwilling to__________ their data on customer leads and contacts.

A) update
B) query
C) format
D) retrieve
E) share

Question 20

The most important point to keep in mind when debating which data model is the best one is how well it reflects how the view _____________their world.

A) executives
B) users
C) employees
D) data administrators
E) modelers

Question 21

A collection of similar records is called a(n)__________ .

A) database
B) file
C) field
D) relation
E) matrix

Question 22

SQL is a:

A) query language.
B) database system.
C) 3GL.
D) programming language.

Question 23

A(n)__________ diagram is like a blueprint of a database application.

A) Entity- Relationship (E- R)
B) workflow
C) flowchart
D) O- O

Question 24

A group of columns that identify a unique table row is a __________.

A) Record
B) Column
C) Field
D) Database
E) Key

Question 25

UML stands for__________ .

A) Uniform Model Lingo
B) Uniform Modeling Language
C) Uniform Manmade Language
D) Unified Modeling Language
E) Unified Model Lingo

Question 26

MySQL is popular because it is a(n) __________DBMS.

A) personal
B) powerful
C) open- source
D) enterprise
E) work- group

Question 27

A ___________ is the smallest piece of data.

A) byte
B) file
C) field
D) table
E) record

Question 28

__________is a popular enterprise DBMS.

A) Access
B) DB2
C) FoxPro
D) Paradox

Question 29

The __________problem is unique to a multi- user database environment.

A) lost- update
B) security
C) data integrity
D) redundancy

Question 30

A N:M relationship is represented with a(n):

A) linking field.
B) composite table.
C) entity.
D) index field.
E) intersection table.

Question 31

An example of a one- to- many type of relationship might be:

A) an employee can be assigned one and only one computer.
B) an employee is assigned a company car.
C) an employee cannot be assigned a computer.
D) an employee can be assigned more than one computer.

Question 32

In a one- to- many relationship, the foreign key is stored in the table that is on the__________ side of the relationship.

A) one
B) many- to many
C) cardinal
D) many
E) weak

Question 33

If a student is allowed to have multiple majors and advisors are assigned to multiple students, this would be an example of a__________ relationship.

A) N:1
B) 1:1
C) M:N
D) N:M
E) 1:N

Question 34

A(n) ___________ data model captures the entities and their relationships in a database application.

A) workflow
B) flowchart
C) O- O
D) E- R
E) Semantic Object

Question 35

When transforming a data model into a database design, designers represent relationships by:

A) applying attributes.
B) using primary keys.
C) using the entity identifier.
D) using foreign keys.
E) normalizing.

Question 36

In a DBMS, when a user is assigned to a read only role, the user will inherit all the __________that are assigned to that role.

A) applications
B) tables
C) viruses
D) permissions
E) reports

Question 37

The__________ shows the number of entities that can be involved in a relationship.

A) lost- update
B) cardinality
C) E- R
D) UML
E) data integrity

Question 38

__________software assists in creating, maintaining, and manipulating databases.

A) DBMS
B) MIS
C) KMS
D) DBM

Question 39

__________is the process of converting poorly structured tables into two or more well- structured tables.

A) Normalization
B) Conversion
C) Clarification
D) Application development
E) Structuring

Question 40

A(n) ___________ data model captures the entities and their relationships in a database application.

A) Semantic Object
B) workflow
C) flowchart
D) E- R
E) O- O

Question 41

Removing data that is no longer wanted or needed is a task for the__________ _ function.

Question 42

__________level DBMS like DB2 are designed for large, corporate database applications.

Question 43

If the same data element is stored differently in another table, this is said to be an issue of:

A) entity integrity.
B) inaccurate data.
C) data integrity.
D) data redundancy.

Question 44

__________describes the structure of the database.

Question 45

It is very difficult and expensive to go back and change the ___________ once the database application is finished.

Question 46

Database practitioners classify tables into various ___________ depending on the type of data integrity problems to which they might be subject.

A) normal forms
B) types
C) layers
D) categories
E) strata

Question 47

The__________ is responsible for database backup.

A) CEO
B) DBA
C) recovery team
D) steering committee
E) office administrator

Question 48

A __________is in charge of implementing, maintaining, and operating the organization's databases.

Question 49

Constraints on the number of entities are called ___________ cardinalities.

A) restrictive
B) typical
C) maximum
D) minimum
E) constraining

Question 50

Keys of a different table than the one in which they reside are called __________.

Question 51

Forms and reports are usually part of a database__________ .

Question 52

Many users prefer to avoid database applications altogether and simply store their data in a(n):

A) spreadsheet.
B) encrypted table.
C) file.
D) mattress.
E) old can.

Question 53

Query forms use __________to search.

A) keywords
B) content
C) attributes
D) metadata
E) Google

Question 54

___________ is a query language that is portable between all relational DBMSs.

Question 55

A database management system is a ___________ .

A) software program.
B) process.
C) team of people.
D) all of the above.
E) none of the above.

Question 56

Two popular DBMS products from Microsoft are __________and Access.

Question 57

After the data model is created, designers should __________.

A) make no changes
B) make all changes suggested...once created, it cannot be altered
C) have users review it
D) follow it carefully
E) none of the above

Question 58

Changing user requirements leads to a need for ___________ .

A) reports
B) queries
C) adaptations
D) requirements
E) meetings

Question 59

If you are a database administrator, it is likely that your organization has a policy against taking a__________ copy of any application home to practice with.

Question 60

In a relational database, each entity is described by:

A) attributes.
B) data.
C) fields.
D) characters.
E) bytes.

Question 61

The number of entities that can be involved in a relationship in a data model is called the________

Question 62

A__________ is a self- describing collection of integrated records.

Question 63

An E- R data model captures both the entities involved and the ________between the entities.

Question 64

A database is a collection of tables, metadata, and ____________.

Question 65

Databases are considered self- describing because they contain __________.

Question 66

__________of information are represented by individual bytes.

Question 67

A(n) _________ is a characteristic of an entity.

Question 68

In an E- R data model, the crow's feet symbol is used to indicate a________ side of the relationship.

Question 69

When a table contains inaccurate data for the same data elements in a table, it is said that the data in the table lacks __________.

Question 70

A group of similar records is called a________ .

Question 71

________is the second most popular data modeling technique.

Question 72

Database administrators look for the ________between entities.

Question 73

________are associated with only a single entity instance.

Question 74

An easy way to find out what is contained in a database is to look at the ________ .

Question 75

For Kant, the__________world is what really exists "out there".

Question 76

When a database form is processed to add a new record into a table, the DBMS converts the contents of the form into a ________statement.

Question 77

Because database designs are often cumbersome, designers use ________diagrams.

Question 78

Database ________can be specifically limited..

Question 79

A ________is software that is used to create, process, and administer a database.

Question 80

In reality a data model is just a model of a person's ________of what the real world looks like.