Database Basic Knowledge Quiz! Trivia
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 TypesExplanation
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. ExternalExplanation
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. RelationshipExplanation
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
DerivedExplanation
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
TernaryExplanation
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. FalseExplanation
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. FalseExplanation
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. FalseExplanation
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. TrueExplanation
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. FalseExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 15, 2020Quiz Created by
Kiran Choudhary
Back to top