Deck 10: Databases

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

record

Question 4

Decision makers can access analytical databases using an executive __________.

Question 5

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

Question 6

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

Question 7

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

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

Question 8

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 9

In its broadest definition, a(n) ____________ is a collection of information.

Question 10

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 11

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

Question 12

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

A) Collecting, storing, and viewing data
B) Updating and finding data
C) Organizing and distributing data
D) Providing an executive dashboard for decision makers

Question 13

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

Question 14

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

Question 15

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

A) support
B) OLAP
C) mining
D) modeling

Question 16

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

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

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

Question 19

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

Question 20

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

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

Question 21

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 22

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

Question 23

__________ is/are the most commonly used database clients.

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

Question 24

Enterprise database applications tend to have some flexibility for customization.

Question 25

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 26

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

Question 27

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 28

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

Question 29

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

Question 30

Most spreadsheet software also includes basic data management features.

Question 31

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

Question 32

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

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

Question 33

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 34

FileMaker Pro and Microsoft Access are DBMSs.

Question 35

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

Question 36

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

Question 37

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

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

Question 38

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

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

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 41

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

Question 42

A _____________ 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 43

The goal of normalization is to minimize data redundancy.

Question 44

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

Question 45

A ____________ 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 46

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

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 a collection of binary data stored in a single field of a database?

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

Question 49

A primary key is a(n) ____________ that contains data unique to a record.

Question 50

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

Question 51

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

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

Question 52

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

Question 53

Which database data type is used for fields that contain whole numbers, such as quantities, repetitions, and rankings?

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

Question 54

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

Question 55

A _______________ is a field that contains data unique to a record.

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

Question 56

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

Question 57

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 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

A ________________ is a software tool for specifying the content and format for a database report.

A) report generator
B) data output app
C) sort key
D) column template

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

The goal of ______________ is to minimize data redundancy.

Question 69

Which of the following is not an SQL keyword?

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

Question 70

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

Question 71

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

Question 72

​Which SQL keyword is used to search for records?

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

Question 73

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 74

A __________ is the column of data in a database that is used as the basis for arranging data.

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

Question 75

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

Question 76

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

Question 77

SQL ____________ are detailed specifications for a command.​

Question 78

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

Question 79

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

Question 80

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