Question 1

________ specifies the characteristics of a field, such as the type of data it will hold.

Accepted Answer

A) Data definition 
B) A record 
C) Database architecture 
D) An entity 
A) Data definition 
B) A record 
C) Database architecture 
D) An entity A

Question 2

In Robin Dave Hospital, visiting physicians use different spreadsheets to record the name, address, mobile number, and email of clients. These individual spreadsheets are then compiled by a data-entry operator into one spreadsheet. What type of information does the compiled spreadsheet represent?

Accepted Answer

A) unstructured information 
B) semi-structured information 
C) structured information 
D) secure information 
A) unstructured information 
B) semi-structured information 
C) structured information 
D) secure information B

Question 3

Which database architecture is especially used for managing web content and web-based resources?

Accepted Answer

A) relational database 
B) hierarchical database 
C) object-oriented database 
D) XML database 
A) relational database 
B) hierarchical database 
C) object-oriented database 
D) XML database D

Question 4

Master data management has more to do with technology than people, processes, and governance.

Accepted Answer

A) True 
 B)False

Question 5

What are shadow systems? How do they hinder managers who are looking for company-wide summaries?

Accepted Answer

Shadow systems are smaller databases dev

Question 6

Building interfaces, or bridges, between different databases to link common fields is an integration strategy.

Accepted Answer

A) True 
 B)False

Question 7

In enterprise information management, data ownership issues arise because ________.

Accepted Answer

A) data is often taken from external sources 
B) the quality of data varies across departments 
C) data is often stored in databases on external servers 
D) data is shared by all the stakeholders in the organization 
A) data is often taken from external sources 
B) the quality of data varies across departments 
C) data is often stored in databases on external servers 
D) data is shared by all the stakeholders in the organization

Question 8

Companies often use different relational DBMS for their data warehouse and operational database.

Accepted Answer

A) True 
 B)False

Question 9

When using databases without boundaries ________.

Accepted Answer

A) data is not shared by stakeholders 
B) information is secure and cannot be accessed by people outside the enterprise 
C) enterprises control the distribution of data 
D) contributors feel strong ownership over their records 
A) data is not shared by stakeholders 
B) information is secure and cannot be accessed by people outside the enterprise 
C) enterprises control the distribution of data 
D) contributors feel strong ownership over their records

Question 10

Databases are created and handled using ________.

Accepted Answer

A) database management software 
B) database architecture software 
C) data modeling software 
D) data definition software 
A) database management software 
B) database architecture software 
C) data modeling software 
D) data definition software

Question 11

In comparison with unstructured information, semi-structured information ________.

Accepted Answer

A) is more difficult to break down 
B) has no inherent order 
C) is easier to query and aggregate 
D) is more difficult to link together 
A) is more difficult to break down 
B) has no inherent order 
C) is easier to query and aggregate 
D) is more difficult to link together

Question 12

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

Accepted Answer

A) foreign key 
B) primary key 
C) complex key 
D) functional key 
A) foreign key 
B) primary key 
C) complex key 
D) functional key

Question 13

________ uses statistical techniques to explore a data warehouse and hunt for hidden patterns and relationships that are undetectable in routine reports.

Accepted Answer

A) Data mining 
B) Data extracting 
C) Data modeling 
D) Data normalizing 
A) Data mining 
B) Data extracting 
C) Data modeling 
D) Data normalizing

Question 14

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.

Accepted Answer

A) extraction 
B) transformation 
C) loading 
D) normalization 
A) extraction 
B) transformation 
C) loading 
D) normalization

Question 15

________ ensures that every foreign key entry actually exists as a primary key entry in its main table.

Accepted Answer

A) Scalability 
B) Database schema 
C) Referential integrity 
D) Database integration 
A) Scalability 
B) Database schema 
C) Referential integrity 
D) Database integration

Question 16

A separate file processing system leads to the creation of redundant information because ________.

Accepted Answer

