NEW
Font size
WorksheetsQuiz 1 Introduction To database Concept
Total questions: 20
Worksheet time: 10mins
What is the definition of Database?
Raw facts about something
Collection of logically related data
Graphical tools for developing forms
Allow users to create, update, manages and control access to the database
Which of the following is a primary function of a database management system (DBMS)?
a. Sending emails
b. Playing videos
c. Managing and organizing data
d. Designing graphics
What is a characteristic of the hierarchical model in a database system?
a. Circular relationships
b. Many-to-many relationships
c. Top-down hierarchy
d. No parent-child connections
In a hierarchical database, each node except the root has multiple parents.
True
False
Which of the following is not a type of database?
Hierarchical
Network
Distributed
Decentralized
What is the main purpose of a database management system (DBMS)?
a. Storing and organizing data
b. Playing music
c. Sending text messages
d. Editing photos
Which of the following best describes a database?
a. A collection of unrelated data
b. A tool for creating presentations
c. A system for managing and storing data
d. A platform for playing games
Which of the following is not an example of DBMS?
MySQL
Microsoft Access
IBM DB2
What is the full form of DBMS?
Data of Binary Management System
Database Management System
Database Management Service
Data Backup Management System
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
Why is data integrity necessary?
Prevents data from being accidentally changed from its original value
Avoid data loss
Ensure that there are no errors in data entry
All of the above
The objectives of database management systems include:
Database Integrity
Data Integration
Availability
All
Which of the following is handled by DBMS?
Data security
Data integrity
Data independence
All
Data that causes inconsistency lacks:
Data integrity
Data redundancy
Data anomaly
Good data
Which of the following enables the user to modify data structures Without affecting existing programs that use them?
Data independence
Data dependence
Data relationships
Data Integration
Duplicate data in multiple data files is called_____?
Data Integrity
Data redundancy
Data multiplication
None
What is the advantage of minimizing the data redundancy?
Avoid inaccuracies and inconsistencies in the data
Save Time in processing the data
To free up the storage space
All of the above
The major component of DBMS is called ______?
Database Manager
Data Manager
File Manager
All
Which of the following is related to a component of DBMS known as personnel?
Database administrator
Application programmer
End users
All
Which one of the following is an advantage of database management system approach?
Reduced security and control of the data
Increased duplication Of data
Programs are independent of the data format
All
