Question 1

Queries in Access are utilized by users to enter data into tables and view existing records.

Accepted Answer

Queries in Access are used to search, filter, and manipulate existing data in tables, but not to enter new data. That is done directly in the tables themselves.

Question 2

Classes could be grouped into Resources (R),Entity (E),and Assets (A)in data modeling.

Accepted Answer

False

Question 3

SQL is based on relational algebra and allows a user to query and update the database.

Accepted Answer

SQL is based on relational algebra and provides a way for users to interact with and manipulate the data within the database.

Question 4

Three types of data models used today are: the hierarchical model,the network model and the relational model.

Accepted Answer

These three types of data models are widely used in the field of databases.

Question 5

In a database,while queries allow the user to access,read and report on desired data,the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).

Accepted Answer

Queries can retrieve data, but actual changes to the database are managed by the DBMS.

Question 6

The "Where" SQL clause can be used to link two tables.

Accepted Answer

The "Where" clause can be used to specify a condition that links two tables in a SQL statement.

Question 7

In Access,users can edit database information in reports.

Accepted Answer

Users cannot edit database information in reports in Access. They can only view and print reports. Editing database information can only be done in tables or forms.

Question 8

Which of the following correctly describes the Referential Integrity Rule?

Accepted Answer

The answer of Which of the following correctly describes the...

Question 9

In a hierarchical data model,data elements are related in many-to-many relationships.

Accepted Answer

In a hierarchical data model, data elements are related in a one-to-many relationship, where each parent record can have multiple child records, but each child record can only have one parent record.

Question 10

Which type of data models allows each record to have multiple parent and child records?

Accepted Answer

Only the network model allows each record to have multiple parent and child records. The hierarchical model is limited to one parent and multiple children, while the relational model does not allow for such relationships. Therefore, the best choice is option B, the network model.

Question 11

Which of the following tasks cannot be performed through queries in access?

Accepted Answer

Queries in Access allow for retrieving, displaying, calculating, and sorting data but they cannot be used to enter data into tables. This is typically done through a form or directly in the table itself.

Question 12

In Microsoft Access,we use tables in a database for:

Accepted Answer

The answer of In Microsoft Access,we use tables in a...

Question 13

While hierarchical and network data models require relationships to be formed at the database creation,relational data models can be made up as needed.

Accepted Answer

Relational data models allow for the creation of relationships between data tables dynamically using keys, unlike hierarchical and network models which require predefined relationships.

Question 14

Each attribute in a table can have several names.

Accepted Answer

Each attribute in a table is identified by a unique name to avoid ambiguity.

Question 15

A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations.Which of the following systems is most effective for this application?

Accepted Answer

An enterprise resource planning (ERP) system is the most effective solution for integrating all functional areas within an organization, allowing for information exchange and collaboration among all parties involved in business operations. ERP systems consolidate all business processes into a single system and database. This centralization of information allows for a more efficient and streamlined business operation. A decision support system (A) or executive support system (B) may provide some level of integration and collaboration, but they do not have the same level of functionality or breadth as an ERP system. An office automation system (C) is limited to automating routine office tasks and would not provide the necessary integration and collaboration features required for this scenario.

Question 16

Access offers modules,which are defined by users to automate processes like opening a specific form.

Accepted Answer

The answer of Access offers modules,which are defined by users...

Question 17

The SQL command "Group by" can be used to order an amount in a descending order.

Accepted Answer

The SQL command "Group by" is used to group rows together based on the values of one or more columns. It is not used for ordering data in a descending or ascending order. The command used for ordering data in descending order is "Order by".

Question 18

Access is a simple database management system that can be used to run databases for individuals and small firms.

Accepted Answer

Access is a simple and easy-to-use database management system that is commonly used for personal and small business databases.

Question 19

Cloud computing is an internet-based computing where shared resources,software,and information is provided to firms on demand.

Accepted Answer

Cloud computing is indeed an internet-based computing model where resources such as software and information are shared and provided to users on demand.

Question 20

The asterisk (*)following the SELECT SQL statement is a wild card indicating all columns should be selected.

Accepted Answer

The asterisk (*) in a SELECT statement indicates that all columns should be selected.

Quiz 4: Relational Databases and Enterprise Systems