Font size
WorksheetsFundamental of Relational Database Quiz
Total questions: 20
Worksheet time: 15mins
What is a database?
D. The computer systems that the database systems runs on
C. The raw facts and information stored in the database
B. A software system that allows users to define, create, maintain and control access to the database
A. A collection of data organized in a manner that allows access, retrieval, and use of that data
What is the purpose of a database system?
A. To keep records of clients, staffs, associates etc
B. To create a computerized database
D. To develop reports
C. To sort and retrieve data
What is a Database Management System (DBMS)?
D. A filing system which each department or area within an organization has its own set of files
A. A software system that allows users to define, create, maintain and control access to the database
B. An organized collection of data stored and accessed electronically
C. The data and the DBMS, along with the applications that are associated with them
What are the disadvantages of using a file processing system?
C. Hard to maintain the security of data and information stored in files
A. Reduce data redundancy
D. Ensure that data is correct for all files
B. Improve data integrity
What are the advantages of using a database system?
D. Originally designed for a limited information in one file
C. Each department in an organization has its own set of files
A. Reduce data redundancy
B. Increase data consistency
What are the components of a database?
A. Data
B. Procedures
C. People
D. Hardware
Software
What is the definition of a file processing system?
D. The raw facts and information stored in the database
B. A collection of data organized in a manner that allows access, retrieval, and use of that data
A. A software system that allows users to define, create, maintain and control access to the database
C. A filing system which each department or area within an organization has its own set of files
What is the main difference between File Processing Systems and Database Systems?
B. Originally designed for a limited information in one file vs Designed to hold much larger collections of organized information in a database
C. Single user or small number of users vs Multiple users at the same time
D. Each department or area within an organization has its own set of files vs Many programs and users share the data in the database
A. Relatively larger amount of data vs Relatively smaller amount of data
What is the purpose of Procedures in a database?
D. The data and the DBMS, along with the applications that are associated with them
C. The computer systems that the database systems runs on
A. The raw facts and information stored in the database
B. The instruction and rules that govern the design and use of database
What is the definition of Hardware in a database?
B. The instruction and rules that govern the design and use of database
A. The raw facts and information stored in the database
D. The data and the DBMS, along with the applications that are associated with them
C. The computer systems that the database systems runs on
What is the definition of Software in a database?
D. The DBMS software and the database application including OS and network software
C. The computer systems that the database systems runs on
B. The instruction and rules that govern the design and use of database
A. The raw facts and information stored in the database
What is the main disadvantage of using a database system?
A. Reduce data redundancy
B. Improve data integrity
C. Database systems are complex, difficult, and time consuming to design
D. Ensure that data is correct for all files
What is the main advantage of using a file processing system?
A. Reduce data redundancy
C. Each department in an organization has its own set of files
B. Improve data integrity
D. Originally designed for a limited information in one file
What is the definition of People in a database?
A. The raw facts and information stored in the database
B. The instruction and rules that govern the design and use of database
C. Includes the business analysts, database designers, database analysts, database administrator, application programmers and end-users
D. The data and the DBMS, along with the applications that are associated with them
What is the definition of Data in a database?
A. The raw facts and information stored in the database
D. The data and the DBMS, along with the applications that are associated with them
C. The computer systems that the database systems runs on
B. The instruction and rules that govern the design and use of database
What is a database?
A type of data
A structured collection of data.
A field
A record
this activity supports the storage and manipulate data
data
information
database
database design
DBMS is a collection of programs that enable its users to access databases, manipulate data, reporting /representation of data.
true or false?
true
false
Database sytem
Databyte
Data
