Deck 10: Databases Database Basics

Question 1

 The underlying structure of a database is referred to as a database _________.​

Answer 1

  model​

Question 2

 Which of the following is not one of the main activities associated with operational databases?​ 

A) ​Collect, store, and view data 
B) ​Update and find data 
C) ​organizing and distributing data 
D) ​providing an executive dashboard for decision makers

Answer 2

  D

Question 3

 ​In a database, a(n) __________ contains the smallest unit of meaningful information 

A) ​record 
B) field​ 
C) ​table 
D) ​model

Answer 3

  B

Question 4

 One of the ways that databases are classified is by their structure.​ 

Question 5

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

Question 6

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

A) ​Predictive analytics 
B) ​OLAP 
C) ​Data warehouse 
D) ​TPS

Question 7

 In its broadest definition, a ____________ is a collection of information.​

Question 8

 It is not possible to extract analytical data from operational databases.​ 

Question 9

 A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.​ 

A) ​relational 
B) ​operational 
C) ​analytical 
D) ​non relational

Question 10

 __________ 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) ​SQL 
B) ​OLAP 
C) NoSQL​ 
D) ​TPS

Question 11

 A(n) __________ file consists of a single, two-dimensional table of data elements.​

Question 12

 A(n) ___________ file uses a uniform format to store data for each person or thing in the file.​

Question 13

 A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​ 

A) ​non relational 
B) ​operational 
C) ​relational 
D) ​analytical

Question 14

 Rather than deleting old data, it can be moved to a data __________.​

Question 15

 Decision makers can access analytical databases using an executive __________.​

Question 16

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

Question 17

 Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.​ 

A) ​analytics 
B) OLAP​ 
C) mining​ 
D) ​model

Question 18

 In a database, the template for a record is referred to as a record ______.​

Question 19

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

A) ​occurrence 
B) type​ 
C) ​template 
D) file​

Question 20

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

Question 21

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

Question 22

 Which database tool is best for simple flat files that involve calculations?​ 

A) ​Database software 
B) Spreadsheet software​ 
C) ​Word processing software 
D) ​DBMS

Question 23

 Which of the following is not considered to be type of database client?​ 

A) ​Local software 
B) ​Browsers 
C) ​Apps 
D) ​all of the above

Question 24

 A(n) _________ sort uses one field,  to arrange records. A(n) _________ sort arranges information by more than one field.​ 

A) ​single-level, multi-level 
B) ​multi-level, single-level 
C) structured, unstructured​ 
D) ​SQL, NoSQL

Question 25

 Modern database tools support ________________, which entails separating data from the programs that manipulate data.​ 

A) ​Predictive analytics 
B) ​Cardinality 
C) ​data independence 
D) data dependence​

Question 26

 Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.​ 

Question 27

 A key element of __________ databases is their ability to support OLAP queries that make it possible to combine data, drill down to specifics, or slice and dice the data to view it from different perspectives.​

Question 28

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

Question 29

 _________ refers to the number of associations that can exist between two record types.​

Question 30

 The acronym ____________ refers to software that manages data stored in a database.​​ 

A) ​ERP 
B) SQL​ 
C) ​OLAP 
D) ​DBMS

Question 31

 The relationship between record types can be depicted graphically with a(n) _________.​ 

A) ​data archive 
B) executive dashboard​ 
C) ​OLAP 
D) ​ERD

Question 32

 Spreadsheet software offers database capabilities for establishing relationships between different record types.​ 

Question 33

 A DBMS feature known as __________ ensures that transactions are updated in an orderly manner by establishing update rules.​ 

A) ​serializability 
B) ​optimization 
C) ​prioritization 
D) ​normalization

Question 34

 In a relational database, relationships are specified by joining common data stored in records from different tables. 

Question 35

 A hierarchical database allows one-to-many relationships but not one-to-one relationships.​ 

Question 36

 __________ are the most commonly used database clients.​​ 

A) ​Local software 
B) ​Apps 
C) ​Browsers 
D) ​none of the above

