answer 27 questions

profilepzftoresc8h5
exam.docx
Home>Computer Science homework help>answer 27 questions

1. A highly organized collection of data is a database management system.

 True

 False

4 points   

QUESTION 2

1. Financial data residing in a database is not a corporate resource.

 True

 False

4 points   

QUESTION 3

1. Modality is the maximum number of entity occurrences involved in a relationship.

 True

 False

4 points   

QUESTION 4

1. Unary relationships contain one entity type.

 True

 False

4 points   

QUESTION 5

1. In a database, if there is more than one candidate key one MUST be identified as a primary key.

 True

 False

4 points   

QUESTION 6

1. A concurrency problem is defined as multiple data sets stored in the database.

 True

 False

4 points   

QUESTION 7

1. The most significant problem with data redundancy in a database is data integrity.

 True

 False

4 points   

QUESTION 8

1. Data redundancy can result in requiring unnecessary storage space for the database.

 True

 False

4 points   

QUESTION 9

1. Many-many relationships should be converted to associative entities on an Entity-Relationship diagram.

 True

 False

4 points   

QUESTION 10

1. There are two modes of data access known as sequential and direct access.

 True

 False

4 points   

QUESTION 11

1. Data within a database is typically controlled and manipulated by:

A.

MY SQL Workbench

B.

Database Management Software

C.

MS Word

D.

MS Excel

4 points   

QUESTION 12

1. A unique identifier of an entity is ____

A.

Relationship

B.

Cardinality

C.

Attribute

D.

Binary

4 points   

QUESTION 13

1. In an M-M relationship, the combination of or the association between two entities is known as ____

A.

Cardinality

B.

Modality

C.

Associative entity

D.

Intersection data

4 points   

QUESTION 14

1. A ________ relationship associates occurrences of an entity type with other occurrences of the same entity type.

A.

Binary

B.

Tertiary

C.

Unary

D.

Secondary

4 points   

QUESTION 15

1. How many entity types are involved in a tertiary relationship?

A.

1

B.

2

C.

3

D.

4

4 points   

QUESTION 16

1. The means by which an analyst records, documents, and diagrams the business environment is known as ________.

A.

Relationship Identification

B.

Data Association

C.

Data Analysis

D.

Data modeling

4 points   

QUESTION 17

1. In a DBMS, Referential Integrity contains three rules which are:

A.

Restrict

B.

Cascade

C.

Set-to-null

D.

Read

E.

All of the above

F.

A, B, and C

4 points   

QUESTION 18

1. The process of arranging attributes of entities in a given business environment into database structures is known as:

A.

Physical Database design

B.

Database structuring

C.

Logical Database design

D.

Relationship mapping

4 points   

QUESTION 19

1. Each row of a database is known as a ______

A.

File

B.

Field

C.

Entity

D.

Record

4 points   

QUESTION 20

1. An entity’s attribute in a database management system is referred to as a ________.

A.

Record

B.

Relationship

C.

Field

D.

Row

4 points   

QUESTION 21

1. A foreign key is defined as _________.

A.

The key attribute of an entity

B.

An identifier of the relationship

C.

Primary key of an entity

D.

Primary key of a relation that appears in another relation

4 points   

QUESTION 22

1. An attribute or field that uniquely appears in every row of the relation is known as ____.

A.

Key field

B.

Primary Key

C.

Foreign Key

D.

Intersection ID

4 points   

QUESTION 23

1. Each table column in a database entity is commonly known as a ____________.

A.

Record

B.

Relationship

C.

Field

D.

Primary Key

4 points   

QUESTION 24

1. The purpose of a database is to _____________.

A.

Eliminate redundancy

B.

Centralize data

C.

Integrate data logically

D.

All of the above

E.

None of the above

QUESTION 1

1. Describe what is an array. Provide examples and uses in VB & C# languages.

QUESTION 2

1. Explain how to derive New Classes from Base Classes. Provide examples and uses in VB & C# languages.

QUESTION 3

1. Describe classes, including constructors, methods, data, value, and reference types. Provide examples and uses in VB & C# languages.

QUESTION 4

1. Describe delegate types. Provide examples and uses in VB & C# languages.