CIS Module 8a&b

Select the three terms for the data elements associated with an entity. Multiple select question. Models Attributes Fields Metadata Columns

Attributes Fields Columns

What defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer? Multiple choice question. Business rule Critical rule Information rule Business key

Business rule

What compiles all of the metadata about the data elements in the data model? Multiple choice question. Data models Data dictionary Data warehouse Data governance

Data dictionary

What is the smallest or basic unit of information? Multiple choice question. Database Data element Data warehouse Data model

Data element

Select a term that is a synonym for data element, the smallest or basic unit of information in a database. Data dictionary Data query Data field Data-driven website

Data field

What are logical data structures that detail the relationships among data elements using graphics or pictures? Multiple choice question. Database Data warehouse Data models

Data models

What maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)? Multiple choice question. Data governance Foreign key Database Data dictionary

Database

What creates, reads, updates, and deletes data in a database while controlling access and security? Multiple choice question. Database management system Real-time system Data visualization tools Data governance system

Database management system

Multiple Choice Question Select the statement that accurately defines the relationship between entities and attributes in a relational database. Multiple choice question. Each record in an attribute occupies one row in its respective table. Each key in an entity occupies one row in its respective table. Each attribute of an entity occupies a separate column of a table. Each record in an entity occupies multiple rows in its respective table.

Each record in an attribute occupies one row in its respective table.

Multiple Choice Question What stores information about a person, place, thing, transaction, or event? Multiple choice question. Entity Key Records Attributes

Entity

Select the term that refers to the table used to store information about a person, place, thing, transaction, or event. Multiple choice question. Entity Attribute Key

Entity

What is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables? Multiple choice question. Primary key Foreign key Data dictionary Data element

Foreign key

Multiple Choice Question What are rules that help ensure the quality of information? Multiple choice question. Static information Integrity constraints Dynamic information Data-driven constraint

Integrity constraints

_________ provides details about data. Multiple choice question. Record Metadata Dictionary

Metadata

What is a field that uniquely identifies a given record in a table? Multiple choice question. Data dictionary Foreign key Structured query language Primary key

Primary key

What is a collection of related data elements? Multiple choice question. Attributes Entities Records Keys

Records

Select the accurate statements reflecting the business advantages of a relational database. Multiple select question. Reduced information integrity Reduced flexibility Increased information security Increased information integrity Increased information redundancy Reduced information redundancy

Reduced information redundancy Increased information security Increased information integrity

__________ integrity constraints are rules that enforce basic and fundamental information-based constraints. Multiple choice question. Security Business Relational

Relational

What are rules that enforce basic and fundamental information-based constraints? Multiple choice question. Business rules Business-critical integrity constraints Relational integrity constraints Physical view of information

Relational integrity constraints

A(n) _________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer. Multiple choice question. relational business content

business

Integrity __________ are rules that help ensure the quality of information. Multiple choice question. classification issues data constraints

constraints

A data ____________ compiles all of the metadata about the data elements in the data model. Multiple choice question. model dictionary element query

dictionary

A(n) ____ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. Multiple choice question. foreign secondary data primary

foreign

What is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity? Multiple choice question. data latency information latency information integrity identity management

identity management

What provides details about data? Multiple choice question. data validation data steward metadata analytical data

metadata

Data ____ are logical data structures that detail the relationships among data elements using graphics or pictures. Multiple choice question. elements dictionaries models

models

A(n) ____ key is a field (or group of fields) that uniquely identifies a given record in a table. Multiple choice question. primary secondary foreign

primary

A(n) _____ is a collection of related data elements. Multiple choice question. dictionary model key record

record

Multiple Choice Question Information __________ is the duplication of data, or the storage of the same data in multiple places. Multiple choice question. granularity integrity redundancy

redundancy

Question Mode Multiple Choice Question A(n) __________ query language asks users to write lines of code to answer questions against a database. Multiple choice question. unstructured structured mining

structured

Which of the following are the data elements associated with an entity? Multiple choice question. · Attributes · Entities · Keys · Metadata

· Attributes