Section 3 Oracle Acad

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By G.iirina
G
G.iirina
Community Contributor
Quizzes Created: 4 | Total Attempts: 9,038
| Attempts: 2,953
SettingsSettings
Please wait...
  • 1/30 Questions

    A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system.

    • True
    • False
Please wait...
About This Quiz

This quiz in Section 3 of Oracle Acad explores key concepts of database design, including data modeling and business rules. It assesses understanding of procedural and structural rules, the enforcement of business policies, and the significance of data models and ERDs.

Section 3 Oracle Acad - Quiz

Quiz Preview

  • 2. 

    A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their account" is best enforced by:

    • We need to trust our customers and we know they will pay some day.

    • Hiring a programmer to create additional programming code to verify no goods are shipped until the account has been settled in full.

    • Making the payment attribute optional.

    • Making the payment attribute null.

    Correct Answer
    A. Hiring a programmer to create additional programming code to verify no goods are shipped until the account has been settled in full.
    Explanation
    The best way to enforce the business rule of only shipping goods after customers have paid outstanding balances is to hire a programmer to create additional programming code. This code would verify that no goods are shipped until the account has been settled in full. This ensures that the rule is consistently followed and reduces the risk of errors or oversight in the shipping process.

    Rate this question:

  • 3. 

    Data modeling is performed for the following reasons:

    • We do not need data models; we can just start coding right away.

    • We draw an ERD solely to please the users; once completed, The ERD is never referred to again as it serves no purpose in the real world.

    • It helps discussions and reviews.

    • The ERD becomes a blueprint for designing the actual system.

    Correct Answer(s)
    A. It helps discussions and reviews.
    A. The ERD becomes a blueprint for designing the actual system.
    Explanation
    Data modeling is performed for the following reasons: It helps discussions and reviews and the ERD becomes a blueprint for designing the actual system. Data models are not just created to please users temporarily, but they serve as a crucial tool in the development process. They help in clarifying requirements, identifying potential issues, and facilitating communication between stakeholders. Additionally, data models provide a visual representation of the system's structure and relationships, serving as a foundation for designing the actual database and system architecture.

    Rate this question:

  • 4. 

    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

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because data models are visual representations of the data that will be stored in a database. They help users understand the structure and relationships of the data. The data listed on the diagram represents the actual data that can be entered into the database. Any data not listed on the diagram would not be included in the database.

    Rate this question:

  • 5. 

    An ERD is an example of a Physical Model.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    An ERD (Entity-Relationship Diagram) is actually an example of a Conceptual Model, not a Physical Model. A conceptual model focuses on the high-level design and structure of a database, representing the entities, their attributes, and the relationships between them. On the other hand, a physical model deals with the implementation details, such as specific data types, storage formats, and indexing. Therefore, the statement that an ERD is an example of a Physical Model is incorrect.

    Rate this question:

  • 6. 

    Attributes have Instances.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Attributes do not have instances. Instances are the specific values or objects that belong to a particular attribute. For example, if we have an attribute called "color" for a car, the instances of this attribute could be "red," "blue," or "green." Therefore, the statement "Attributes have Instances" is false.

    Rate this question:

  • 7. 

    To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In ER diagrams, a unique identifier is a set of one or more attributes that uniquely identifies an entity. To indicate that an attribute is part of the unique identifier, the "#" symbol is placed in front of it. Therefore, the correct answer is true.

    Rate this question:

  • 8. 

    Which symbol is used to show that a particular attribute is mandatory ?

    • #

    • *

    • &

    • O

    Correct Answer
    A. *
    Explanation
    The symbol "*" is used to show that a particular attribute is mandatory. This symbol is commonly used in various contexts, such as in forms or databases, to indicate that a certain field or information must be filled or provided. It serves as a visual indicator to ensure that essential information is not overlooked or omitted.

    Rate this question:

  • 9. 

    The "Other" subtype is mandatory.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because the "Other" subtype is not mandatory. This means that it is not required or obligatory to have the "Other" subtype.

    Rate this question:

  • 10. 

    All instances of the supertype must be an instance of one of the subtypes.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because in object-oriented programming, a supertype represents a general category or class, while subtypes represent specific categories or classes that inherit or extend the supertype. In this context, the statement means that any instance of the supertype must also be an instance of one of its subtypes. This is because the subtypes inherit or extend the characteristics and behaviors of the supertype, so any instance of the supertype can be treated as an instance of one of its subtypes.

    Rate this question:

  • 11. 

    Entity Boxes are drawn  with 90 degree angles, also known as Hard Boxes.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Entity Boxes are actually drawn with rounded corners, not 90 degree angles. This is because rounded corners are visually more appealing and help to soften the overall appearance of the box. Additionally, rounded corners can also help to prevent any potential injuries from sharp edges. Therefore, the statement that Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes, is false.

    Rate this question:

  • 12. 

    Which of the following is true about subtypes ?

    • One instance of a supertype may belong to 2 subtypes.

    • Subtypes must be mutually exclusive.

    • Subtypes should NOT be exhaustive.

    • Subtypes must NOT be mutually exclusive.

    Correct Answer
    A. Subtypes must be mutually exclusive.
    Explanation
    The correct answer is that subtypes must be mutually exclusive. This means that an instance of a supertype can only belong to one subtype. This is important in order to maintain clarity and avoid confusion in the classification of objects. If a supertype instance could belong to multiple subtypes, it would be difficult to determine the specific characteristics and behaviors associated with that instance. Therefore, ensuring that subtypes are mutually exclusive helps to establish clear and distinct classifications within a system.

    Rate this question:

  • 13. 

    The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs.

    • 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 Primary UID, the second is the Secondary UID, etc.

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

    Correct Answer
    A. Yes, this is the way UID's are named.
    Explanation
    The explanation for the given correct answer is that the statement accurately describes the naming convention for UIDs. According to the statement, the candidate UID chosen to identify an entity is called the Primary UID, while other candidate UIDs are referred to as Secondary UIDs. This implies that there can be multiple UIDs for an entity, but only one of them is considered the primary identifier. Therefore, the answer "Yes, this is the way UID's are named" correctly reflects the information provided in the statement.

    Rate this question:

  • 14. 

    All entities must be given a new artificial UID.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false because not all entities need to be given a new artificial UID. The use of artificial UIDs is a way to uniquely identify entities in a system, but it is not always necessary or applicable to all entities. Some entities may already have unique identifiers, such as natural UIDs or other existing identification systems, which can be used instead. Additionally, there may be cases where entities do not need to be uniquely identified at all. Therefore, it is not true that all entities must be given a new artificial UID.

    Rate this question:

  • 15. 

    There is no limit to how many columns that can make up an entity's UID.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    An entity's UID (Unique Identifier) is a unique value that is used to identify that entity within a database or system. The statement suggests that there is no restriction on the number of columns that can be used to create an entity's UID. This means that the UID can be composed of one or more columns, depending on the requirements of the system. Therefore, the statement is true.

    Rate this question:

  • 16. 

    Which of the following would be a logical constraint when modeling time for a City entity ?

    • Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

    • Cities may change their names and/or country association if the borders of a country change.

    • If you are doing a system for any French City, you would need security clearance.

    • People are born in the city and people die in the city.

    Correct Answer
    A. Cities may change their names and/or country association if the borders of a country change.
    Explanation
    Cities may change their names and/or country association if the borders of a country change. This statement suggests that the name and country association of a city can be affected by changes in the borders of a country. This indicates that the modeling of time for a City entity should take into consideration the possibility of changes in the name and country association of a city, as these can impact the historical and geographical context of the city over time.

    Rate this question:

  • 17. 

    If Audit trail attributes are added to an entity, they must be in the entities they are auditing.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    If Audit trail attributes are added to an entity, it means that the entity will keep a record of any changes made to its data. In order for this audit trail to be effective, the attributes must be present within the entity itself. This allows the entity to capture and store the necessary information about any modifications or actions taken on its data. Therefore, the statement that Audit trail attributes must be in the entities they are auditing is true.

    Rate this question:

  • 18. 

    According to 3rd Normal Form, an attribute must be dependent on its entity's entire unique identifier.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    According to 3rd Normal Form, an attribute does not need to be dependent on its entity's entire unique identifier. In 3rd Normal Form, an attribute should only be dependent on the entity's primary key, not the entire unique identifier. This allows for better organization and avoids redundancy in the database.

    Rate this question:

  • 19. 

    A table is in 3NF if it has met all database requirements for both 1NF and 2NF and transitive dependencies are eliminated.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A table is considered to be in the third normal form (3NF) if it satisfies the requirements of both the first normal form (1NF) and the second normal form (2NF), and if it also eliminates any transitive dependencies. Transitive dependencies occur when a non-key attribute is functionally dependent on another non-key attribute, which is itself dependent on the primary key. By eliminating these transitive dependencies, the table becomes more efficient and easier to maintain. Therefore, the statement "True" is the correct answer.

    Rate this question:

  • 20. 

    When is an Entity in 2nd Normal Form ?

    • When all non-UID attributes are dependent upon the entire UID.

    • When attributes with repeating or multi-values are removed.

    • When no attributes are mutually independent and all are fully dependent on the primary key.

    • None of the them.

    Correct Answer
    A. When all non-UID attributes are dependent upon the entire UID.
    Explanation
    An entity is in 2nd Normal Form when all non-UID attributes are dependent upon the entire UID. This means that every attribute that is not part of the unique identifier (UID) is determined by the entire UID and not by any subset of it. In other words, the values of these non-UID attributes are uniquely identified by the combination of all UID attributes. This ensures that there are no partial dependencies and helps in eliminating redundancy and maintaining data integrity.

    Rate this question:

  • 21. 

    Matrix Diagrams show Optionality and Cardinality of the ERDs they document.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Matrix diagrams do not show optionality and cardinality of the ERDs (Entity Relationship Diagrams) they document. Matrix diagrams are used to represent relationships between different entities or attributes in a tabular format, but they do not provide information about optionality (whether a relationship is mandatory or optional) or cardinality (the number of instances of one entity that can be associated with the instances of another entity).

    Rate this question:

  • 22. 

    Relationship Names are optional.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement "Relationship Names are optional" is false. In a database, relationship names are not optional. A relationship name is a way to identify and describe the connection between two entities in a database. It provides clarity and helps in understanding the purpose and meaning of the relationship. Without relationship names, it would be difficult to interpret and work with the database effectively. Therefore, relationship names are necessary and not optional in a database.

    Rate this question:

  • 23. 

    Matrix Diagrams are used to verify that all relationships have been identified for an ERD.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Matrix diagrams are indeed used to verify that all relationships have been identified for an Entity-Relationship Diagram (ERD). These diagrams provide a visual representation of the relationships between entities and help ensure that all entities are properly connected. By using matrix diagrams, designers can easily identify any missing or incorrect relationships in the ERD, allowing them to make necessary adjustments and ensure the accuracy and completeness of the diagram.

    Rate this question:

  • 24. 

    Matrix Diagrams are developed before the ERD.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Matrix diagrams are typically developed before the Entity Relationship Diagram (ERD) in the context of data modeling. Matrix diagrams are used to identify and analyze relationships between different entities or attributes in a system. They help in understanding the structure and connections within the data. Once the matrix diagram is developed and relationships are defined, it becomes easier to create an ERD that represents the entities, attributes, and their relationships in a visual format. Therefore, it is logical to say that matrix diagrams are developed before the ERD.

    Rate this question:

  • 25. 

    A non-transferable relationship means the detail can be changed to point to a new master.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A non-transferable relationship means that the detail cannot be changed to point to a new master. Therefore, the correct answer is False.

    Rate this question:

  • 26. 

    No parts of an UID are mandatory.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement "No parts of an UID are mandatory" is incorrect. UID stands for Unique Identification Number, which typically consists of multiple parts such as a prefix, a unique identifier, and a checksum. These parts are usually necessary to ensure the uniqueness and integrity of the UID. Therefore, the correct answer is False, as at least some parts of an UID are usually mandatory.

    Rate this question:

  • 27. 

    What do you call the entity created when you resolve a M:M relationship ?

    • Inclusion entity

    • Intersection entity

    • M:M entity

    • Recursive entity

    Correct Answer
    A. Intersection entity
    Explanation
    When resolving a many-to-many (M:M) relationship, an intersection entity is created. This entity serves as a bridge between the two entities involved in the relationship, allowing for a more efficient and organized way to manage the relationship. It helps in capturing and storing the associated data between the two entities, providing a clear representation of the relationship. Therefore, the correct answer is "Intersection entity."

    Rate this question:

  • 28. 

    An arc can also be modeled as Supertype and Subtypes.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    An arc can be modeled as a supertype and subtypes because it can have different variations or types within the overarching category of an arc. For example, an arc can be a circular arc, a parabolic arc, or a hyperbolic arc, each with its own distinct characteristics and properties. By modeling an arc as a supertype and subtypes, it allows for more flexibility and specificity in representing different types of arcs within a system or model.

    Rate this question:

  • 29. 

    Which of the following would best be represented by an arc ?

    • TEACHER (Female, Bob)

    • PARENT (Girl, Bob)

    • DELIVERY ADDRESS (Home, Office)

    • STUDENT (Grade A Student, Average Student)

    Correct Answer
    A. DELIVERY ADDRESS (Home, Office)
    Explanation
    The given options consist of pairs of entities that can be represented by an arc. An arc is typically used to represent a relationship or connection between two entities. In this case, the best representation of an arc would be the DELIVERY ADDRESS (Home, Office) option. This represents the relationship between a delivery address and the locations of home and office. The other options do not involve a clear relationship that can be represented by an arc.

    Rate this question:

  • 30. 

    Which of the following would be good as a Unique Identifier for its Entity ?

    • Personal Identification number for Person

    • Date of birth for Baby

    • Vehicle Registration Number for Car

    • ISBN Number for Book

    Correct Answer(s)
    A. Personal Identification number for Person
    A. Vehicle Registration Number for Car
    A. ISBN Number for Book
    Explanation
    A unique identifier is a value that uniquely identifies each record in a database. In this case, a Personal Identification Number (PIN) for a person, a Vehicle Registration Number for a car, and an ISBN Number for a book can all serve as good unique identifiers for their respective entities. These identifiers are specific to each individual person, car, and book, ensuring that no two entities have the same identifier. Therefore, they can be used to uniquely identify and distinguish each record in their respective databases.

    Rate this question:

