Question 1
3 out of 3 points
One preventive measure against an SQL injection is to limit database permissions and
segregate users.
Selected Answer:
True
Question 2
3 out of 3 points
In the ERD below, which entity is a weak entity?
Selected Answer:
VisitDetail
Question 3
3 out of 3 points
Computer-aided software engineering applications that help improve the productivity of
information systems professional working on large projects.
Selected Answer: CASE tools
Question 4
3 out of 3 points
Which of the following is not one of the four phases of database development?
Selected Answer: All of the above are phases of database development
Question 5
3 out of 3 points
A set of related components that work together to accomplish some objective
Selected Answer: System
Question 6
3 out of 3 points
Given the following ERD, which table description below best captures the relationship
between faculty room assignments?
Selected
Answer: RoomAssign(Faculty_ID, Room_Number, Building_Number,
Date_Assigned)
Question 7
3 out of 3 points
Diagonal lines in the corners of rectangles represent what type of entities?
Selected Answer: Weak entities
Question 8
3 out of 3 points
An inference attack is an unintentional data mining technique used in order to analyze patterns
and create forcasts.
Selected Answer:
False
Question 9
3 out of 3 points
Which of the following is not a goal of database development?
Selected Answer: All of the above are goals of database development
Question 10
3 out of 3 points
Model that describes kinds of data and relationships among data
Selected Answer: Data model
Question 11
3 out of 3 points
A named, two-dimensional arrangement of data consisting of a heading part and a body part.
Selected Answer: Table
Question 12
3 out of 3 points
When applying the M-M relationship rule for converting an ERD into a relational table
design, which of the following statements is true?
Selected Answer: a and c.
Question 13
3 out of 3 points
A goal of normalization is to:
Selected Answer: Minimize data redundancy
Question 14
3 out of 3 points
Which of the following statements is not true of information resource management?
Selected
Answer: It is very different and much more challenging than managing the other
physical resources of an organization.
Question 15
3 out of 3 points
A scaled down version of a system, usually implemented quickly and used to clarify
requirements
Selected Answer: Prototype
Question 16
3 out of 3 points
A database description
Selected Answer: Schema
Question 17
3 out of 3 points
Reliable and efficient processing of large volumes of repetitive work. DBMSs ensure that
simultaneous users do not interfere with each other and that failures do not cause lost work.
Selected Answer: Transaction processing
Question 18
3 out of 3 points
Model that describes relationships between events and processes
Selected Answer:
Environment interaction model
Question 19
3 out of 3 points
Which of the following statements is NOT true with respect to the ERD below?
Selected Answer:
An Employee must be assigned to an Appointment
Question 20
3 out of 3 points
With respect to transaction processing, any DBMS should be capable of
Selected Answer: All of the above.
Question 21
3 out of 3 points
Indicate the relationship depicted in the following instance diagram:
Selected Answer:
M-N
Question 22
3 out of 3 points
Activity that produces a table design from an ERD
Selected Answer: Conversion
Question 23
3 out of 3 points
A support position that specializes in managing individuals databases and DBMSs.
Selected Answer: Database administrator
Question 24
3 out of 3 points
A collection of components that support data acquisition, dissemination, maintenance,
retrieval, and formatting.
Selected Answer: DBMS
Question 25
3 out of 3 points
In the ERD below, which entity type could be replaced by a M-N relationship?
Selected Answer:
ProdOrd
Question 26
3 out of 3 points
The Hollywood studio BestFlick wants to have a database designed to have access to the
following information about all the movies it ever produced: title, year released, director,
actors, stuntmen, and “Oscars” awarded. A movie has only one director, but a director can
direct many movies. The same actor can star in various movies, and obviously, movies have
more than one actor. Oscars are awarded to an actor for participation in a movie.
Oscar for best acting would be an attribute of:
Selected Answer: A relationship “Starring-in” between Movie and Actor
Question 27
3 out of 3 points
What does the “C” indicate in the ERD below?
Selected
Answer: Faculty members and administrators are the only types of employees in the
system
Question 28
3 out of 3 points
A language, such as SQL, that allows you to specify the parts of a database to access rather
than to code a complex procedure.
Selected Answer: Non-procedural database language
Question 29
3 out of 3 points
In the ERD below, what type of relationship is depicted?
