Database Section 1 Quiz

The physical implementation of Database is highly dependent on: -Database Manager -The current state of technology -Subject to change as available technologies rapidly change. -All of the above

-All of the above

Select the business or industry that would not have a need for a database. -Banking -Retail -Scientific Research -All these businesses could benefit from using a database.

-All these businesses could benefit from using a database.

Advantages of using a database rather than a simple file system -Availability of data to a diverse group of users -Integration of data for easier access -modification of Data when performing complex transactions -Data integrity and reduced data redundancy

-Availability of data to a diverse group of users -Integration of data for easier access -modification of Data when performing complex transactions -Data integrity and reduced data redundancy

Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. -True. Users never know what they want anyway, so building systems is best left to the professionals. -False. Business requirements can and will change. For instance, new legal requirements may arise. -True. The only requirement for creating a perfect system is a perfect programmer. -True. Users delay the delivery of a system by changing their minds and adding new requirements.

-False. Business requirements can and will change. For instance, new legal requirements may arise.

The reason or drive for using databases rather than files has been (3) -Integration of data for easier access and modification for complex transactions -Use of blocks -Availability of data to a diverse set of users -Reduced redundancy of data

-Integration of data for easier access and modification for complex transactions -Availability of data to a diverse set of users -Reduced redundancy of data

What is the difference between "information" and "data"?

Data turns into useful information. It is stored in a database and accessed by systems and users.

Which of the following transformations in computing led to the increase in graphical user interface (GUI) applications?

Desktop computing

Using a database solution instead of a flat file eliminates all of the following issues except:

Incorrect data

All Business Rules can be modeled. (true/false)

false

In a hierarchical database model the data is stored as records that are connected to one another through ________.

links

A ___________ model describes a database in terms of tables, columns, and joins between tables.

relational

Business ______ are used to understand business processes, and the nature, role, and scope of the data.

rules

A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying, and deleting the data when required. (true/false)

true

A flat file may contain many fields, often, with duplicate data that are prone to data corruption. (true/false)

true

A network database comprises of a collection of records connected to one another through links. (true/false)

true