Quiz Review Timeline (Updated): Aug 30, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 30, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 13, 2017
    Quiz Created by
    G.iirina

Related Topics

Recent Quizzes

Oracle SQL Fundamentals Quiz! Test Oracle SQL Fundamentals Quiz! Test
A Quiz About Oracle Application Express A Quiz About Oracle Application Express
Oracle Performance Tuning Trivia Quiz! Oracle Performance Tuning Trivia Quiz!
Oracle Data Integrator Test Quiz! Trivia Oracle Data Integrator Test Quiz! Trivia
Can you pass the OBIEE Test? Quiz! Can you pass the OBIEE Test? Quiz!
What Do You Know About Oracle Flexcube? What Do You Know About Oracle Flexcube?
What Do You Know About Oracle Application Integration Architecture? What Do You Know About Oracle Application Integration Architecture?
What Do You Know About Oracle API Gateway? What Do You Know About Oracle API Gateway?
What Do You Know About Oracle Business Activity Monitoring? What Do You Know About Oracle Business Activity Monitoring?

Featured Quizzes

What Is My Ethnicity? Let's Take Ethnicity Quiz What Is My Ethnicity? Let's Take Ethnicity Quiz
Articles Quiz With Answers Articles Quiz With Answers
Introduction to Computer: MCQ Questions With Answers Introduction to Computer: MCQ Questions With Answers
Are You Ready For IQ Quiz: Test Your Intelligence Now Are You Ready For IQ Quiz: Test Your Intelligence Now
Which Sonic Character Are You? Which Sonic Character Are You?
Can You Guess These Asian's Nationality? Can You Guess These Asian's Nationality?
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.