Live Help (Start Chat)
View Count: 0
Duration: 19 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 17 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 8
The technique used to prevent normalization anomalies is called? 
Options:
  1. Referential integrity constraints
  2. Normalization
  3. Functional dependencies
View Answer/Explanation:
b
Explanation:
Normalization is done using Normal forms to efficiently organize data in a database. There are 5 normal forms. 1NF, 2NF, 3NF, 4NF and 5NF

Question No: 2 of 8
A table in NF should satisfy which of the following options? 
Options:
  1. The table should have at least one candidate key
  2. A column should not have more than one value
  3. There can be no duplicate rows
View Answer/Explanation:
a b c
Explanation:

Question No: 3 of 8
Which of the following options describe 2NF? 
Options:
  1. There are no partial dependencies.
  2. All non-prime attributes should fully be dependent on one of the candidate keys
  3. It deals with foreign keys
View Answer/Explanation:
a b c
Explanation:

Question No: 4 of 8
A table in 3NF should satisfy which of the following option? 
Options:
  1. There are no transitive dependencies
  2. All the columns are dependent on the primary key
  3. It should be in 2NF
View Answer/Explanation:
a b c
Explanation:

Question No: 5 of 8
If a table is in 2NF then all its non key attributes should be dependent on every part of the primary key 
Options:
  1. true
  2. false
View Answer/Explanation:
a
Explanation:

Question No: 6 of 8
If a table is in 3NF then there should be no non key attribute that is dependent on another non key attribute 
Options:
  1. true
  2. false
View Answer/Explanation:
a
Explanation:

Question No: 7 of 8
A highly normalized database slows the database performance 
Options:
  1. true
  2. false
View Answer/Explanation:
a
Explanation:

Question No: 8 of 8
What are the advantages of normalization? 
Options:
  1. It removes database redundancy
  2. It improves storage efficiency
  3. It enforces referential integrity
  4. It allows for better security control
View Answer/Explanation:
a b c d
Explanation:

  1