C175 Practice Test
Multiple Choice
1. The Entity-Relationship (E-R) model is _____.
a. a diagramming technique that describes record structures (i.e.
... [Show More] the fields that make
up the records of a file)
b. an alternative to indexing and hashing as a means for providing direct access in
files
c. a diagramming technique that describes entities, their attributes, and the
relationships between them
d. an alternative to file design in which attributes are used instead of fields
e. a diagramming technique that relates entities to each other, attributes to each
other, and relationships to each other
2. An association between entities is a(n) _____.
a. entity type
b. entity occurence
c. record
d. attribute
e. relationship
3. A binary relationship is a relationship between two _____.
a. entity types
b. attribute types
c. associations
d. files
e. cardinalities
4. The term “binary” in binary relationship indicates that the relationship is between
a. two halves of an entity type
b. two entity types
c. two divisions of an entity’s attributes
d. two attributes
e. two relationships
5. The cardinality of a relationship is _____.
a. The minimum number of entities that can be involved in the relationship.
b. The maximum number of entities that can be involved in the relationship.
c. The minimum number of attributes that can be in the entity types in a relationship.
d. The maximum number of attributes that can be in the entity types in a
relationship.e. The minimum number of associations that can be involved in the relationship.
6. The modality of a relationship is _____.
a. The minimum number of entities that can be involved in the relationship.
b. The maximum number of entities that can be involved in the relationship.
c. The minimum number of attributes that can be in the entity types in a relationship.
d. The maximum number of attributes that can be in the entity types in a
relationship.
e. The minimum number of associations that can be involved in the relationship.
7. A one-to-one binary relationship _____.
a. involves a single entity type
b. involves two entity types
c. allows an occurrence of one entity type to be associated with several occurrences
of another entity type
d. allows an occurrence of one entity type to be associated with several occurrences
of another entity type and vice versa
e. restricts the number of attributes that an entity has
8. A one-to-many binary relationship allows an occurrence of the entity type on the “one
side” of the relationship to be associated with _____.
a. a single occurrence of the same entity type
b. multiple occurrences of the same entity type
c. a single occurrence of the entity type on the “many side” of the relationship
d. multiple occurrences of the entity type on the “many side” of the relationship
e. multiple occurrences of the entity type on the “one side” of the relationship
9. A many-to-many binary relationship allows an occurrence of one entity type to be
associated with _____.
a. a single occurrence of the same entity type
b. multiple occurrences of the same entity type
c. a single occurrence of another entity type
d. multiple occurrences of another entity type
e. multiple occurrences of three entity types
10. A business school’s faculty parking lot has assigned parking spaces. Each professor
is entitled to one parking space. This is an example of a _____ relationship.
a. one-to-one binary
b. one-to-many binary
c. many-to-many binary
d. one-to-one unarye. one-to-many unary
11. Each building on a university campus has several faculty offices. Each professor has
one office. The relationship between campus buildings and professors is a _____
relationship.
a. one-to-one binary
b. one-to-many binary
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
12. In a university, the relationship between courses and their sections can best be
described as a _____ relationship.
a. one-to-one binary
b. one-to-many binary (Because a section can NOT have many courses. Think .xls)
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
13. In a university setting, the relationship between students and the professors who have
been their instructors is a _____ relationship.
a. one-to-one binary
b. one-to-many binary (NOTE: “who have been their instructors”)
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
14. Intersection data _____.
a. is an attribute of the entity on the “one side” of a one-to-many relationship
b. is an attribute of the entity on the “many side” of a one-to-many relationship
c. describes the relationship between two entities in a many-to-many relationship
d. describes one of the entities in a many-to-many relationship
e. describes one of the entities in a ternary relationship
15. Each student at a university takes many courses; each course is taken by many
students. The semester that a student took a course and the grade that the student
received in the course is called _____ data.
a. index
b. key
c. pointer
d. direct accesse. intersection
16. An associative entity is an alternate way of expressing a(n) _____.
a. one-to-one binary relationship
b. one-to-many binary relationship
c. many-to-many binary relationship
d. entity that has no attributes other than the unique identifier or key
e. entity that has no unique identifiers or keys
17. A one-to-one unary relationship _____.
a. involves a single entity type
b. involves two entity types
c. allows an occurrence of one entity type to be associated with several occurrences
of another entity type
d. allows an occurrence of one entity type to be associated with several occurrences
of another entity type and vice versa
e. allows an occurrence of one entity type to be associated with several occurrences
of the same entity type
18. A one-to-many unary relationship allows an occurrence of the entity type on the “one
side” of the relationship to be associated with _____.
a. a single occurrence of the same entity type
b. multiple occurrences of the same entity type
c. a single occurrence of the different entity type on the “many side” of the
relationship
d. multiple occurrences of the different entity type on the “many side” of the
relationship
e. multiple occurrences of the different entity type on the “one side” of the
relationship
19. A many-to-many unary relationship allows an occurrence of one entity type to be
associated with _____.
a. a single occurrence of the same entity type
b. multiple occurrences of the same entity type(e.g. Bill-of-Material,”Component”
as a table)_.
c. a single occurrence of another entity type
d. multiple occurrences of another entity type
e. multiple occurrences of three entity types
20. In a university setting, every professor reports to another professor who is the
department chair. This is a _____ relationship.a. one-to-one binary
b. one-to-many binary
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
21. A single piece of data is _____ the business environment.
a. a fact about (data can be any form, not necessary be a record)
b. a record describing an object in
c. the same thing as an object in
d. a file describing an object in
e. an event in
22. An entity is _____ in the business environment.
a. a fact about an object
b. a record in a file
c. an object or event
d. an attribute
e. a file
23. An attribute is _____.
a. a collection of objects of the same type
b. a characteristic of an entity
c. a record of a file
d. a collection of records of the same type
e. an event
24. Which of the following is the unique identifier of an entity?
a. field
b. key
c. record type
d. record occurrence
e. file
25. Which of the following does not change the contents of a table?
a. retrieve
b. insert
c. delete
d. update
e. all of the above26. All of the following are basic principles of the database concept, except _____.
a. maintaining redundant data that does not cause data integrity problems
b. the ability to store data in a non-redundant fashion
c. the ability to store data representing entities involved in multiple relationships
d. striving to achieve a high degree of data independence
e. data integration
27. All of the following are problems caused by redundant data, except _____.
a. wasted disk space
b. additional processing time for data updates
c. wasted network transmission time
d. potential data integrity problems
e. the possibility of having what should be the same data value in two different files
having different values.
28. Problems caused by two or more users trying to update the same data simultaneously
fall primarily under the heading of _____.
a. computer security
b. backup and recovery
c. concurrency control
d. integration control
e. access control
29. Rebuilding a database after it is destroyed by a natural disaster is an aspect of _____.
a. computer security
b. backup and recovery
c. concurrency control
d. integration control
e. access control
30. When data structures can be modified without affecting the programs that use the
data, we say that the environment is highly _____.
a. secure
b. recoverable
c. data structured
d. data independent
e. data dependent
31. A data definition language (DDL) ____.a. is the same as a data manipulation language
b. is limited to defining the size and type of attributes
c. specifies what tables will be in the database, what attributes will be in the tables,
and which attributes will be indexed
d. specifies the programming language statements that will be used to access the
data in a relational database
e. specifies the operating system parameters that will permit the relational DBMS to
function within its environment
32. A data manipulation language (DML) is capable of ____.
a. inserting new records or rows into a relation
b. deleting records or rows of a relation
c. retrieving data from a relation
d. a and b above
e. a, b, and c above
33. Structured Query Language (SQL) ____.
a. is capable of retrieving data from a relational database
b. is capable of defining the tables, attributes, and indexes of a relational database
c. is a relational DBMS
d. a and b above
e. a, b, and c above
34. The SQL CREATE TABLE command is capable of doing all of the following, except
____.
a. building indexes
b. specifying which attributes are unique
c. specifying which attributes serve as the primary key
d. specifying referential integrity constraints (e.g. cascade)
e. specifying which attributes serve as foreign keys
35. All of the following are SQL commands, except ____.
a. CREATE TABLE
b. CREATE SELECT
c. CREATE INDEX
d. CREATE VIEW
e. DROP TABLE
36. The SQL SELECT command is used to ____ a relational database.
a. retrieve data from
b. update records inc. insert new records into
d. delete records from
e. None of the above.
37. In the SQL SELECT command, the table(s) involved in the query is (are) specified in
the ____ clause.
a. SELECT
b. PROJECT
c. FROM
d. WHERE
e. RETRIEVE
38. In the SQL SELECT command, the attributes to be retrieved are specified in the ____
clause.
a. SELECT
b. PROJECT
c. FROM
d. WHERE
e. RETRIEVE
39. In the SQL SELECT command, the search arguments that limit the rows involved in
the query are specified in the ____ clause.
a. SELECT
b. PROJECT
c. FROM
d. WHERE
e. RETRIEVE
40. The SQL SELECT IN operator ____.
a. involves looking for numeric values and can be used instead of a series of AND
operators
b. involves looking for numeric values and can be used instead of a series of OR
operators
c. involves looking for character strings and can be used instead of a series of AND
operators
d. involves looking for character strings and can be used instead of a series of OR
operators (On text, search for “IN (“)
e. None of the above.
41. The SQL SELECT LIKE operator ____.
a. involves looking for numeric values close to a specified numeric valueb. involves numeric values in between two specified numeric values
c. involves the use of wildcards
d. involves limiting duplicate values in the output of an SQL SELECT command
e. None of the above.
42. The SQL SELECT DISTINCT operator ____.
a. eliminates duplicate rows in the output of an SQL SELECT command
b. eliminates duplicate columns in the output of an SQL SELECT command
c. eliminates duplicate attribute values within a row of the output of an SQL
SELECT command
d. eliminates duplicate attribute values within a column of the output of an SQL
SELECT command
e. None of the above.
43. The SQL SELECT ORDER BY operator ____.
a. groups together rows with identical values of a specified attribute
b. groups together columns with identical values of a specified attribute
c. changes the order of the rows of one of the tables in a Join operation
d. changes the order of the columns of one of the tables in a Join operation
e. None of the above.
(orders them by one or more specified attributes)
44. The SQL SELECT built-in function that adds the values of a specified set of attributes
is ____.
a. COUNT
b. MIN
c. MAX
d. SUM
e. AVG
45. The values of the primary key of a relation ____.
a. cannot be unique
b. may be unique or non-unique
c. must be unique
d. must consist of a single attribute
e. None of the above.
46. A value that is a foreign key in one relation of a database must be ____ another
relation in the database.
a. the primary key of
b. a secondary key ofc. an alternate key of
d. a non-unique attribute or combination of attributes of
e. None of the above.
47. Consider relations X and Y, each representing one of two entities in a many-to-many
binary relationship. Relation Z is the additional relation created to store the many-tomany relationship. Intersection data ____.
a. is stored in relation X or in relation Y, but not in both
b. must be stored in both relations X and Y
c. is stored in relation Z
d. is stored in all three relations X, Y, and Z
e. cannot be stored in any of relations X, Y, or Z [Show Less]