AACS3013 Quick Revision C1-C3

Select the characteristics of the database.

• Lasts longer than the execution of a computer program

• Stores entities and relationships among the entities

• Many people simultaneously use a database

• Only belongs to the person who create it.

Which statements describe the DBMS?

• Ad hoc queries are impossible

• DBMS is a collection of programs that manages database structure and controls access to data

• Possible to share data among multiple applications or users

• Makes data management more efficient and effective

Which types of database below only allow one user to access at a time?

• Multi-user database

• Enterprise Database

• Workgroup Database

• Single-user Database

Which type of database below suitable for small group of users or a single department?

• Multi-user Database

• Single-user Database

• Enterprise Database

• Workgroup Database

Which statements describe the data?

• Data consists of meaningful information.

• Example of data can be text, image, symbols, etc.

• Data refer to raw data which not yet been processed to reveal the meaning.

• Data enables the knowledge creation.

Which statements stated the importance of good database design?

• Defines the database’s expected use

• Different approach needed for different types of databases

• Avoid redundant data (unnecessarily duplicated)

• Prepare for good decision making in future

Which types of database below support multiple user to access at a time?

• Single-user Database

• Multi-user Database

• Enterprise Database

• Workgroup Database

Which statement best describe the modification anomalies?

• Occur when changes must be made to existing records

• Occur when entering new records

• Occur when deleting records

• Occur when updating new records

Select the DBMS functions.

• Data integrity management

• Data dictionary management

• Data storage management

• Data transformation and presentation

• Security management

Which type of database below suitable for large group of users or an entire organisation?

• Single-user database

• Multi-user database

• Enterprise database

• Workgroup database