Exam 5: Database Systems, Data Centres, and Business Intelligence

Data centres are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a "lights out" environment.

(True/False)

4.7/5

(36)

Question 41

One of the first steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

(True/False)

4.8/5

(25)

Question 42

Jane and her two friends plan to take three courses next semester including Accounting.Each of the courses at the university can accommodate a maximum of 40 students.In data modelling, what would be the relationship between course and student?

(Multiple Choice)

4.9/5

(47)

Question 43

A collection of related records is called a(n) ____________________.

(Short Answer)

4.9/5

(42)

Question 44

A(n) ____________________ is a subset of a data warehouse.

(Short Answer)

4.7/5

(40)

Question 45

Ali created a report for an instructor that lists all student marks for three tests, a midterm, and a final exam for the Winter term.The instructor asks Ali to modify the report to include only the three tests.What type of data manipulation would that involve?

(Multiple Choice)

4.8/5

(39)

Question 46

In creating a database, a system analyst creates several entities and for each of the entity creates a list of attributes.For each attribute, the system analyst is given certain constraints as to the valid values that can be used.What is the term used to refer to these constraints?

(Multiple Choice)

4.9/5

(42)

Question 47

Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

(True/False)

4.7/5

(34)

Question 48

Which of the following employs multidimensional databases to efficiently store and deliver data warehouse information?

(Multiple Choice)

4.8/5

(35)

Question 49

____________________ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

(Short Answer)

4.7/5

(33)

Question 50

The purpose of ____________________ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure.

(Short Answer)

4.8/5

(41)

Question 51

What application of data mining identifies the products and services most commonly purchased at the same time?

(Multiple Choice)

4.9/5

(47)

Question 52

What type of data manipulation involves eliminating rows in a relational database?

(Multiple Choice)

4.9/5

(43)

Question 53

A database design where certain data entities are combined, summary totals are carried in the data records rather than calculated, and some data attributes are repeated in more than one data entity exhibits what is called planned ____________________.

(Short Answer)

5.0/5

(29)

Question 54

The reputation and financial stability of the database ____________________ is important in selecting the proper DBMS.

(Short Answer)

4.9/5

(39)

Question 55

Which of the following contains a subset of data for a single aspect of a company's business and is used by smaller groups who want to access detailed data for business analysis?

(Multiple Choice)

4.8/5

(39)

Question 56

Which of the following typically stores three to ten years of historical summary data records from many operational systems and external data sources so that it can be used for business analysis?

(Multiple Choice)

4.8/5

(40)

Question 57

During payroll processing, the system crashed and the operator concluded that the payroll system had integrity issues.Who will be called first to fix the problem?

(Multiple Choice)

4.9/5

(40)

Question 58

Developing a seamless integration of databases with the Internet is sometimes called a(n) ____________________.

(Short Answer)

4.9/5

(35)

Question 59

Database management systems cost in excess of $1,000.

(True/False)

4.9/5

(35)

Question 60

Showing 41 - 60 of 97

Data centres are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a "lights out" environment.

One of the first steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

Jane and her two friends plan to take three courses next semester including Accounting.Each of the courses at the university can accommodate a maximum of 40 students.In data modelling, what would be the relationship between course and student?

A collection of related records is called a(n) ____________________.

A(n) ____________________ is a subset of a data warehouse.

Ali created a report for an instructor that lists all student marks for three tests, a midterm, and a final exam for the Winter term.The instructor asks Ali to modify the report to include only the three tests.What type of data manipulation would that involve?

In creating a database, a system analyst creates several entities and for each of the entity creates a list of attributes.For each attribute, the system analyst is given certain constraints as to the valid values that can be used.What is the term used to refer to these constraints?

Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

Which of the following employs multidimensional databases to efficiently store and deliver data warehouse information?

____________________ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

The purpose of ____________________ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure.

What application of data mining identifies the products and services most commonly purchased at the same time?

What type of data manipulation involves eliminating rows in a relational database?

A database design where certain data entities are combined, summary totals are carried in the data records rather than calculated, and some data attributes are repeated in more than one data entity exhibits what is called planned ____________________.

The reputation and financial stability of the database ____________________ is important in selecting the proper DBMS.

Which of the following contains a subset of data for a single aspect of a company's business and is used by smaller groups who want to access detailed data for business analysis?

Which of the following typically stores three to ten years of historical summary data records from many operational systems and external data sources so that it can be used for business analysis?

During payroll processing, the system crashed and the operator concluded that the payroll system had integrity issues.Who will be called first to fix the problem?

Developing a seamless integration of databases with the Internet is sometimes called a(n) ____________________.

Database management systems cost in excess of $1,000.

Introduction to Information Systems

The Personal and Social Impact of Computers

Hardware: Input, Processing, and Output Devices

Software: Systems and Application Software

Telecommunications and Networks

The Internet, Web, Intranets, and Extranets

Electronic and Mobile Commerce

Enterprise Systems

Information and Decision Support Systems

Knowledge Management and Specialized Information Systems

Systems Development: Investigation and Analysis

Systems Development: Design, Implementation, Maintenance, and Review

Filters