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

Kiran Choudhary

Community Contributor

Quizzes Created: 1 | Total Attempts: 835

Questions: 10 | Attempts: 835 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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:

1
0
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:

1
4 0
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:

1
4 0
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:

1
0
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:

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, 2023

Quiz Edited by
ProProfs Editorial Team
Apr 15, 2020

Quiz Created by
Kiran Choudhary

Database Basic Knowledge Quiz! Trivia

In ERD, the rectangles are used to?

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

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

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

A________ relationship exists when three entities are associated.

An ER Diagram is an example of a physical schema?

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

Data and Information are indistinguishable terms.

An ER diagram consists of entities and resources.

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