Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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

ID: 645296 • Letter: Q

Question

Question 1

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

          True

            False

Question 2

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

True

False

  

Question 3

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

True

False

  

Question 4

Unary relationships contain one entity type.

True

False

  

Question 5

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

True

False

  

Question 6

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

True

False

  

Question 7

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

True

False

  

Question 8

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

True

False

  

Question 9

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

True

False

  

Question 10

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

True

False

  

Question 11

Data within a database is typically controlled and manipulated by:

A.

MY SQL Workbench

B.

Database Management Software

C.

MS Word

D.

MS Excel

  

Question 12

A unique identifier of an entity is ____

A.

Relationship

B.

Cardinality

C.

Attribute

D.

Binary

  

Question 13

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

  

Question 14

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

A.

Binary

B.

Tertiary

C.

Unary

D.

Secondary

  

Question 15

How many entity types are involved in a tertiary relationship?

A.

1

B.

2

C.

3

D.

4

  

Question 16

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

  

Question 17

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

  

Question 18

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

  

Question 19

Each row of a database is known as a ______

A.

File

B.

Field

C.

Entity

D.

Record

  

Question 20

An entity

A.

MY SQL Workbench

B.

Database Management Software

C.

MS Word

D.

MS Excel

Explanation / Answer

1) true

2) false

3) false(modality is minimum number of occurences involved in a relationship)

4) true

5) true

6) false

7) false

8) true

9) true

10) true

11) b

12) c

13) c

14) c

15) c

16) c

17) f

18) c

19) b

20) b

21) d

22) a

23) c

24) d

25)a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute in a different (or the same) relation (table).

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote