Database Basic Knowledge Quiz! Trivia

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Kiran Choudhary
K
Kiran Choudhary
Community Contributor
Quizzes Created: 1 | Total Attempts: 793
Questions: 10 | Attempts: 793

SettingsSettingsSettings
Database Basic Knowledge Quiz! Trivia - Quiz


Here we are with a database basics knowledge quiz. A database is a collection of data that makes it easy to access through a computer system. Databases are broken down into fields containing related data, which pertains to a certain attribute described by the database. By taking this quiz, you will see just how much you know about databases and how they operate.


Questions and Answers
  • 1. 

    In ERD, the rectangles are used to?

    • A.

      Entity Types

    • B.

      Attribute Types

    • C.

      Structure Types

    • D.

      Keys Types

    Correct Answer
    A. Entity Types
    Explanation
    In ERD (Entity Relationship Diagram), rectangles are used to represent entity types. Entity types are the main objects or concepts in a database, such as customers, products, or employees. The rectangles in an ERD visually depict these entity types and their relationships with other entities. They help to define the structure and organization of the database by showing the different entities and how they are related to each other.

    Rate this question:

  • 2. 

    Which of the three schemas used in the three-schema model represents how the user view the database?

    • A.

      Internal

    • B.

      Physical

    • C.

      External

    • D.

      Conceptual

    Correct Answer
    C. External
    Explanation
    The external schema in the three-schema model represents how the user views the database. It defines the user's perspective and includes specific views or subsets of data that are relevant to their needs. This schema allows users to interact with the database without needing to understand its internal structure or physical implementation. It provides a simplified and customized view of the database for different user groups or applications.

    Rate this question:

  • 3. 

    Entities can be associated with one another in which of the following?

    • A.

      Entity

    • B.

      Attribute

    • C.

      Identifier

    • D.

      Relationship

    Correct Answer
    D. Relationship
    Explanation
    Entities can be associated with one another through relationships. Relationships define the connections or associations between different entities in a database. They represent how entities are related or connected to each other. Relationships can be one-to-one, one-to-many, or many-to-many, and they help in organizing and structuring the data in a database. By establishing relationships between entities, it becomes possible to retrieve and manipulate data in a meaningful and efficient manner.

    Rate this question:

  • 4. 

    An ________ attribute need not be physically stored within the database.

    Correct Answer
    Derived
    Explanation
    A derived attribute is a attribute that can be calculated or derived from other attributes in the database. It does not need to be physically stored because its value can be determined by performing calculations or operations on other stored attributes. Therefore, a derived attribute does not require its own physical storage space within the database.

    Rate this question:

  • 5. 

    A________ relationship exists when three entities are associated.

    Correct Answer
    Ternary
    Explanation
    A ternary relationship exists when three entities are associated. This means that there is a relationship between three different entities, rather than just two. In a ternary relationship, each entity is connected to the other two entities in some way. This type of relationship is often represented in a database or data model, where the relationships between entities need to be defined and organized.

    Rate this question:

  • 6. 

    An ER Diagram is an example of a physical schema?

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    An ER Diagram is not an example of a physical schema. ER Diagrams are graphical representations of entities and their relationships in a database, used to design and communicate the logical structure of a database. A physical schema, on the other hand, defines how the data is actually stored and organized on a physical storage medium such as a hard drive or a server.

    Rate this question:

  • 7. 

    A multi-valued attribute is an attribute that is common to many entities. 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    A multi-valued attribute is an attribute that can have multiple values for a single entity. It is not common to many entities, but rather specific to a single entity. Therefore, the statement that a multi-valued attribute is common to many entities is false.

    Rate this question:

  • 8. 

    Data and Information are indistinguishable terms.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Data and information are not indistinguishable terms. Data refers to raw facts, figures, or symbols that have no meaning on their own. Information, on the other hand, is processed and organized data that has meaning and context. In other words, data is the raw material, while information is the result of analyzing and interpreting that data. Therefore, the correct answer is false.

    Rate this question:

  • 9. 

    An ER diagram consists of entities and resources.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    An ER diagram is a visual representation of the entities (objects or concepts) and the relationships between them in a database. It helps to define the structure and organization of the data. Resources, on the other hand, refer to the external elements that are used by the entities, such as files or services. Therefore, the statement that an ER diagram consists of entities and resources is true, as it accurately describes the components included in an ER diagram.

    Rate this question:

  • 10. 

    In Hierarchical DBMS, a parent can have only one child.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    In Hierarchical DBMS, a parent can have multiple children. This is because the hierarchical model allows for a one-to-many relationship between a parent and its children. Each parent can have multiple children, but each child can have only one parent. This structure is similar to a tree, where each node (parent) can have multiple branches (children). Therefore, the statement that a parent can have only one child in a Hierarchical DBMS is incorrect.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.