Database Design Chapter1a

What is the full form of DBMS?

• Data of Binary Management System

• Database Management System

• Database Management Service

• Data Backup Management System

What is a database?

• Organized collection of information that cannot be accessed, updated, and managed

• Collection of data or information without organizing

• Organized collection of data or information that can be accessed, updated, and managed

• Organized collection of data that cannot be updated

Which of the following is a function of the DBMS?

• Storing data

• Providing multi-users access control

• Data Integrity

The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.

• Data and the DBMS

• Application and SQL

• Database application and the database

• The user and the software

The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.

• Data and the DBMS

• Application and SQL

• Database application and the database

• The user and the software

Give the importance of database in life

• Uncontrolled data redundancy

• All data are unintegrated

• Unlimited in data sharing

• data inconsistent

Identify the INCORECT descriptions of Properties of Database

• Ensure that users can access the data they want

• Ensure that the data only can accessed and manipulated by one user

• Ensure that the data can be accessed and manipulated in ways which match user requirements

• Ensure that the data is both consistent data and correct and ensures that trust the database

Identiy the CORRECT example of Desktop Database Management System

• DB2

• IBM

• Microsoft Access

• Oracle

Requirement analysis is one of the processes in database development. Identify activity that can be done in requirement analysis

• Design Database

• Conduct user interview

• Developing Database

• Implementing Database

Identify the correct name for database architecture as shown in following Figure

• Multiple hardware

• Centralized

• Disseminated

• Distributed