Test
Escoge Capítulo 4
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (30)
1The term “semantic” means:
- Adata
- Bmeaning
- Cattribute
- Ddetailed
- Etrue
2Which of the following is not true of semantic objects?
- Aalways represent physical entities
- Balways provide a sufficient description
- Care always named
- Dalways describe a distinct identity
- Ealways contain a collection of attributes
3Semantic objects are grouped into ____________.
- Acomposites
- Bentities
- Cobjects
- Dclasses
- Eassociations
4When we say a collection of attributes is a “sufficient description”, that means it:
- Acontains all possible attributes of that object
- Bcontains enough attributes that users can distinguish between instances
- Ccontains all the attributes necessary for users to do their work
- Dcontains enough attributes that the developer can implement a table
- Econtains domain specifications for each attribute
5Which type of attribute has a single element?
- Asingle
- Bsimple
- Clink
- Dcompound
- Esemantic
6Which type of attribute is composed of other attributes?
- Asimple
- Bmeta
- Cgroup
- Dcompound
- Ecomposite
7Which of the following refers to an attribute that establishes a relationship between semantic objects?
- Asemantic object attribute
- Bobject attribute
- Cobject link
- Dboth a and b
- Eall of the above
8EMPLOYEE
ID EmployeeNumber 1.1
ID EmployeeName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.N
In the EMPLOYEE semantic object above, what is the minimum cardinality of the attribute PhoneNumber?- Aone
- Bzero
- Ctwo
- Dmany
- Einsufficient information to determine
9Because the semantic object model has no one-way object relationships, object attributes are sometimes called ______________.
- Abinary attributes
- Bdual attributes
- Cpaired attributes
- Dset attributes
- Erelational attributes
10A group identifier:
- Ahas more than one attribute
- Bidentifies a group of instances
- Cidentifies a group of attributes in an object
- Dis the identifier for a group of semantic objects
- Elinks two objects
11STUDENT
ID StudentID 1.1
ID StudentName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.N
StudentAddress
Street 1.1
City 1.1
State 1.1
ZipCode 1.1
0.N
In terms of the STUDENT semantic object above, which of the following is true?- Aa student may have at most one phone number
- Ba student may or may not have a value for zip code
- Ca student must have at least one phone number
- Da student can have at most one Street
- Ea student may or may not have a Student ID
12If a non-identifying simple attribute has a cardinality of _________, the cardinality does not have to be shown in the semantic object diagram.
- AN.M
- B0.1
- C0.N
- D1.1
- E1.N
13STUDENT
ID StudentID 1.1
ID StudentName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.N
StudentAddress
Street 1.1
City 1.1
State 1.1
ZipCode 1.1
0.N
In terms of the STUDENT semantic object above, which of the following is not true?- Aa student must have a student ID
- Ba student must have exactly one last name
- Ca student must have exactly one city
- Da student may not have a phone number
- Ea student may have many phone numbers
14Which of the following is not true about object identifiers?
- Amust be unique
- Busually have a cardinality of 1.1
- Care used by the users to identify object instances
- Dmay be a group attribute
- Eare denoted by “ID” on the semantic object diagram
15EMPLOYEE
ID EmployeeNumber 1.1
ID EmployeeName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.1
VEHICLE
0.1(le falta la mitad en el repaso del 0 y 1)
In terms of the EMPLOYEE semantic object above, what is the maximum number of employees that a vehicle can be associated with?- Aone
- Bzero
- Ctwo
- Dmany
- Einsufficient information to determine
16EMPLOYEE
ID EmployeeNumber 1.1
ID EmployeeName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.1
VEHICLE
0.1- AEmployeeNumber only
- BVehicle only
- CEmployeeNumber and EmployeeName
- DEmployeeNumber and Vehicle
- EEmployeeNumber, EmployeeName, and Vehicle
17Which of the following is not true about attribute domains?
- Aincludes a physical description
- Bmay include an enumerated list
- Cincludes a semantic description
- Dmay include a set of object instances
- Eis not needed for group attributes
18The portion of a semantic object that is visible to a particular application is called a(n) ____________.
- Asemantic object subset
- Bsubtype semantic object
- Csemantic object view
- Dapplication semantic object
- Eprogram object
19Views can be used to:
- Ahelp develop the data model from existing reports
- Bhelp users articulate their data needs
- Crelate data model requirements to management
- Dnormalize a relation
- Eexpress a semantic description of an attribute
20When the value of an attribute is computed from other values, it is said to have a(n) ___________.
- Acomputed domain
- Bapplication view
- Cformula domain
- Dsemantic description
- Eenumerated list
21EMPLOYEE
ID EmployeeNumber 1.1
ID EmployeeName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.1
VEHICLE
0.N
The EMPLOYEE semantic object above is an example of what type of semantic object?- Ahybrid
- Bcomplex
- Ccompound
- Dcomposite
- Esimple
22STUDENT
ID StudentID 1.1
ID StudentName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.N
StudentAddress
Street 1.1
City 1.1
State 1.1
ZipCode 1.1
0.1
The STUDENT semantic object above is an example of what type of semantic object?- Ahybrid
- Bcomplex
- Ccompound
- Dcomposite
- Esimple
23A simple object is a semantic object that contains only _______________.
- Asingle-value, simple or group attributes
- Bsingle-value, object attributes
- Cmulti-value, simple or group attributes
- Dsingle-value, simple attributes
- Esimple attributes
24STUDENT
ID StudentID 1.1
ID StudentName
LastName 1.1
FirstName 1.1
1.1
PhoneNumber 0.N
StudentAddress
Street 1.1
City 1.1
State 1.1
ZipCode 1.1
0.N
The STUDENT semantic object above is an example of what type of semantic object?- Ahybrid
- Bcomplex
- Ccompound
- Dcomposite
- Esimple
25A composite object is a semantic object that contains _______________.
- Asingle-value, simple or group attributes but no object attributes
- Bat least one object attribute
- Cat least one multi-value, simple or group attribute but no object attributes
- Dat least one multi-value, object attribute
- Eat least one group attribute but no object attributes
26A compound object is a semantic object that contains at least one _______________.
- Asingle-value, group attribute
- Bmulti-value, simple or group attribute
- Cobject
- Dmulti-value
- Egroup
27A hybrid object is a semantic object that contains at least one _______________.
- Asingle-value group attribute that includes a multi-value semantic object attribute
- Bsingle-value group attribute that includes a semantic object attribute
- Cmulti-value group attribute and at least one multi-value semantic object attribute
- Dmulti-value group attribute that includes any semantic object attribute
- Ea group attribute and a semantic object attribute
28Which of the following is not true about association objects?
- Aused to relate two or more objects
- Bcan store data that is peculiar to the relationship between objects
- Cmust have two or more object attributes
- Dmay not have a unique identifier of its own
- Ecan not contain multi-value attributes
29Regarding a subtype object:
- Athe first attribute must be the parent attribute
- Bit inherits all of the attributes of its parent
- Cit has a paired attribute in its parent
- Dit can be nested
- Eall of the above
30A version object:
- Amay be a composite object
- Btypically contains the archetype object in its identifier
- Ctypically is a simple object
- Dproduces archetype objects
- Eall of the above
Información
- Descripción
- #Megasparaalola
- Autor
- Angel Perez
- Idioma
- Español
- Visitas
- 5
- Valoración
- Aún sin valoraciones Valora este test