Chapter 6 Quiz

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

In a student​ database, a row that describes the top​ student, including his or her​ LastName, FirstName, and​ StudentNumber, is an example of a​ ______________.

record

Relational databases enforce​ ______________ integrity to​ ensure, for​ instance, that a teacher​ can't be assigned to a CLASS table unless they already exist in the TEACHER table.

referential

If you needed a DBMS for large commercial use on a​ mainframe, _____________ would be a viable option.

Microsoft SQL Server

Which tool enables users to view the same data in different ways using multiple​ dimensions?

OLAP

​_______________ databases are by far the most popular type of database on the market today.

Relational

The most popular data manipulation language and method to​ "question" a database is called​ ______________.

Structured Query Language

In a student​ database, a column called LastName would be an example of​ a(n) _____________.

attribute

A(n) __________ is a popular way to describe relationships​ (i.e., one-to-one,​ one-to-many) in a relational database.

entity relationship diagram

Which of the following statements is FALSE about business intelligence​ (BI) systems?

A. BI systems are used by any business professionals and knowledge workers. B. BI systems process operational and social data. C. BI systems identify​ patterns, relationships, and trends. CORRECT D. BI systems only support​ decision-making activities. E. BI systems have five​ components: hardware,​ software, data,​ procedures, and people.

Among the following​ statements, which one is NOT applicable to big​ data?

A. Big data has a variety of data with structured data and​ free-form text and logs. B. Big data can consist of multimedia files like​ graphics, audio, and video. CORRECT: C. Big data can be processed with traditional techniques. D. Big data is generated rapidly. E. Big data data sets are at least a petabyte in size.

Which of the following is NOT a function of a data​ warehouse?

A. Cleanse data B. Catalog data C. Obtain data CORRECT: D. Filter data E. Organize and relate data

Which of the following statements is NOT a characteristic of​ Hadoop?

A. Hadoop is an open source software framework. B. Hadoop breaks a big data problem down into​ sub-problems. C. Hadoop combines results into a smaller data set that is easier to analyze. CORRECT: D. Hadoop extracts data from multiple tables that have a relationship. E. Hadoop enables distributed parallel processing of huge amounts of data across inexpensive computers.

Among the​ following, what is the best way to distinguish between reporting tools and data mining​ tools?

A. The type of data used B. The difference in the input data C. The ways of deploying the results CORRECT D. The complexity of techniques used E. The objective of using these tools

Which of the following is NOT a rule in an​ organization's information​ policy?

A. Which users and organizational units can share information CORRECT: B. What the relationships inside the data are C. Where information can be distributed D. Who is responsible for updating and maintaining the information E. Procedures and accountabilities around managing data resources

Which of the following involves searching for patterns and relationships among​ data?

Data mining

What is the first step you should take in managing data for a​ firm?

Identify the data needed to run the business.

A​ ________ is represented by a 0 or 1. Eight together make a byte​ (i.e., 00101100).

bit

A​ ________ in a database represents a single character such as a letter or number.

byte

Microsoft Azure SQL is an example of a​ _________________ database.

cloud

The special organizational function whose responsibilities include the technical and operational aspects of managing​ data, including physical database design and​ maintenance, is called​ ________.

database administration

In a student​ database, a collection of related attributes such as​ LastName, FirstName, and​ Student# creates​ a(n) _______________.

entity

The most common use of nonrelational database management systems is​ for__________________.

managing extremely large data sets

The data​ _______________ language would allow you to retrieve information from the database​ (i.e., using the​ SELECT, FROM, WHERE​ commands).

manipulation

Relational tables need to be​ ______________ to help avoid duplicate data.

normalized

​A(n) __________ key uniquely identifies a row or record in a table.

primary


Ensembles d'études connexes

Pre-Cal and Trigonometry Chapter 4

View Set