An Informative Quiz On Database Management.

Questions

Settings

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

An Informative Quiz On Database Management. - Quiz

Do you know anything about database management? Would you like to try this quiz? Databases are an organized collection of information that is typically stored electronically, and there are many types of database management systems. These include hierarchical databases, network databases, object-oriented databases, graph databases, ER model databases, document databases, and NoSQL databases. If you want to put your knowledge of database management to the test, this quiz can be useful.

Questions and Answers

1.

What is known as a graphical technique for portraying a data base schema?
- A.
  
  Data modeling
- B.
  
  System Analysis
- C.
  
  Entity- relationship diagram
- D.
  
  DBMS
Correct Answer
C. Entity- relationship diagram
2.

An ________ is anything about which the organization wants to collect and store information.

Correct Answer
entity
3.

One of the basic type of Entities that have economic value to the organization is called a ?
- A.
  
  Agents
- B.
  
  Event
- C.
  
  Resource
- D.
  
  Diagram Variation
Correct Answer
C. Resource
4.

One of the basic types of Entities represent the people and organiations that participate in events and about whom information is desired for planning, control, and evaluation purposes.
- A.
  
  Events
- B.
  
  Resources
- C.
  
  Agents
- D.
  
  Attribute
Correct Answer
C. Agents
5.

_______ are the various business activities about which management wants to collect information for planning or control purposes.

Correct Answer
Events
6.

Every event entity must be linked to at least
- A.
  
  One resource entity, one other event entity , and at least two participating agents
- B.
  
  One event entity and at least two participating agents
- C.
  
  Two event entities and at least one participating agent
Correct Answer
A. One resource entity, one other event entity , and at least two participating agents
7.

Accounts receivable would appear in an REA diagram as a example of which kind of entity?
- A.
  
  Resource
- B.
  
  Event
- C.
  
  Agent
- D.
  
  None
Correct Answer
D. None

Explanation
accounts receivable would not appear as an entity in an rea diagram because it represents the difference between two events

Rate this question:
8.

Which of the following is not likely to be depicted as an entity in the REA data model?
- A.
  
  Customers
- B.
  
  Invoices
- C.
  
  Sales
- D.
  
  Delivery trucks
Correct Answer
B. Invoices

Explanation
Invoices- Invoices are paper outputs of a database they do not meet the definition of being either a resource, an event, or an agent, and therefore, are not modeled as an entity in a REA diagram

Rate this question:
9.

In most cases, the relationship between agent entities and event entities is
- A.
  
  1:1
- B.
  
  1:N
- C.
  
  M:N
- D.
  
  0:N
Correct Answer
A. 1:1

Explanation
Each sales transaction is linked to only one payment (no installments) and each payment is linked to only one sales transaction( separate checks)

Rate this question:
10.

Which of the following most accurately models the sales of low cost, mass produced items by a retail store.
- A.
  
  Sales = 0 to many inventory and inventory equals one to many sales
- B.
  
  Sale= 0 to many inventory and inventory equals 0 to many sales
- C.
  
  Sale= 1 to many inventory and inventory equals 0 to many sales
- D.
  
  Sale = o to many inventory and inventory equals 1 to many sales
Correct Answer
C. Sale= 1 to many inventory and inventory equals 0 to many sales
11.

Data modeling occurs during which stages of database design?
- A.
  
  System analysis and physical design
- B.
  
  System analysis and conceptual design
- C.
  
  Conceptual design and implementation and conversion
- D.
  
  Phsical design and implementation and conversion
Correct Answer
B. System analysis and conceptual design
12.

Which of the following statements about the REA data model is true
- A.
  
  Every event must be linked to at least 2 agents
- B.
  
  Every resource must be linked to at least two agents
- C.
  
  Every agent must be linked to at least two events
Correct Answer
A. Every event must be linked to at least 2 agents

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 19, 2022

Quiz Edited by
ProProfs Editorial Team
Apr 27, 2012

Quiz Created by
Marygolddk

An Informative Quiz On Database Management.

What is known as a graphical technique for portraying a data base schema?

An ________ is anything about which the organization wants to collect and store information.

One of the basic type of Entities that have economic value to the organization is called a ?

One of the basic types of Entities represent the people and organiations that participate in events and about whom information is desired for planning, control, and evaluation purposes.

_______ are the various business activities about which management wants to collect information for planning or control purposes.

Every event entity must be linked to at least

Accounts receivable would appear in an REA diagram as a example of which kind of entity?

Which of the following is not likely to be depicted as an entity in the REA data model?

In most cases, the relationship between agent entities and event entities is

Which of the following most accurately models the sales of low cost, mass produced items by a retail store.

Data modeling occurs during which stages of database design?

Which of the following statements about the REA data model is true