What should you think about when creating a database Choose all correct answers

1. A database interacts with the data and provides the following facilities: Mark for Review
(1) Points

Retrieving

Inserting

Both (*)

Neither

Correct

2. A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying, and deleting the data when required. Mark for Review
(1) Points

True (*)

False

Correct

3. Physical data modeling is the examination of a business and business data in order to determine the structure of business information and the rules that govern it. Mark for Review
(1) Points

True

False (*)

Correct

4. The advantages of object-oriented data model are: Mark for Review
(1) Points

Reduced Maintenance

Real-World Modeling

Both (*)

None

Correct

5. A relational model describes a database in terms of tables, columns, and joins between tables. Mark for Review
(1) Points

True (*)

False

Correct

6. Business rules are used to understand business processes, and the nature, role, and scope of the data. Mark for Review
(1) Points

True (*)

False

Correct

7. All Business Rules can be modeled. Mark for Review
(1) Points

True (*)

False

Incorrect. Refer to Section 1 Lesson 6.

8. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. Mark for Review
(1) Points

True (*)

False

Correct

9. The Oracle Database stores data logically in tablespaces, and physically in datafiles associated with the corresponding tablespace. Mark for Review
(1) Points

True (*)

False

Correct

10. Each database has one unique control file, although it may maintain identical copies of it. Mark for Review
(1) Points

True (*)

False

Correct

11. By defining primary and foreign keys, you can ensure that the integrity of the data in a table is maintained. Mark for Review
(1) Points

True (*)

False

Correct

12. A table is a collection of records. Mark for Review
(1) Points

True (*)

False

Correct

13. The main subject areas taught by the Oracle Academy are: Mark for Review
(1) Points

Computer Repairs

Data Modeling, SQL, and PL/SQL (*)

Database performance tuning

Systems programming and computer architecture

Correct

Section 2
(Answer all questions in this section)

14. Entity names are always plural. Mark for Review
(1) Points

True

False (*)

Correct

15. An ERD is an example of a Physical Model. True or False? Mark for Review
(1) Points

True

False (*)

Correct

16. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review
(1) Points

An entity-relation data model

External data model

Logical data model (*)

Internal data model

Correct

17. A barred relationship is mapped to a primary-key column on the many side, just like any other M:1 relationship. Mark for Review
(1) Points

True

False (*)

Correct

18. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review
(1) Points

True

False (*)

Correct

19. Unique Identifiers: Mark for Review
(1) Points

Distinguish one entity from another.

Distinguish one instance of an entity from all other instances of that entity (*)

Distinguish all entities in a database

Distinguish nothing

Correct

20. Primary Key can contain null values. Mark for Review
(1) Points

True

False (*)

Correct

21. The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________. Mark for Review
(1) Points

Foreign keys, Primary keys

Primary keys, Foreign keys (*)

Foreign keys, mandatory business rules

Unique Keys, Primary keys

Correct

22. Attributes become tables in a database. True or False? Mark for Review
(1) Points

True

False (*)

Correct

23. Entities are usually verbs. True or False? Mark for Review
(1) Points

True

False (*)

Correct

24. Which of the following statements is true? Mark for Review
(1) Points

(Choose all correct answers)

Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers.

Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database.

Relational systems pay more attention to retrieving data and making it accessible to the user.

Both B and C (*)

Correct

25. A flat file database is a type of database that stores data in a multiple tables. Mark for Review
(1) Points

True

False (*)

Correct

26. Each column in a relation is called an entity. True or False? Mark for Review
(1) Points

True

False (*)

Correct

27. Which of the following statements does not apply to relational databases?
(Choose 1) Mark for Review
(1) Points

(Choose all correct answers)

Tables are one of the basic components of relational databases

Relational databases have a strong procedural orientation (*)

Relational databases are simple to understand.

Relational databases have a strong mathematical foundation.

Correct

Section 3
(Answer all questions in this section)

28. Business rules are important to data modelers. True or False? Mark for Review
(1) Points

True (*)

False

Correct

29. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points

