Database Test 3 Computer Subject

Database Test 3 Computer Subject
Available Sections
2. Career
4. Job
12345

Question 31

An identifier of an entity instance?
Show explanation Expand Question
An identifier must be unique or may be unique to identify an entity instance correctly.
Not clear enough?

Question 32

Which type of identifier is used to identify a set of instances of a given entity?
Show explanation Expand Question
A non-unique identifier is used to identify multiple instances of the same entity type.
Not clear enough?

Question 33

Depending on the system being modeled, a relationship can have entities?
Show explanation Expand Question
A relationship can involve one, two, or more entities depending on the degree of the relationship.
Not clear enough?

Question 34

The degree of a relationship refers to the:
Show explanation Expand Question
The degree of a relationship specifies how many entities participate in it.
Not clear enough?

Question 35

A weak entity is one which _____?
Show explanation Expand Question
A weak entity depends on a strong entity for its existence and cannot exist independently.
Not clear enough?

Question 36

A subtype entity_____?
Show explanation Expand Question
A subtype inherits attributes from the supertype and may contain additional optional attributes.
Not clear enough?

Question 37

Cardinality expresses number of entity occurrences associated with one occurrence of the related entity
Show explanation Expand Question
Cardinality specifies the exact number of entity occurrences that can be associated with another entity occurrence.
Not clear enough?

Question 38

Knowing _____ the number of entity occurrences is very helpful at application software level.
Show explanation Expand Question
Knowing the maximum and minimum cardinalities helps in application logic and database design.
Not clear enough?

Question 39

A _____ attribute need not be physically stored within the database
Show explanation Expand Question
Derived attributes are calculated from other stored attributes and do not need to be physically stored.
Not clear enough?

Question 40

A _____ relationship exists when 3 entities are associated.
Show explanation Expand Question
A ternary relationship involves three entities simultaneously in a relationship.
Not clear enough?

12345
In this page
Database test-3 Computer Subject
Open Model!