A tuple is one record or data set in a row ✔✔What are tuples and how are they used in databases?
a.) A tuple is a collection of sequenced data
... [Show More] fields
b.) A tuple is one record or data set in a row
c.) A tuple is a database field
The flat file design is a single table database ✔✔What is the best description of a flat file database?
a.) Flat file databases are hierarchical in nature.
b.) Flat file databases are prevalent today because they provide relational functions.
c.) The flat file design is a single table database.
Data integrity ✔✔WHAT means that the data is accurate and consistent through its use and
application time?
a.) Data integrity
b.) Normalization
c.) Fidelity
ERD ✔✔A database schema can be represented by which model?
a.) ERD (Entity-relationship Diagram)
b.) Data Repository
c.) Foreign Keys
Normalization ✔✔During the database design process, WHAT takes place to eliminate data
redundancy?
a.) Normalization
b.) Integrity review
c.) Redundancy elimination
Relational databases have simpler table relationships than hierarchical databases ✔✔Why did
relational database models replace hierarchical database models in business applications?
a.) Relational databases don't use SQL, which is used in hierarchical databases.
b.) Relational databases have simpler table relationships than hierarchical databases.
c.) Relational databases are less expensive than hierarchical databases.
Petabyte ✔✔Big Data database size is considered to be in WHAT size level?
a.) Petabyte
b.) Megabyte
c.) Terabyte
Data warehouses can be mined or analyzed for trends or patterns ✔✔Why are data warehouses
beneficial to business managers?
a.) Data warehouses store operational data.
b.) Data warehouses increase the effectiveness of OLTP databases.
c.) Data warehouses can be mined or analyzed for trends or patterns.
Data integrity is a process to ensure data is not corrupted ✔✔What is the best definition of data
integrity?
a.) Data integrity means data is current.
b.) Data integrity is a process to ensure data is not corrupted.
c.) Data integrity means data is secure and reproducible.
Reduce ✔✔It is good practice to do WHAT to data that is backed up on a regular basis?
a.) Reduce
b.) Copy
c.) Duplicate
Analytics would affect the database performance ✔✔Why is it not good practice to perform
analytics on an online transaction processing database?
a.) Analytics would duplicate operational data.
b.) Analytics would corrupt transaction data.
c.) Analytics would affect the database performance.
Joe is extracting information from existing data to better understand his customers and identify
potential risks ✔✔Which of the following is an accurate example of why a business should use
predictive analytics?
a.) Joe is extracting information from existing data to better understand his customers and identify
potential risks.
b.) Mary is using historical data so she can know what will happen in her business next year.
Data dictionary ✔✔Metadata is data about the data, and it is the necessary information needed to
understand and use data effectively. Where would the metadata about Customer and Product tables
be stored?
a.) DBMS
b.) Database
c.) Data dictionary
d.) ERD (Entity-relationship Diagram)
Data inconsistency ✔✔As a student taking classes, imagine if your name was misspelled in one
class, but not the other, and the impact this would have on your student record. If the same attribute
in related data files has different values, what is this an example of?
a.) Data integrity
b.) Data redundancy
c.) Data inconsistency
d.) Data quality audit
Classification ✔✔You were hired by a company to administer survey questionnaires to customers
entering a major shopping mall. The data mining software is capable of sorting the respondents
into WHAT based on their age, gender, education level, and household income?
a.) Classification
b.) Associations
c.) Forecasting
Confidentiality, integrity, and availability ✔✔The CIA triad is a model that guides information
security policy. What do the letters in CIA stand for?
a.) Cardinality, intelligence, and audit
b.) Confidentiality, integrity, and availability
c.) Capacity, infrastructure, and adaptive
False ✔✔[True/False] Organizational information policy stipulates that all printed documents in
an organization should be destroyed immediately.
a.) True
b.) False
False ✔✔ [Show Less]