M03 Quiz Take 2
pdf
keyboard_arrow_up
School
Ivy Tech Community College, Indianapolis *
*We aren’t endorsed by this school
Course
110
Subject
Information Systems
Date
Feb 20, 2024
Type
Pages
8
Uploaded by MagistrateScorpionPerson5065
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
1/8
M03 Quiz Results for Victoria Lynn Hall (She/Her)
Score for this attempt: 20
out of 20
Submitted Feb 3 at 4:44pm
This attempt took 8 minutes.
1 / 1 pts
Question 1
What are the two states in which backups can be taken
Consistent and inconsistent Correct!
Correct!
Partial and Incremental Restoring and recovery Full and Differential 1 / 1 pts
Question 2
Data Integrity refers to:
Limiting access to the data stored in the database Maintaining the quality of the data stored in the database. Correct!
Correct!
Ensuring the data is updated regularly The current state of the data stored in the database 1 / 1 pts
Question 3
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
2/8
What are the type of participation available in an entity set
relationship?
All Ternary Total Correct!
Correct!
Partial Correct!
Correct!
1 / 1 pts
Question 4
An entity has a set of properties known as attributes.
True Correct!
Correct!
False 1 / 1 pts
Question 5
Using ERD Chen Notation entities are represented using:
Ovals Rectangle Correct!
Correct!
Diamonds Triangles Square
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
3/8
1 / 1 pts
Question 6
The extended version of an ER uses which of the following features:
Attribute inheritance Correct!
Correct!
Generalization Correct!
Correct!
Specialization Correct!
Correct!
Aggregation Correct!
Correct!
1 / 1 pts
Question 7
Data security consist of:
Protection of data Correct!
Correct!
Only the people who should have access to the data are the only ones who
can access the data
Correct!
Correct!
Ensure that data is accessed by its intended user Correct!
Correct!
Prevention of data corruption Correct!
Correct!
Authentication/authorization, encryption, and masking are some of the
popular means of data security
Correct!
Correct!
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
4/8
1 / 1 pts
Question 8
How do you eliminate M:N relationship in a relational database?
Create a Composite Table Correct!
Correct!
Add foreign keys to each table to reference the other table primary key You do not need to eliminate M:N relationship Add additional attributes to the tables in the relationship 1 / 1 pts
Question 9
An Entity Relational Diagram consist of the following components
used to define a database schema
Attributes, constraints, tuples Datafiles, entities, relationship Entities, attributes, relationship Correct!
Correct!
Data model, value, data 1 / 1 pts
Question 10
ERD Notation represents a complete set of work flow shapes &
symbols used in the graphical representation of data.
True Correct!
Correct!
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
5/8
False 1 / 1 pts
Question 11
A composite table:
Is a feature included in the specialization process A table used to link two or more entities participating in a M:N relationship Correct!
Correct!
Consist of a primary key from all the entities in the schema 1 / 1 pts
Question 12
The actual physical backup files are known as:
Transaction logs Full backups Backup files Backupsets Correct!
Correct!
1 / 1 pts
Question 13
An entity whose existence is dependent on another entity is known
as:
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
6/8
Strong Entity Weak Entity Correct!
Correct!
1 / 1 pts
Question 14
Who does the database designer have to interact with to understand
the needs of the application?
IT Manager Database Administrator Domain experts and Users Correct!
Correct!
Programmer 1 / 1 pts
Question 15
An entity is a thing or object in the real world that is distinguishable
from other object.
True Correct!
Correct!
False 1 / 1 pts
Question 16
A relationship is:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
7/8
Identified business rules An association among one or more entities Correct!
Correct!
Attributes that share the same value A set of related business policies 1 / 1 pts
Question 17
Does each DBMS has its own architecture for handling transaction
log files?
Yes Correct!
Correct!
No 1 / 1 pts
Question 18
When designing database schemas we must ensure that we avoid
redundancy and incompleteness.
True Correct!
Correct!
False 1 / 1 pts
Question 19
Specialization is
2/9/24, 11:27 PM
Victoria Lynn Hall (She/Her)'s Quiz History: M03 Quiz
https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355/history?version=2
8/8
the process of designating subgroupings within an entity Correct!
Correct!
the containment relationship that exists between a higher level entity set
and one or more lower level entity set.
1 / 1 pts
Question 20
What are the types of relationships exist within a relational database
design?
Many to Many Correct!
Correct!
Zero to Many One to None One to One Correct!
Correct!
One to Many Correct!
Correct!
Quiz Score: 20
out of 20