Question 37

 FileMaker Pro and Microsoft Access are DBMSs.​ 

Question 38

 In a(n) _________ database, a table is a sequence of records, similar to a flat file.​

Question 39

 Most spreadsheet software also includes basic data management features.​ 

Question 40

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

Question 41

 From a database user perspective, the data type determines the way data can be manipulated.​ 

Question 42

 ​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry. 

Question 43

 A(n) ____________ is a template that adds the correct formatting as data is entered. If someone attempts to enter data in the wrong format, the database can be set up to reject that entry or correct it.​ 

A) ​field format 
B) ​primary key 
C) ​database structure 
D) ​parameter

Question 44

 In the context of database security, user ______ management allows access to data on an as-needed basis.​

Question 45

 Which database data type is a collection of binary data stored in a single field of a database?​ 

A) ​Memo 
B) ​Integer 
C) ​BLOB 
D) ​Logical

Question 46

 From a technical perspective, a data __________ specifies the way data is represented on physical storage media and in RAM.​

Question 47

 A process called ____________ helps database designers create a database structure that minimizes storage space and increases processing efficiency.

Question 48

 Which database data type is used for fields that contain whole numbers-quantities, repetitions, rankings, and so on?​​ 

A) ​Logical 
B) ​Real 
C) ​Integer 
D) ​Memo

Question 49

 A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.​​ 

A) ​table 
B) ​field 
C) ​record 
D) ​relationship

Question 50

 A(n) _______________  is a field that contains data unique to a record.​ 

A) ​query 
B) ​parameter 
C) ​primary key 
D) ​key-value

Question 51

 Which of the following would not be considered a database data type?​​ 

A) ​Real 
B) SELECT​ 
C) ​BLOB 
D) Memo​

Question 52

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

Question 53

 In the context of database security, database ______ identifies sensitive data and database vulnerabilities in order to secure them.​

Question 54

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

Question 55

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

Question 56

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

A) ​database structure 
B) ​computed field 
C) ​field format 
D) ​field validation rule

Question 57

 A lookup routine validates an entry by checking data in an in-house or third-party database.​ 

Question 58

 In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.​ 

Question 59

 There are three core elements in a relational database: fields, ________, and relationships.​

Question 60

 ​The goal of normalization is to minimize data redundancy. 

Question 61

 A report ____________ contains the outline or general specifications for a report.​

Question 62

 Exploits that use malicious SQL statements to gain unauthorized access to a database are called SQL _____________.​

Question 63

 The goal of ______________ is to minimize data redundancy.​

Question 64

 A(n) __________ is the column of data in a database that is used as the basis for rearranging the data.​ 

A) ​primary key 
B) ​sort key 
C) ​data type 
D) ​key-value

Question 65

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

Question 66

 SQL ____________ are detailed specifications for a command.​

Question 67

 SQL statements contain command words but do not contain data.​ 

Question 68

 Modifications to the contents of a database field are made by using the SQL _________ command.​

Question 69

 A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.​

Question 70

 The SQL query language provides a collection of special command words called SQL ______________.​

Question 71

 SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.​ 

Question 72

 Which of the following is not a SQL keyword?​ 

A) ​DELETE 
B) ​REMOVE 
C) ​CREATE 
D) ​SELECT

Question 73

 Computer programming languages designed for databases are called _________ languages because one of their main capabilities is to request data from a database​

Question 74

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

Question 75

 SQL keywords must be entered in all uppercase letters because they are case-sensitive.​ 

Question 76

 A(n) ________________ is a software tool for specifying the content and format for a database report. ​ 

A) ​report generator 
B) database index​ 
C) ​sort key 
D) ​primary key

Question 77

 One of the most common database operations is to query for a particular record or group of records by using the ________ command.​

Question 78

 A table's physical sort order is the order in which records are arranged on storage devices.​ 

Question 79

 ​Which SQL keyword is used to search for records? 

A) ​FIND 
B) ​SEARCH 
C) ​SELECT 
D) ​UPDATE

Question 80

 The SQL command word _________ removes a record from a table.​