Deck 10: Databases

Question 1

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

Answer 1

dashboard​

Question 2

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

Answer 2

False

Question 3

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

Answer 3

database​

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

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

Question 9

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

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

__________ 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 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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 17

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

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

Question 18

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

Question 19

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 20

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 21

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 22

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

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

Most spreadsheet software also includes basic data management features.​

Question 25

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

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

Question 26

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 27

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

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

Question 28

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

Question 29

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

Question 30

__________ are the most commonly used database clients.​​

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

Question 31

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 32

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

Question 33

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

Question 34

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 35

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

Question 36

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

Question 37

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

Question 38

FileMaker Pro and Microsoft Access are DBMSs.​

Question 39

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 40

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

Question 41

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

Question 42

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

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

Question 43

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

Question 44

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 45

​The goal of normalization is to minimize data redundancy.

Question 46

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

Question 47

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 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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 58

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

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

Question 59

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 60

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 61

Which of the following is not a SQL keyword?​

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

Question 62

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

Question 63

SQL ____________ are detailed specifications for a command.​

Question 64

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

Question 65

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 66

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

Question 67

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

Question 68

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

Question 69

The goal of ______________ is to minimize data redundancy.​

Question 70

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

Question 71

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

Question 72

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

Question 73

​Which SQL keyword is used to search for records?

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

Question 74

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

Question 75

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 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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.​