CIS exam 3 Questions with Complete Solutions query-by-example - Correct Answers ✅helps users graphically design the answer to a question against a database DBMS tools - Correct Answers ✅query-by-query and SQL advantages and features of relational databases - Correct Answers ✅-increased flexibility -increased scalability and performance -reduced information redundancy -increased information integrity -increased information security redundant data (characteristics) - Correct Answers ✅can cause storage issues along with data integrity issues, making it difficult to determine which values are the most current or most accurate metadata - Correct Answers ✅details about data
EX: Title and description,
Tags and categories, Who created and when 1 / 4
CIS exam 3 Questions with Complete Solutions business rule - Correct Answers ✅Defines how a company performs a certain aspect of its business and typically results in either a yes/no or true/false answer.database - Correct Answers ✅maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) database management system - Correct Answers ✅creates, reads, updates, and deletes data in a database while controlling access and security data dictionary - Correct Answers ✅compiles all of the metadata about the data elements in the data model data element - Correct Answers ✅The smallest or basic unit of information data model - Correct Answers ✅logical data structures that detail the relationships among data elements using graphics or pictures foreign key - Correct Answers ✅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 2 / 4
CIS exam 3 Questions with Complete Solutions information integrity - Correct Answers ✅a measure of the quality of information information redundancy - Correct Answers ✅the duplication of data, or the storage of the same data in multiple places integrity constraints - Correct Answers ✅rules that help ensure the quality of information metadata (definition) - Correct Answers ✅details about data primary key - Correct Answers ✅A field (or group of fields) that uniquely identifies a given entity in a table redundant data (definition) - Correct Answers ✅can cause storage issues along with data integrity issues, making it difficult to determine which values are the most current or most accurate.structured query language (SQL) - Correct Answers ✅users write lines of code to answer questions against a database 3 / 4
CIS exam 3 Questions with Complete Solutions central components of blockchain - Correct Answers ✅Digital ledger, hash and digital signature, miners, decentralized advantages of blockchain - Correct Answers ✅1.Distributed - shared record keeping, no one person holds ownership
- Permissioned - everyone involved has a records/data
- Secure
- / 4
-Frees up capital flows -speeds processes -Lowers transaction costs -most importantly provides security and trust near instant digital asset transfer, asset movement, and security of data movement advantages of bitcoin - Correct Answers ✅Any well- connected node in the Bitcoin blockchain can determine, with certainty, whether a transaction does or does not exist in the data set; A prohibitively high cost to attempt to rewrite or alter transaction history