2
C175- Quiz Questions with verified detailed answers || || || || || ||
Which set of results should a company expect from implementing a business intelligence
|| || || || || || || || || || || || ||
system?
Increased profitability and increased throughput || || || ||
Which issue is focused on the loading component of extract, transform, load (ETL)?
|| || || || || || || || || || || ||
Monitor refreshing volume and frequency || || || ||
During which step in the extract, transform, load (ETL) process are raw data sets
|| || || || || || || || || || || || || ||
aggregated?
Transformation
How is prediction distinguished from estimation in data mining?
|| || || || || || || ||
Prediction classifies objects according to an expected future behavior.
|| || || || || || || ||
Where does affinity grouping occur in data mining?
|| || || || || || ||
Between objects ||
The definition of how data in a database will be organized is called the
|| || || || || || || || || || || || ||
Schema
A unique value occurs
|| || ||
only once in a given column
|| || || || ||
A relationship connects two pieces of data in different _____ in the same _____.
|| || || || || || || || || || || || ||
tables, database ||
Which is a good example of a candidate key?
|| || || || || || || ||
An employee ID number
|| || ||
How many SQL clauses are in this query?
|| || || || || || ||
SELECT Width,Height FROM Shapes; || || ||
2
, 2
In a database, what is a relation?
|| || || || || ||
a set of attributes (columns) that describe information about specific instances (rows) of an
|| || || || || || || || || || || || || ||
entity
You may also see the rows called "tuples."
|| || || || || || ||
What is the name of a key that consists of different fields taken together to act as a unique
|| || || || || || || || || || || || || || || || || || ||
identifier?
composite key ||
A composite key combines two or more fields to act as a unique identifier.
|| || || || || || || || || || || || ||
Which ACID step requires that the database is updated when the transaction completes
|| || || || || || || || || || || || ||
successfully?
Durable
When is an associative table useful? || || || || ||
when records need to be related in a many-to-many relationship
|| || || || || || || || ||
An associative (or linking) table relates foreign keys from different tables to associate their
|| || || || || || || || || || || || || ||
records.
In the ACID model, which term represents the fact that a transaction can't be divided into
|| || || || || || || || || || || || || || || ||
smaller parts? ||
atomic
Even though you now know atoms can be broken down into smaller parts, the term atomic
|| || || || || || || || || || || || || || || ||
means that something can't be broken down into smaller pieces. Here, atomicity means that
|| || || || || || || || || || || || ||
the transaction behaves as one single action.
|| || || || || || ||
What would you use a relationship to connect?
|| || || || || || ||
a customer with their favorite table in the restaurant
|| || || || || || || ||
This would be a one-to-many relationship. For every one table, there could be many
|| || || || || || || || || || || || || ||
customers who prefer to sit at it. But one customer cannot have many favorite tables.
|| || || || || || || || || || || || || ||
SQL is ||
C175- Quiz Questions with verified detailed answers || || || || || ||
Which set of results should a company expect from implementing a business intelligence
|| || || || || || || || || || || || ||
system?
Increased profitability and increased throughput || || || ||
Which issue is focused on the loading component of extract, transform, load (ETL)?
|| || || || || || || || || || || ||
Monitor refreshing volume and frequency || || || ||
During which step in the extract, transform, load (ETL) process are raw data sets
|| || || || || || || || || || || || || ||
aggregated?
Transformation
How is prediction distinguished from estimation in data mining?
|| || || || || || || ||
Prediction classifies objects according to an expected future behavior.
|| || || || || || || ||
Where does affinity grouping occur in data mining?
|| || || || || || ||
Between objects ||
The definition of how data in a database will be organized is called the
|| || || || || || || || || || || || ||
Schema
A unique value occurs
|| || ||
only once in a given column
|| || || || ||
A relationship connects two pieces of data in different _____ in the same _____.
|| || || || || || || || || || || || ||
tables, database ||
Which is a good example of a candidate key?
|| || || || || || || ||
An employee ID number
|| || ||
How many SQL clauses are in this query?
|| || || || || || ||
SELECT Width,Height FROM Shapes; || || ||
2
, 2
In a database, what is a relation?
|| || || || || ||
a set of attributes (columns) that describe information about specific instances (rows) of an
|| || || || || || || || || || || || || ||
entity
You may also see the rows called "tuples."
|| || || || || || ||
What is the name of a key that consists of different fields taken together to act as a unique
|| || || || || || || || || || || || || || || || || || ||
identifier?
composite key ||
A composite key combines two or more fields to act as a unique identifier.
|| || || || || || || || || || || || ||
Which ACID step requires that the database is updated when the transaction completes
|| || || || || || || || || || || || ||
successfully?
Durable
When is an associative table useful? || || || || ||
when records need to be related in a many-to-many relationship
|| || || || || || || || ||
An associative (or linking) table relates foreign keys from different tables to associate their
|| || || || || || || || || || || || || ||
records.
In the ACID model, which term represents the fact that a transaction can't be divided into
|| || || || || || || || || || || || || || || ||
smaller parts? ||
atomic
Even though you now know atoms can be broken down into smaller parts, the term atomic
|| || || || || || || || || || || || || || || ||
means that something can't be broken down into smaller pieces. Here, atomicity means that
|| || || || || || || || || || || || ||
the transaction behaves as one single action.
|| || || || || || ||
What would you use a relationship to connect?
|| || || || || || ||
a customer with their favorite table in the restaurant
|| || || || || || || ||
This would be a one-to-many relationship. For every one table, there could be many
|| || || || || || || || || || || || || ||
customers who prefer to sit at it. But one customer cannot have many favorite tables.
|| || || || || || || || || || || || || ||
SQL is ||
