Deck 10: Data Management

Question 1

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

Answer 1

type​

Question 2

__________ 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

Answer 2

B

Question 3

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 3

D

Question 4

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

Question 5

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

Question 6

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 7

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

Question 8

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 9

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

Question 10

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

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

Question 11

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

Question 12

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 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

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

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

Question 21

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

Question 22

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

Question 23

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

Question 24

FileMaker Pro and Microsoft Access are DBMSs.​

Question 25

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

Question 26

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 27

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

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

Question 28

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 29

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 30

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 31

Most spreadsheet software also includes basic data management features.​

Question 32

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

Question 33

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 34

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 35

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

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

Question 36

__________ are the most commonly used database clients.​​

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

​The goal of normalization is to minimize data redundancy.

Question 45

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

Question 46

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 47

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

Question 48

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

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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 53

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

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

Question 54

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

Question 55

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 56

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

Question 57

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

Question 58

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 59

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

Question 60

 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 61

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 62

Which of the following is not a SQL keyword?​

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

​Which SQL keyword is used to search for records?

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

Question 69

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

Question 70

SQL ____________ are detailed specifications for a command.​

Question 71

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 72

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

Question 73

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 74

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

Question 75

The goal of ______________ is to minimize data redundancy.​

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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