Use a supertype

You cannot model this. You need to document it

Make the attribute Gender mandatory

Supertype STUDENT has two subtypes BOY and GIRL which are each related to GENDER which is related to CLASS (*)

Correct

30. Can all constraints be modeled on an ER diagram? Mark for Review
(1) Points

No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)

No, but you just explain them to the users so they can enforce them

No, in which case you should let the database administrator handle them

Yes, all constraints must be modeled and shown on the ER diagram

Correct

26. Each column in a relation is called an entity. True or False? Mark for Review
(1) Points

True

False (*)

Correct

27. Which of the following statements does not apply to relational databases?
(Choose 1) Mark for Review
(1) Points

(Choose all correct answers)

Tables are one of the basic components of relational databases

Relational databases have a strong procedural orientation (*)

Relational databases are simple to understand.

Relational databases have a strong mathematical foundation.

Correct

Section 3
(Answer all questions in this section)

28. Business rules are important to data modelers. True or False? Mark for Review
(1) Points

True (*)

False

Correct

29. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review
(1) Points

Use a supertype

You cannot model this. You need to document it

Make the attribute Gender mandatory

Supertype STUDENT has two subtypes BOY and GIRL which are each related to GENDER which is related to CLASS (*)

Correct

30. Can all constraints be modeled on an ER diagram? Mark for Review
(1) Points

No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)

No, but you just explain them to the users so they can enforce them

No, in which case you should let the database administrator handle them

Yes, all constraints must be modeled and shown on the ER diagram

Correct

31. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points

True

False (*)

Correct

32. The “Other” subtype is mandatory. True or False? Mark for Review
(1) Points

True

False (*)

Correct

33. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review
(1) Points

True (*)

False

Correct

34. Age is a Non-volatile attribute. True or False. Mark for Review
(1) Points

True

False (*)

Correct

35. To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False? Mark for Review
(1) Points

True (*)

False

Correct

36. An arc can also be modeled as Supertype and Subtypes. True or False? Mark for Review
(1) Points

True (*)

False

Correct

37. Which of the following would best be represented by an arc? Mark for Review
(1) Points

PARENT (Girl, Bob)

STUDENT (Grade A student, Average Student)

TEACHER (Female, Bob)

DELIVERY ADDRESS (Home, Office) (*)

Correct

38. Primary UIDs are: Mark for Review
(1) Points

Useful as an alternative means of identifying instances of an entity, independent of their datatype

Mandatory in data modeling

Something that each Entity should have, but is not mandatory (*)

Always comprised of numbers

Correct

39. Relationship Cardinality is important. True or False? Mark for Review
(1) Points

True (*)

False

Correct

40. Transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points

True

False (*)

Correct

41. Which of the following are true about Cardinality? (Choose two) Mark for Review
(1) Points

(Choose all correct answers)

Cardinality specifies whether something is required or not.

Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.

Cardinality tells “how many”. (*)

Cardinality specifies only singularity or plurality, but not a specific plural number. (*)

Correct

42. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False? Mark for Review
(1) Points

True

False (*)

Correct

43. Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements. True or False? Mark for Review
(1) Points

True (*)

False

Correct

44. Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False? Mark for Review
(1) Points

True (*)

False

Correct

45. If Audit trail attributes are added to an entity, they must be in the entities they are auditing. True or False? Mark for Review
(1) Points

True (*)

False

Correct

46. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review
(1) Points

True

False (*)

Correct

47. Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? Mark for Review
(1) Points

True (*)

False

Correct

48. Until all attributes are single-valued, the database model is said to be: Mark for Review
(1) Points

in 2nd Normal Form

Not Normalized (*)

Normalized

in 1st Normal Form

Correct

49. All entities must be given a new artificial UID. True or False? Mark for Review
(1) Points

True

False (*)

Correct

50. The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs. Mark for Review
(1) Points

No, it is not possible to have more than one UID for an Entity.

No, each Entity can only have one UID, the secondary one.

Yes, this is the way UID’s are named. (*)

No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.

Correct