Fundamental of Relational Database Quiz

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