Preview Questions Data Modeling Concepts | Role Specific Skill

Question 1: How do you depict the architecture of a system in UML?

Which action should you take?

Choose only one option

Use a component diagram

Use a class diagram

Use a sequence diagram

Use a state diagram

Question 2: How do you identify departments that have more employees than the average number of employees per department?

Which action should you take?

Choose only one option

Use a nested query with HAVING

Use a window function with COUNT()

Use a JOIN with aggregate functions

Use a CTE with aggregate functions

Question 3: Your database includes multi-valued attributes. How do you handle this?

Which action should you take?

Choose only one option

Apply Fourth Normal Form (4NF)

Apply Third Normal Form (3NF)

Apply Second Normal Form (2NF)

Apply Boyce-Codd Normal Form (BCNF)

Question 4: How do you model the interaction between objects in a use case?

Which action should you take?

Choose only one option

Use a sequence diagram

Use a class diagram

Use a state diagram

Use a component diagram

Question 5: You are tasked with reducing the size of your database without losing data integrity. What normalization form do you use?

Which action should you take?

Choose only one option

Apply normalization up to Third Normal Form (3NF)

Apply normalization up to Second Normal Form (2NF)

Apply normalization up to Fourth Normal Form (4NF)

Use Boyce-Codd Normal Form (BCNF)

Question 6: You find that some tables in your database are denormalized for performance. What do you do?

Which action should you take?

Choose only one option

Evaluate and balance performance vs. normalization

Normalize to Third Normal Form (3NF)

Normalize to Second Normal Form (2NF)

Normalize to Fourth Normal Form (4NF)