A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.
0%
data warehouse
0%
relational dbms
0%
data quality audit
0%
data dictionary
Q.2.
the project operation:
0%
physical database available for different logical views.
0%
presents data as they would be perceived by end users.
0%
the entity CUSTOMER with the attribute ADDRESS
0%
creates a subset consisting of columns in a table.
Q.3.
What are the relationships that the relational database is named for?
0%
relational dbms
0%
relationships between entities
0%
data manipulation language
0%
the entity CUSTOMER with the attribute ADDRESS
Q.4.
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
0%
SQL queries
0%
non relational DBMS
0%
normalization
0%
web usage mining
Q.5.
In terms of the data relationships found by data mining, associations refers to:
0%
occurences linked to a single event
0%
richness or variety of topics covered
0%
open source software framework designed for distributing data-processing over inexpensive computers.
0%
False
Q.6.
A field identified in a record as holding the unique identifier for that record is called the:
0%
data lake
0%
key field
0%
warehouse
0%
attribute
Q.7.
All of the following are tools or technologies for extracting information from unstructured data sets except:
0%
non relational DBMS
0%
OLAP
0%
SQL queries
0%
web structure mining
Q.8.
A schematic of the entire database that describes the relationships in a database is called a(n):
0%
the entity CUSTOMER with the attribute ADDRESS
0%
data manipulation language
0%
entity-relationship diagram
0%
in two short marks
Q.9.
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?
0%
one-to-one
0%
attribute
0%
SQL queries
0%
facebook
Q.10.
Which of the following best illustrates the relationship between entities and attributes?
0%
the entity CUSTOMER with the attribute ADDRESS
0%
Data warehouse systems provide easy-to-use tools for managers to easily update data.
0%
non relational DBMS
0%
data manipulation language
Q.11.
As described in the chapter case, the Charlotte Hornets used a ________ to consolidate fan data from multiple sources.
0%
warehouse
0%
data warehouse
0%
data scrubbing
0%
data dictionary
Q.12.
A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.
0%
facebook
0%
primary key
0%
database server
0%
data lake
Q.13.
Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large data sets are referred to as:
0%
analytic platforms
0%
data scrubbing
0%
data dictionary
0%
data quality audit
Q.14.
Non-relational databases:
0%
store infomration in an unstructured format
0%
physical database available for different logical views.
0%
display data in an easier to read format
0%
internet connectivity problems
Q.15.
Links pointing to an online document are a sign of:
0%
discovery driven
0%
popularity
0%
one table for each entity
0%
richness or variety of topics covered
Q.16.
Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?
0%
web structure mining
0%
relational dbms
0%
facebook
0%
data dictionary
Q.17.
Which of the following statements about data warehouses is not true?
0%
It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.
0%
data manipulation language
0%
Data warehouse systems provide easy-to-use tools for managers to easily update data.
0%
web structure mining
Q.18.
Common data quality problems include all of the following except:
0%
internet connectivity problems
0%
events linked over time
0%
relationships between entities
0%
intersection relation
Q.19.
Which of the following would you use to find patterns in user interaction data recorded by web servers?
0%
web usage mining
0%
data manipulation language
0%
non relational DBMS
0%
web structure mining
Q.20.
Which of the following best describes the importance of creating an accurate data model for your business's database?
0%
It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.
0%
the entity CUSTOMER with the attribute ADDRESS
0%
data manipulation language
0%
web usage mining
Q.21.
Which of the following is an example of a company whose business model is based on access to large databases through the web?
0%
OLAP
0%
data dictionary
0%
facebook
0%
SQL queries
Q.22.
A field identified in a table as holding the unique identifier of the table's records is called the:
0%
primary key
0%
normalization
0%
text mining
0%
SQL queries
Q.23.
Which of the following allows users to add, change, delete, or retrieve data in a database?
0%
data dictionary
0%
web usage mining
0%
Data warehouse systems provide easy-to-use tools for managers to easily update data.
0%
data manipulation language
Q.24.
A data ________ stores current and historical data of potential interest to decision makers throughout the company.
0%
warehouse
0%
database server
0%
data quality audit
0%
data warehouse
Q.25.
Which of the following is the most prominent data manipulation language today?
0%
OLAP
0%
non relational DBMS
0%
web usage mining
0%
SQL
Q.26.
Which of the following database types would be best suited for storing multimedia?
0%
data manipulation language
0%
non relational DBMS
0%
relationships between entities
0%
facebook
Q.27.
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:
0%
relationships between entities
0%
data manipulation language
0%
with a crow's foot preceded by a short mark
0%
it typically focuses on a single subject are or line of business
Q.28.
CGI is a specification for processing data on a web server.
0%
True
0%
False
Q.29.
Big data refers to any database that:
0%
five tables: for customers, employees, suppliers, parts, and sales
0%
store infomration in an unstructured format
0%
richness or variety of topics covered
0%
has a large volume and variety of data
Q.30.
DBMS typically include report-generating tools in order to:
0%
with a crow's foot preceded by a short mark
0%
physical database available for different logical views.
0%
display data in an easier to read format
0%
richness or variety of topics covered
Q.31.
In a relational database, a record is also called a(n):
0%
events linked over time
0%
False
0%
tuple
0%
True
Q.32.
A DBMS makes the:
0%
display data in an easier to read format
0%
has a large volume and variety of data
0%
physical database available for different logical views.
0%
it typically focuses on a single subject are or line of business
Q.33.
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:
0%
data quality audit
0%
data warehouse
0%
data scrubbing
0%
relational dbms
Q.34.
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?
0%
web structure mining
0%
data manipulation language
0%
web usage mining
0%
data dictionary
Q.35.
A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.
0%
database server
0%
web usage mining
0%
data scrubbing
0%
data warehouse
Q.36.
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?
0%
relational dbms
0%
data dictionary
0%
web structure mining
0%
web usage mining
Q.37.
A table that links two tables that have a many-to-many relationship is often called a(n):
0%
relational dbms
0%
data quality audit
0%
intersection relation
0%
primary key
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.