Introduction to database systems

What is database?

• Collection of organized data that allows access, retrieval of  that data.
• Collection of organized data that allows access, retrieval, and use of  that data.
• Collection of organized data that allows retrieval, and use of  that data.

Data is

• collection of processed items
• collection of unprocessed items

Information is

• collection of processed data

• collection of unprocessed data

Which is the example of File Based System?

• Using MySQL to find specific data
• Using MS Access to control users access
•  Using spreadsheet software to manage data of employee
• Using OpenOffice.org Base to create new table

Why File Based System become unpopular?

• It causes sync with all the data synchronization
• It causes data redundancy

What is Database Management System?

• A software system that enables users to access to the database.
• A software system that enables users to create  access to the database.
• A software system that enables users to define, create, maintain and control access to the database.
•   A software system that enables users to maintain and control access to the database.

Which of the following is NOT Advantages of DBMS

• Increased data consistency 
• Reduced data redundancy
• Improved data security 
• Increase data isolation

Which of the following is the disadvantages of DBMS?

• Cost of setup of DBMS is relatively cheap
• Database systems are complex
•  Database will not be corrupted
• Database systems are fast to be designed

Which of the following is NOT an example of a database?

• telephone book

• real estate listing

• online library catalog

• DVD

_______ is responsible for the maintenance of operational control.

• Data Administrator (DA)

• Database Administrator (DBA)

• Database Designers (Logical & Physical)

• Application Programmers