IS Quiz 6

The most popular data manipulation language and method to​ "question" a database is called​ ______________. A. Structured Query Language B. Structured Question Language C. Standard Query Process D. Simple Question Language E. Data Definition Language

. Structured Query Language

Which tool enables users to view the same data in different ways using multiple​ dimensions? A. OLAP This is the correct answer.B. Clustering C. SQL Your answer is not correct.D. Hadoop E. OLTP

A. OLAP

In a student​ database, a column called LastName would be an example of​ a(n) _____________. A. attribute This is the correct answer.B. entity C. file D. database Your answer is not correct.E. record

A. attribute

A​ ________ is represented by a 0 or 1. Eight together make a byte​ (i.e., 00101100). A. bit This is the correct answer.B. kilobyte Your answer is not correct.C. byte D. file E. megabit

A. bit

In a student​ database, a collection of related attributes such as​ LastName, FirstName, and​ Student# creates​ a(n) _______________. A. entity This is the correct answer.B. bit Your answer is not correct.C. record D. database E. file

A. entity

What is the first step you should take in managing data for a​ firm? A. Audit your data quality. B. Identify the data needed to run the business. This is the correct answer.C. Cleanse the data before importing it to any database. Your answer is not correct.D. Normalize the data before importing to a database. E. Back up the data.

B. Identify the data needed to run the business.

Among the following​ statements, which one is NOT applicable to big​ data? A. Big data is generated rapidly. B. Big data has a variety of data with structured data and​ free-form text and logs. C. Big data can be processed with traditional techniques. Your answer is correct.D. Big data can consist of multimedia files like​ graphics, audio, and video. E. Big data data sets are at least a petabyte in size.

Big data can be processed with traditional techniques.

If you needed a DBMS for large commercial use on a​ mainframe, _____________ would be a viable option. A. Microsoft Project B. Microsoft Access C. Microsoft SQL Server Your answer is correct.D. Microsoft Explorer E. Microsoft Excel

C. Microsoft SQL Server

​_______________ databases are by far the most popular type of database on the market today. A. ​Class-oriented B. ​Object-oriented Your answer is not correct.C. Relational This is the correct answer.D. Meta E. Flat

C. Relational

Among the​ following, what is the best way to distinguish between reporting tools and data mining​ tools? A. The ways of deploying the results B. The difference in the input data C. The complexity of techniques used This is the correct answer.D. The objective of using these tools Your answer is not correct.E. The type of data used

C. The complexity of techniques used

Which of the following is NOT a rule in an​ organization's information​ policy? A. Procedures and accountabilities around managing data resources B. Which users and organizational units can share information C. What the relationships inside the data are Your answer is correct.D. Who is responsible for updating and maintaining the information E. Where information can be distributed

C. What the relationships inside the data are

A​ ________ in a database represents a single character such as a letter or number. A. megabit Your answer is not correct.B. kilobyte C. byte This is the correct answer.D. bit E. file

C. byte

Microsoft Azure SQL is an example of a​ _________________ database. A. text B. local C. cloud This is the correct answer.D. flat E. network

C. cloud

The special organizational function whose responsibilities include the technical and operational aspects of managing​ data, including physical database design and​ maintenance, is called​ ________. A. data mining B. data auditing C. database administration Your answer is correct.D. information policy administration E. data administration

C. database administration

The most common use of nonrelational database management systems is​ for__________________. A. managing university lists of students Your answer is not correct.B. managing smaller data sets C. managing extremely large data sets This is the correct answer.D. managing small retail stores E. managing text data only

C. 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). A. creation Your answer is not correct.B. question C. manipulation This is the correct answer.D. ask E. definition

C. manipulation

​A(n) __________ key uniquely identifies a row or record in a table. A. foreign B. domestic Your answer is not correct.C. primary This is the correct answer.D. initial E. secondary

C. primary

Which of the following involves searching for patterns and relationships among​ data? A. Data processing B. Knowledge management C. Data warehousing Your answer is not correct.D. Data mining This is the correct answer.E. Data marting

D. Data mining

Which of the following is NOT a function of a data​ warehouse? A. Cleanse data B. Obtain data C. Organize and relate data Your answer is not correct.D. Filter data This is the correct answer.E. Catalog data

D. Filter data

Which of the following statements is NOT a characteristic of​ Hadoop? A. Hadoop combines results into a smaller data set that is easier to analyze. B. Hadoop breaks a big data problem down into​ sub-problems. C. Hadoop enables distributed parallel processing of huge amounts of data across inexpensive computers. Your answer is not correct.D. Hadoop extracts data from multiple tables that have a relationship. This is the correct answer.E. Hadoop is an open source software framework.

D. Hadoop extracts data from multiple tables that have a relationship.

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. A. ethical Your answer is not correct.B. data flow C. task model D. referential This is the correct answer.E. secondary

D. referential

Which of the following statements is FALSE about business intelligence​ (BI) systems? A. BI systems identify​ patterns, relationships, and trends. B. BI systems process operational and social data. Your answer is not correct.C. BI systems have five​ components: hardware,​ software, data,​ procedures, and people. D. BI systems are used by any business professionals and knowledge workers. E. BI systems only support​ decision-making activities.

E. BI systems only support​ decision-making activities.

​A(n) __________ is a popular way to describe relationships​ (i.e., one-to-one,​ one-to-many) in a relational database. A. Six Sigma Your answer is not correct.B. task model C. data flow diagram D. Total Quality Management E. entity relationship diagram

E. entity relationship diagram

Relational tables need to be​ ______________ to help avoid duplicate data. A. ethically analyzed B. task modeled C. entitled D. relationally modeled Your answer is not correct.E. normalized

E. normalized

In a student​ database, a row that describes the top​ student, including his or her​ LastName, FirstName, and​ StudentNumber, is an example of a​ ______________. A. database Your answer is not correct.B. file C. group D. field E. record

E. record