-
In a student database, a row that describes the top student, including his or her LastName, FirstName, and StudentNumber, is an example of a(n) ______________.
A. group
B. record
C. file
D. field
E. attribute
record
-
In a student database, a column called LastName would be an example of a(n) _____________.
A. attribute
B. relationship
C. file
D. record
E. entity
attribute
-
In a student database, a collection of related attributes such as LastName, FirstName, and Student# creates a(n) _______________.
A. entity
B. relationship
C. file
D. record
E. bit
entity
-
A ________ in a database represents a single character such as a letter or number.
A. bit
B. megabit
C. kilobyte
D. file
E. byte
byte
-
_______________ databases are by far the most popular type of database on the market today.
A. Meta
B. Flat
C. Object-oriented
D. Class-oriented
E. Relational
Relational
-
A(n) __________ key uniquely identifies a row or record in a table.
A. primary
B. domestic
C. secondary
D. foreign
E. initial
primary
-
Which of the following is a popular way to describe relationships (i.e., one-to-one, one-to-many) in a relational database?
A. Data descriptor method
B. Process model
C.Entity-relationship diagram
D. Task model
E. Data flow diagram
Entity-relationship diagram
-
Relational databases enforce ______________ integrity to ensure, for instance, that a teacher can't be assigned to a CLASS table unless the teacher already exists in the TEACHER table.
A. referential
B. secondary
C. task model
D. ethical
E. data flow
referential
-
Relational tables need to be ______________ to help avoid duplicate data.
A. ethically analyzed
B. entitled
C. normalized
D. relationally modeled
E. task modeled
normalized
-
A ________ is represented by a 0 or 1.
A. byte
B. kilobyte
C. megabit
D. file
E. bit
bit
-
If you need a DBMS for large commercial use on a mainframe, which of the following is a viable option?
A. Microsoft Access
B. Microsoft SQL Server
C. Microsoft Excel
D. Microsoft Explorer
E. Microsoft Project
Microsoft SQL Server
-
The data _______________ language allows you to retrieve information from the database (i.e., using the SELECT, FROM, WHERE commands).
A. creation
B. ask
C. manipulation
D. definition
E. question
manipulation
-
What is the most popular data manipulation language and method to "question" a database?
A. Standard Query Process
B. Structured Query Language
C. Data Definition Language
D. Simple Question Language
E. Structured Question Language
Structured Query Language
-
The most common use of non-relational database management systems is for managing ________.
A. small retail stores
B. text data only
C. smaller data sets
D. extremely large data sets
E. lists of university students
extremely large data sets
-
Microsoft Azure SQL is an example of a _________________ database.
A. cloud
B. network
C. flat
D. text
E. local
cloud
-
The "3V's" used to characterize big data include volume, variety, and _______.
A. vastness
B. vigor
C. veracity
D. velocity
E. value
velocity
-
Which statement about big data is FALSE?
A. Big data can be processed with traditional techniques.
B. Big data data sets are at least a petabyte in size.
C. Big data has a variety of data with structured data and free-form text and logs.
D. Big data can consist of multimedia files like graphics, audio, and video.
E. Big data is generated rapidly.
Big data can be processed with traditional techniques
-
Which of the following is NOT a function of a data warehouse?
A. Organize and relate data
B. Filter data
C. Cleanse data
D. Catalog data
E. Obtain data
Filter data
-
Which of the following involves searching for patterns and relationships among data?
A. Data processing
B. Knowledge management
C. Data mining
D. Data marting
E. Data warehousing
Data mining
-
A method that allows complex business calculations to be performed on very large data sets in seconds is termed __________.
A. big data computing
B. disk-based computing
C. analytic computing
D. power computing
E. in-memory computing
in-memory computing
-
Which tool enables users to view the same data in different ways using multiple dimensions?
A. OLAP
B. OLTP
C. SQL
D. Hadoop
E. Clustering
OLAP
-
Which of the following statements about Hadoop is FALSE?
A. Hadoop enables distributed parallel processing of huge amounts of data across inexpensive computers.
B. Hadoop combines results into a smaller data set that is easier to analyze.
C. Hadoop is an open source software framework.
D. Hadoop breaks a big data problem down into sub-problems.
E. Hadoop extracts data from multiple tables that have a relationship.
Hadoop extracts data from multiple tables that have a relationship.
-
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 administration
B. data mining
C. information policy administration
D. data auditing
E. database administration
database administration
-
What is the first step in effectively managing data for a firm?
A. Audit the data quality
B. Back up the data
C. Normalize the data before importing to a database
D. Specify the information policy
E. Cleanse the data before importing it to any database
Specify the information policy
-
Which of the following does NOT need to be addressed in an organization's information policy?
A. What the relationships inside the data are
B. Who is responsible for updating and maintaining the information
C. Procedures and accountabilities around managing data resources
D. Which users and organizational units can share information
E. Where information can be distributed
What the relationships inside the data are
|
|
