Database Quiz

Which of the following is false?

• Data constitutes the building blocks of information.

• Accurate, relevant, and timely information is the key to good decision making.

• Knowledge is the body of information and facts about specific subject.

• Information is produced by processing knowledge.

Which statement is correct?

• Bad-designed database facilitates data management and generates accurate and valuable information.

• A good designed database can lead to poor decision making, and poor decision making can lead to the failure of an organization.

• Databases cannot be classified according to the number of users supported, where the data is located, the type of data stored, the intended data usage, and the degree to which the data is structured.

• DBMSs were developed to address the file system's inherent strength.

The following are advantages of DBMS except

• Increased end-user productivity

• Improved data sharing

• Improved data access

• Maximized data inconsistency.

Data integrity can also mean the following except

• Data is consistent.

• Data is accurate.

• Data is redundant.

• Data is verifiable

Which anomaly associated to this scenario?
“Fatimah has an email address of [e-mail] in the Users record. Fatimah has the same email address in the Mailing List record. Fatimah decides to change his email preferences, which in turn change the User record for Fatimah. However, the system did not automatically change the Mailing List record, leaving Fatimah with two different associated emails and thus creating inconsistencies within the database.”

• Update anomalies

• Insertion anomalies

• Deletion anomalies

• None of the above

Components of database system include

• Hardware, software, application program and utility software, access, GUI, tuning

• People, tuning, data, utility software

• Procedure, data, GUI, program, cloud

• Hardware, software, people, procedure, data

What is a database?

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

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

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

• None of the above

The following are advantages of DBMS except

• Increased end-user productivity

• Improved data sharing

• Improved data access

• Maximized data inconsistency.

Which DBMS function explain the scenario?

“An enterprise database used by a multinational company. An end user in Malaysia would expect to enter the date May 21, 2021, as “21/05/2021”. In contrast, the same date would be entered in the United States as “05/21/2021”. Regardless of the data presentation format, the DBMS must manage the date in the proper format for each country.”

• Data dictionary management

• Data transformation and presentation

• Data integrity management

• Database communication interfaces

Identify the relationship between entities in the following scenario:

“An airliner can be assigned to fly many flights, but each flight is flown by only one airliner”

• 1 : 1

• 1 : M

• M : N