Featured Quizzes
User Quizzes
Create Quiz
Data and Charts
Word Search
Badges and Games
About JetPunk
Message Board
Dark Mode
Database Design Quiz
Select the right answer
if the title says (multiple) select all the right answers
Rate:
Last updated: August 18, 2020
You have not attempted this quiz yet.
More quiz info >>
| First submitted | August 18, 2020 |
| Times taken | 2,862 |
| Average score | 87.8% |
| Rating | 4.20 | Report this quiz | Report |
10:00
The quiz is paused. You have remaining.
Copied!
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
YES
NO
Question 2 of 12
Select the right answer
To do top down design you can use the following technique
ERD
Normalization
YES
NO
Question 3 of 12
Select the right answer
To do bottom up design you can use the following technique
Normalization
ERD
YES
NO
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?
TOP DOWN
BOTTOM UP
YES
NO
Question 5 of 12
Select the right answer
What does SDLC stand for?
SDLC
Software Determination Logistics Cycle
Software Development Life Cycle
Software Development Loop Core
YES
NO
Question 6 of 12
Select the right answer
What are the phases of the SDLC we discussed? (multiple)
System Volume Analysis
System Logistics
Software Utility Analysis
System Planning and Selection
System Analysis
System Build Velocity
System Design
System Implementation and Operation
YES
NO
Question 7 of 12
Select the right answer
What does normalization try to solve/prevent? (multiple)
Query speed
Hardcoding
Anomalies
Backup encryption
Data corruption
Transaction locking
Duplication
System Failure
YES
NO
Question 8 of 12
Select the right answer
4th 5th and 6th normal forms are essential to a good database model
True
False
YES
NO
Question 9 of 12
Select the right answer
0th normal form has no duplication
True
False
YES
NO
Question 10 of 12
Select the right answer
What are crow's feet?
An attribute constraint
An animal's foot
A way to show a relationship between 2 entities
YES
NO
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
YES
NO
Question 12 of 12
Select the right answer
What are anomalies?
Anomalies are data duplication
Anomalies cause transaction locking
Anomalies are side-effects of having poorly normalized data
Anomalies are a tasty snack
YES
NO
Save Your Stats
Your Next Quiz
For each question, select the numbered tiles which satisfy the statement.
The world map has been split into 16 tiles. Try to correctly guess the tiles that correspond to each question.
In one minute, can you match each set of highlighted countries with the letter they start with?
Can you select the flag of every Asian country? One wrong guess and it's all over!
Comments
No comments yet
New and Popular