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