Multiple Choice Questions

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.
  • data warehouse
  • relational dbms
  • data quality audit
  • data dictionary
the project operation:
  • physical database available for different logical views.
  • presents data as they would be perceived by end users.
  • the entity CUSTOMER with the attribute ADDRESS
  • creates a subset consisting of columns in a table.
What are the relationships that the relational database is named for?
  • relational dbms
  • relationships between entities
  • data manipulation language
  • the entity CUSTOMER with the attribute ADDRESS
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
  • SQL queries
  • non relational DBMS
  • normalization
  • web usage mining
In terms of the data relationships found by data mining, associations refers to:
  • occurences linked to a single event
  • richness or variety of topics covered
  • open source software framework designed for distributing data-processing over inexpensive computers.
  • False
A field identified in a record as holding the unique identifier for that record is called the:
  • data lake
  • key field
  • warehouse
  • attribute
All of the following are tools or technologies for extracting information from unstructured data sets except:
  • non relational DBMS
  • OLAP
  • SQL queries
  • web structure mining
A schematic of the entire database that describes the relationships in a database is called a(n):
  • the entity CUSTOMER with the attribute ADDRESS
  • data manipulation language
  • entity-relationship diagram
  • in two short marks
You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?
  • one-to-one
  • attribute
  • SQL queries
  • facebook
Which of the following best illustrates the relationship between entities and attributes?
  • the entity CUSTOMER with the attribute ADDRESS
  • Data warehouse systems provide easy-to-use tools for managers to easily update data.
  • non relational DBMS
  • data manipulation language
As described in the chapter case, the Charlotte Hornets used a ________ to consolidate fan data from multiple sources.
  • warehouse
  • data warehouse
  • data scrubbing
  • data dictionary
A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.
  • facebook
  • primary key
  • database server
  • data lake
Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large data sets are referred to as:
  • analytic platforms
  • data scrubbing
  • data dictionary
  • data quality audit
Non-relational databases:
  • store infomration in an unstructured format
  • physical database available for different logical views.
  • display data in an easier to read format
  • internet connectivity problems
Links pointing to an online document are a sign of:
  • discovery driven
  • popularity
  • one table for each entity
  • richness or variety of topics covered
Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?
  • web structure mining
  • relational dbms
  • facebook
  • data dictionary
Which of the following statements about data warehouses is not true?
  • It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.
  • data manipulation language
  • Data warehouse systems provide easy-to-use tools for managers to easily update data.
  • web structure mining
Common data quality problems include all of the following except:
  • internet connectivity problems
  • events linked over time
  • relationships between entities
  • intersection relation
Which of the following would you use to find patterns in user interaction data recorded by web servers?
  • web usage mining
  • data manipulation language
  • non relational DBMS
  • web structure mining
Which of the following best describes the importance of creating an accurate data model for your business's database?
  • It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.
  • the entity CUSTOMER with the attribute ADDRESS
  • data manipulation language
  • web usage mining
Which of the following is an example of a company whose business model is based on access to large databases through the web?
  • OLAP
  • data dictionary
  • facebook
  • SQL queries
A field identified in a table as holding the unique identifier of the table's records is called the:
  • primary key
  • normalization
  • text mining
  • SQL queries
Which of the following allows users to add, change, delete, or retrieve data in a database?
  • data dictionary
  • web usage mining
  • Data warehouse systems provide easy-to-use tools for managers to easily update data.
  • data manipulation language
A data ________ stores current and historical data of potential interest to decision makers throughout the company.
  • warehouse
  • database server
  • data quality audit
  • data warehouse
Which of the following is the most prominent data manipulation language today?
  • OLAP
  • non relational DBMS
  • web usage mining
  • SQL
Which of the following database types would be best suited for storing multimedia?
  • data manipulation language
  • non relational DBMS
  • relationships between entities
  • facebook
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:
  • relationships between entities
  • data manipulation language
  • with a crow's foot preceded by a short mark
  • it typically focuses on a single subject are or line of business
CGI is a specification for processing data on a web server.
  • True
  • False
Big data refers to any database that:
  • five tables: for customers, employees, suppliers, parts, and sales
  • store infomration in an unstructured format
  • richness or variety of topics covered
  • has a large volume and variety of data
DBMS typically include report-generating tools in order to:
  • with a crow's foot preceded by a short mark
  • physical database available for different logical views.
  • display data in an easier to read format
  • richness or variety of topics covered
In a relational database, a record is also called a(n):
  • events linked over time
  • False
  • tuple
  • True
A DBMS makes the:
  • display data in an easier to read format
  • has a large volume and variety of data
  • physical database available for different logical views.
  • it typically focuses on a single subject are or line of business
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:
  • data quality audit
  • data warehouse
  • data scrubbing
  • relational dbms
Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security?
  • web structure mining
  • data manipulation language
  • web usage mining
  • data dictionary
A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.
  • database server
  • web usage mining
  • data scrubbing
  • data warehouse
Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites?
  • relational dbms
  • data dictionary
  • web structure mining
  • web usage mining
A table that links two tables that have a many-to-many relationship is often called a(n):
  • relational dbms
  • data quality audit
  • intersection relation
  • primary key
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0