Database Design Quiz

Select the right answer
if the title says (multiple) select all the right answers
Quiz by mobinni
Rate:
Last updated: August 18, 2020
First submittedAugust 18, 2020
Times taken1,115
Average score90.2%
Report this quizReport
10:00
The quiz is paused. You have remaining.
Scoring
You scored / = %
This beats or equals % of test takers also scored 100%
The average score is
Your high score is
Your fastest time is
Keep scrolling down for answers and more stats ...
Question 1 of 12
Select the right answer
When the client has an existing system the best way to model a database is?
Bottom Up
Top Down
Question 2 of 12
Select the right answer
To do top down design you can use the following technique
ERD
Normalization
Question 3 of 12
Select the right answer
To do bottom up design you can use the following technique
ERD
Normalization
Question 4 of 12
Select the right answer
When a client does not have an existing system or solution yet built, what's the best methodology to come up with a database design?
BOTTOM UP
TOP DOWN
Question 5 of 12
Select the right answer
What does SDLC stand for?
Software Development Life Cycle
Software Determination Logistics Cycle
SDLC
Software Development Loop Core
Question 6 of 12
Select the right answer
What are the phases of the SDLC we discussed? (multiple)
System Analysis
Software Utility Analysis
System Design
System Volume Analysis
System Logistics
System Implementation and Operation
System Build Velocity
System Planning and Selection
Question 7 of 12
Select the right answer
What does normalization try to solve/prevent? (multiple)
Anomalies
System Failure
Data corruption
Transaction locking
Backup encryption
Query speed
Hardcoding
Duplication
Question 8 of 12
Select the right answer
4th 5th and 6th normal forms are essential to a good database model
True
False
Question 9 of 12
Select the right answer
0th normal form has no duplication
False
True
Question 10 of 12
Select the right answer
What are crow's feet?
A way to show a relationship between 2 entities
An animal's foot
An attribute constraint
Question 11 of 12
Select the right answer
What is DRIVEME Academy (multiple)
The best driving school in the USA
The best driving school in the USA
Question 12 of 12
Select the right answer
What are anomalies?
Anomalies cause transaction locking
Anomalies are data duplication
Anomalies are side-effects of having poorly normalized data
Anomalies are a tasty snack
No comments yet