A) it does not allow changes to be made to existing file structures 
B) computer programs create a fresh record for each task 
C) each set of computer programs operates on its own records 
D) different sets of computer programs process files in a similar manner 
A) it does not allow changes to be made to existing file structures 
B) computer programs create a fresh record for each task 
C) each set of computer programs operates on its own records 
D) different sets of computer programs process files in a similar manner

Question 17

How are databases used across organizational boundaries? Illustrate with an example.

Accepted Answer

In databases without boundaries, people

Question 18

What are the ways in which information is classified in terms of structure? Explain with examples.

Accepted Answer

Information is classified into three typ

Question 19

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

Accepted Answer

A) data warehouse 
B) operational database 
C) data dictionary 
D) transaction database 
A) data warehouse 
B) operational database 
C) data dictionary 
D) transaction database

Question 20

Shards or slices of a database should be accessed from the same computer for improved performance.

Accepted Answer

A) True 
 B)False

________ specifies the characteristics of a field, such as the type of data it will hold.

In Robin Dave Hospital, visiting physicians use different spreadsheets to record the name, address, mobile number, and email of clients. These individual spreadsheets are then compiled by a data-entry operator into one spreadsheet. What type of information does the compiled spreadsheet represent?

Which database architecture is especially used for managing web content and web-based resources?

Master data management has more to do with technology than people, processes, and governance.

What are shadow systems? How do they hinder managers who are looking for company-wide summaries?

Building interfaces, or bridges, between different databases to link common fields is an integration strategy.

In enterprise information management, data ownership issues arise because ________.

Companies often use different relational DBMS for their data warehouse and operational database.

When using databases without boundaries ________.

Databases are created and handled using ________.

In comparison with unstructured information, semi-structured information ________.

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

________ uses statistical techniques to explore a data warehouse and hunt for hidden patterns and relationships that are undetectable in routine reports.

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.

________ ensures that every foreign key entry actually exists as a primary key entry in its main table.

A separate file processing system leads to the creation of redundant information because ________.

How are databases used across organizational boundaries? Illustrate with an example.

What are the ways in which information is classified in terms of structure? Explain with examples.

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

Shards or slices of a database should be accessed from the same computer for improved performance.

Information Systems and People

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web, E-Commerce, and M-Commerce

Business Intelligence and Decision Making

Collaborating With Technology

Knowledge Management and E-Learning

Ethics, Privacy, and Security

Systems Development and Procurement

Project Management and Strategic Planning

Filters

Exam 4: Databases and Datawarehouses

________ specifies the characteristics of a field, such as the type of data it will hold.

In Robin Dave Hospital, visiting physicians use different spreadsheets to record the name, address, mobile number, and email of clients. These individual spreadsheets are then compiled by a data-entry operator into one spreadsheet. What type of information does the compiled spreadsheet represent?

Which database architecture is especially used for managing web content and web-based resources?

Master data management has more to do with technology than people, processes, and governance.

What are shadow systems? How do they hinder managers who are looking for company-wide summaries?

Building interfaces, or bridges, between different databases to link common fields is an integration strategy.

In enterprise information management, data ownership issues arise because ________.

Companies often use different relational DBMS for their data warehouse and operational database.

When using databases without boundaries ________.

Databases are created and handled using ________.

In comparison with unstructured information, semi-structured information ________.

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

________ uses statistical techniques to explore a data warehouse and hunt for hidden patterns and relationships that are undetectable in routine reports.

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.

________ ensures that every foreign key entry actually exists as a primary key entry in its main table.

A separate file processing system leads to the creation of redundant information because ________.

How are databases used across organizational boundaries? Illustrate with an example.

What are the ways in which information is classified in terms of structure? Explain with examples.

Which of the following is used to spot trends, identify patterns, generate reports for compliance purposes, do research, and plan strategies?

Shards or slices of a database should be accessed from the same computer for improved performance.

Information Systems and People

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web, E-Commerce, and M-Commerce

Business Intelligence and Decision Making

Collaborating With Technology

Knowledge Management and E-Learning

Ethics, Privacy, and Security

Systems Development and Procurement

Project Management and Strategic Planning

Filters