An Informative Quiz On Database Management.
-
An ________ is anything about which the organization wants to collect and store information.
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.
(168).jpg "An Informative Quiz On Database Management. - Quiz")
Quiz Preview
- 2.
_______ are the various business activities about which management wants to collect information for planning or control purposes.
- 3.
One of the basic type of Entities that have economic value to the organization is called a ?
-
Agents
-
Event
-
Resource
-
Diagram Variation
Correct Answer
A. 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.
-
Events
-
Resources
-
Agents
-
Attribute
Correct Answer
A. Agents -
- 5.
Which of the following statements about the REA data model is true
-
Every event must be linked to at least 2 agents
-
Every resource must be linked to at least two agents
-
Every agent must be linked to at least two events
Correct Answer
A. Every event must be linked to at least 2 agents -
- 6.
Every event entity must be linked to at least
-
One resource entity, one other event entity , and at least two participating agents
-
One event entity and at least two participating agents
-
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.
What is known as a graphical technique for portraying a data base schema?
-
Data modeling
-
System Analysis
-
Entity- relationship diagram
-
DBMS
Correct Answer
A. Entity- relationship diagram -
- 8.
Accounts receivable would appear in an REA diagram as a example of which kind of entity?
-
Resource
-
Event
-
Agent
-
None
Correct Answer
A. NoneExplanation
accounts receivable would not appear as an entity in an rea diagram because it represents the difference between two eventsRate this question:
-
- 9.
In most cases, the relationship between agent entities and event entities is
-
1:1
-
1:N
-
M:N
-
0:N
Correct Answer
A. 1:1Explanation
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.
Data modeling occurs during which stages of database design?
-
System analysis and physical design
-
System analysis and conceptual design
-
Conceptual design and implementation and conversion
-
Phsical design and implementation and conversion
Correct Answer
A. System analysis and conceptual design -
- 11.
Which of the following is not likely to be depicted as an entity in the REA data model?
-
Customers
-
Invoices
-
Sales
-
Delivery trucks
Correct Answer
A. InvoicesExplanation
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 diagramRate this question:
-
- 12.
Which of the following most accurately models the sales of low cost, mass produced items by a retail store.
-
Sales = 0 to many inventory and inventory equals one to many sales
-
Sale= 0 to many inventory and inventory equals 0 to many sales
-
Sale= 1 to many inventory and inventory equals 0 to many sales
-
Sale = o to many inventory and inventory equals 1 to many sales
Correct Answer
A. Sale= 1 to many inventory and inventory equals 0 to many sales -
Quiz Review Timeline (Updated): Mar 19, 2022 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 19, 2022Quiz Edited by
ProProfs Editorial Team -
Apr 27, 2012Quiz Created by
Marygolddk
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...
Questions:
10 |
Attempts:
1047 |
Last updated:
Mar 21, 2023
|
True / False Exercise -Database Concepts
This True\/False exercise delves into fundamental Database concepts, assessing understanding of object properties, DBMS efficiency, data sharing, query constraints, and uniqueness...
Questions:
5 |
Attempts:
1825 |
Last updated:
Mar 21, 2023
|
Multiple Choice Questions -Database Concepts
This quiz focuses on fundamental database concepts within relational models, including cardinality, schema, and data records, emphasizing data independence and management...
Questions:
15 |
Attempts:
1669 |
Last updated:
Mar 21, 2023
|
Unit 6 Introduction To Databases Part 1
Explore the basics of databases in 'Unit 6 Introduction to Databases Part 1'. This quiz covers data types, data warehouses, queries, database structures, and more, providing...
Questions:
15 |
Attempts:
735 |
Last updated:
Mar 21, 2023
|
Data And Databases Trivia Quiz!
Explore the world of databases with the Data and Databases Trivia Quiz! Test your knowledge on DBMS, metadata, and data structure management. Ideal for learners interested in...
Questions:
15 |
Attempts:
385 |
Last updated:
Mar 21, 2023
|
Database
This Database quiz evaluates understanding of SQL commands and their functionalities, focusing on query complexity, command syntax, and transaction control. It is ideal for...
Questions:
107 |
Attempts:
1253 |
Last updated:
Mar 21, 2023
|
Back to top