M1 CHAPTER 1 - FUNDAMENTALS OF DATABASE MANAGEMENT SYSTE

What is 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

Identify the most suitable example of data.

• Student

• Lecturer_Name

• Car

• Perlis

Identify the activity that can be done in requirement analysis.

• Design database

• Conduct Survey

• Developing Database

• Implementing Database

Choose the CORRECT statement that describe about INTEGRITY as properties of databases.

• Ensures that users can access the data they want

• Ensures that data is both consistent (no contradictory data) and correct (no invalid data)

• Ensures that a database can evolve to satisfy changing user requirements.

• Ensures that users do not have unduly long response times when accessing data.

Identify the CORRECT definition for database management system.

• A software for creating and managing databases

• A process that manage how and where data is stored in a storage disk

• A technique used to define and organize business processes

• An organized collection of data stored and accessed electronically from a computer system

Select the CORRECT software used for Database Management System.

• ORACLE

• RDBUS

• DBUSE

• REDHAT

Choose the level in the three-schema architecture that shows different views of a database to different users.

• Internal level

• External level

• Database level

• Conceptual level

Choose the level in three-schema architecture that describe the structures and constraints for the whole database to user

• Internal level

• External level

• Conceptual level

• Database level

Choose the CORRECT two categories of DBMS.

i. Application Database

ii. Server Database

iii. Desktop Database

iv. Cloud Database

• i, ii

• i, iii

• ii, iii

• iii, iv

This database architecture physically confined to a single location.

Based on above statement, choose the CORRECT generic database architecture.

• Centralized

• Distributed