Introduction to Database

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.

Why we need database?

• To store  a particular picture
• To store  a particular text
• To store  a particular collection of data.
• To store  a particular audio

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 type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?

• Database
• Presentation
• Spreadsheet
• Word Processor

Logically related data consists of these EXCEPT

• attributes

• relationships

• entities

• variables

Data Definition Language is used to _______ the DBMS.

• create

• define

• control access

• manage