Exam 10: Databases Database Basics

  A(n) _____________ is a specification that the database designer sets up to filter data entered into a particular field.​ 

 Four DBMS vendors are the first stop for professional developers: IBM, _________, SAS, and SAP.​

 In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.​

 The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​ 

 In the context of database security, intermediary servers allow users to directly access the database.​ 

 Access to databases is usually open to anyone within an organization or business.​ 

 __________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.​ 

 A record that contains data is referred to as a record ________.​ 

 Enterprise database applications tend to have some flexibility for customization,​ 

 In a database, a(n) ____________  refers to a collection of data fields.​

 The simplest structure for storing data in a(n) _________  database is the key-value data model.​

 Data independence is a term that refers to data and program modules being so tightly interrelated that they become difficult to modify.​ 

 An example of _________ data is the 1 million transactions generated by Walmart sales registers every hour.​

 A primary key is a ____________ that contains data unique to a record.​

 In SQL terminology, creating a relationship between tables is referred to as _______ tables.​

 A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.​ 

 __________ refers to a branch of data mining that analyzes current and historical data to predict future trends.​ 

 A __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system.​ 

 The term database ___________ refers to the arrangement of fields, tables, and relationships in a database.​

 Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.​