A data mart differs from a data warehouse in these ways except ________

data warehouses receive their data from the data marts

Which of the following is not true of database recovery through reprocessing?

Reprocessing will always return the database to its exact previous state

A data warehouse database differs from an operational database because ________

C) data warehouse data are often stored in a dimensional database

Business Intelligence (BI) systems do which of the following?

Both Analyze current and past activities and Predict future events

studbud

Intro to Databases Exam 3

100 termsStudBud Administration3 plays

Imported from external platform

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

1
When Microsoft Access 2019 secures a database with just a password, the database file will be a(n) ________
*.mdw file
*.accde file
*.accdb file
*.mdb file
2
The acronym DBA refers to either the office or the manager
True
False
3
Microsoft Access 2019 uses a user-level security system
False
True
4
Which of the following is a reason that operational data are difficult to read?
Missing values
Dirty data
Non-integrated data
Slow performance of the system
5
Which is not a typical processing application for a database?
Disk Defragmenter
Web forms
User-defined triggers
SQL/Persistent Stored Modules
6
The simplest and most feasible means of recovering a database is through reprocessing
False
True
7
What is the least restrictive isolation level that will prevent phantom read problems?
Serializable
Read Committed
Read Uncommitted
Atomic Read
8
Data Mining uses statistical and mathematical techniques perform whatif analyses, make predictions, facilitate decisions
True
False
9
When creating OLAP report based on Access data, often good idea to create view equivalent query to organize data needed
True
False
10
technique in which database is returned to known state and all valid transactions are reapplied to database is known as
transaction logging
reprocessing
checkpointing
rollforward
11
50 records for customers w/ phone numbers that should use current area code 345. 10 still use an older area code of 567
inconsistent data
a "too much data" problem
dirty data
a "wrong format" problem
12
What problem occurs when a transaction reads a changed record that has not been committed to the database?
Nonrepeatable reads
Unlocked reads
Serialized reads
Dirty reads
13
Microsoft Access 2019 databases can be secured using trusted locations for database storage
False
True
14
A data mart differs from a data warehouse in these ways except ________
data mart users dont have data management expertise of warehouse employees
data marts receive their data from the data warehouse
it deals with a particular component or functional area of the business
data warehouses receive their data from the data marts
15
When distributed databases break database into sections and store the sections on different servers, this is known as
disbursing
partitioning
distributed two-phase locking
replication
16
Non-relational DBMSs associated with the NoSQL movement include all of the following except ________
Hierarchical
Column family
Document
Graph
17
Which of the following is not true of database recovery through reprocessing?
Reprocessing makes use of a database save
Reprocessing will always return the database to its exact previous state
Reprocessing takes same amount of time as did processing in the first place
Processing cannot be resumed at a precise point
18
Ensuring that each SQL statement independently processes consistent rows is known as ________
process-level consistency
serializable consistency
transaction-level consistency
statement-level consistency
19
Microsoft Access 2019 databases can be secured by deploying databases packaged with digital signatures
False
True
20
Preventing multiple applications from obtaining copies of the same record when record is about to be changed is called
concurrent processing
resource locking
serialized reading
block factoring
21
Concurrent processing of a database only poses problems when two or more processes attempt to use the same data
False
True
22
Whether a lock applies to data at the record level, page level, table level, or database level is referred to as _______
lock granularity
lock phasing
serializable locking
lock sharing
23
In a snowflake schema, each dimension table is normalized.
False
True
24
Dimensional databases use the star schema.
True
False
25
Problematic data include so-called "dirty data."
True
False
26
An ACID transaction is one that is all but ________
atomic
isolated
consistent
guaranteed
27
One way to prevent concurrent processing problems is to lock data that are retrieved for update
False
True
28
OLAP provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
False
True
29
dirty read: problem with concurrent processing when transaction rereads data already read, finds modifications/deletions
False
True
30
The term DBA refers to the ________.
data business auditor
database auditor
data business administrator
database administrator
31
Statementlevel consistency: statements within transaction access consistent rows across lifetime of entire transaction
True
False
32
Data warehouses use a(n) ________
dimensional database
either operational database or dimensional database
structured storage
operational database
33
When Microsoft Access 2019 compiles VBA code in a database, the database file will be a(n) ________
*.accde file
*.mdw file
*.accdc file
*.accdb file
34
Operational databases contain a fact table.
False
True
35
Data warehouses are populated with data prepared by extract, transform, and load (ETL) systems.
True
False
36
Dimensional databases are used for analytical data processing.
True
False
37
When Microsoft Access 2019 secures database just by storing database in trusted location, database file will be a(n)
*.mdb file
*.accde file
*.accdb file
*.mdw file
38
Although Excel create PivotTable report using Access data it does not have formatting tools that can be used with report
True
False
39
A data warehouse database differs from an operational database because ________
B) data warehouse databases do not have metadata
C) data warehouse data are often stored in a dimensional database
A) data warehouse data are not stored in tables
D) Both B and C
40
Business Intelligence (BI) systems do which of the following?
Predict future events
Analyze current and past activities
Both Analyze current and past activities and Predict future events
Record and process transactions
41
What is the least restrictive isolation level that will prevent dirty reads?
Atomic Read
Serializable
Read Uncommitted
Read Committed
42
Business Intelligence (BI) systems obtain data from three possible sources.
True
False
43
Lock granularity refers to whether lock is placed by DBMS automatically or placed by command from application program
False
True
44
Which of the following is not a means of processing databases?
Table Normalization
Programs coded in C#
Internet applications using ASP
Applications invoking stored procedures
45
Which type of lock assumes that no conflicts will occur?
Granular locks
Open locks
Optimistic locks
Shared locks
46
In the MapReduce process, the Reduce step is followed by the Map step.
False
True
47
BI systems summarize current status of business activities + compare status w/ past events but not predicted future ones
True
False
48
Business Intelligence (BI) systems support operational activities.
True
False
49
NoSQL really stands for "Not only SQL."
True
False
50
CAP theorem defines three properties of distributed database systems; consistency, availability, and partition tolerance
True
False
51
A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing
True
False
52
Business Intelligence (BI) systems fall into which of the following categories?
Reporting
Both Processing and Reporting
Both Reporting and Data mining
Processing
53
When transaction functions such a way that either all transaction actions are completed or none of them, transaction is
isolated
locked
atomic
consistent
54
What is the least restrictive isolation level that will prevent nonrepeatable reads?
Repeatable Read
Read Committed
Serializable
Read Uncommitted
55
Operational databases store historical data.
True
False
56
In the MapReduce process, the first step is the ________ step.
column family
map
super column
reduce
57
Which of the following is true about a shared lock?
It must use a two-phase locking scheme.
It locks the item from all access.
It allows only two transactions to update a record simultaneously.
It allows reads to the locked item.
58
With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released
True
False
59
When Microsoft Access 2019 creates a signed package with a digital signature, the database file will be a(n) ________.
*.mdw file
*.accdb file
*.mdb file
*.accdc file
60
Database security is easy to achieve since all security is handled by DBMS, which is single point of entry into database
True
False
61
Report delivery is more important for data mining than it is for reporting systems.
False
True
62
A Business Intelligence (BI) reporting system that uses extensions to SQL is ________.
PHP
cluster analysis
OLAP
RFM analysis
63
When Microsoft Access 2019 uses user-level security with an Access 2003 file, the database is stored in a(n) .accdb file
True
False
64
All actions in an atomic transaction are completed successfully or none of the actions are completed at all
True
False
65
We have obtained access to company's operational data. One record, we find customer age been recorded as "337." This is
a "too much data" problem
inconsistent data
non-integrated data
dirty data
66
Hadoop is a(n) ________.
distributed file system (DFS)
Web server
OODBMS
RDMBS
67
Microsoft Access 2019 databases cannot be secured by password encryption
False
True
68
Computer systems fail for which of the following reasons except?
Databases randomly changed field values
Electrical power fails
Programs have bugs
People make mistakes
69
Virtualization is using hardware and software to simulate another software application.
True
False
70
One advantage of optimistic locking is that the lock is obtained only after the transaction is processed
False
True
71
Only large database systems have a need for database administration
True
False
72
Excel 2019 cannot import Access 2019 data directly into PivotTable report, but must first place the data into worksheet
False
True
73
Additional DBA responsibilities do not include ________
editing E-R diagrams
controlling database configuration
requests of changes to existing systems
problem and error reporting
74
Generally, the more restrictive the transaction isolation level, the less the throughput of database processing
True
False
75
Business Intelligence (BI) reporting systems can do which of the following operations?
Modify data
Both Filter data and Group data
Group data
Filter data
76
Purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work
False
True
77
Transactions should be written to the log before they are applied to the database itself
False
True
78
Transaction which all steps must be completed successfully or none will be completed is called durable transaction
True
False
79
When Microsoft Access 2019 uses user-level security with an Access 2003 file, the database is stored in a(n) ________
*.accdb file
*.accde file
*.mdw file
*.mdb file
80
In comparison to reprocessing, rollforward does not involve the application programs
True
False
81
Rollback requires the use of logs, but rollforward does not
True
False
82
What problem occurs when transaction rereads data and finds new rows that were inserted by a different transaction?
Phantom reads
Unlocked reads
Serialized reads
Dirty reads
83
The purpose of concurrency control is to ________
ensure that one user's work does not interfere with another's
ensure that ASPs do not duplicate JSPs
ensure that each form has a corresponding report
ensure that triggers do not invoke stored procedures
84
Business Intelligence (BI) systems are information systems that help users analyze and use data.
False
True
85
In terms of database security, a user can be assigned many roles, and a role can be assigned to many users
True
False
86
Apache Cassandra is an example of a column family database.
False
True
87
Data mining applications are used to accomplish all of the following tasks except ________
make predictions
perform what-if analysis
incorporate results into some other report/system
classify entities
88
Excel 2019 allows us to connect directly to an Access 2019 database when building a PivotTable.
True
False
89
Apache Cassandra is an example of a(n) ________ non-relational DBMS.
Graph
Object-Oriented
Column family
Key-value
90
BI reporting systems are used to filter data, sort data, group data and make simple calculations based on the data
True
False
91
A data mart is a collection of data that addresses a particular component or functional area of a business.
True
False
92
Column family databases are indistinguishable from relational database tables.
True
False
93
Two-phase locking can be used to ensure that transactions are serializable
False
True
94
To create an OLAP report for an Access 2019 database, use the PivotTable tool in Excel 2019.
True
False
95
The term drill down refers to the capability of seeing the data in smaller and smaller units.
False
True
96
The simplest way to lease cloud services is SaaS.
True
False
97
When distributed databases create copies of the database on different servers, this is known as ________
distributed two-phase locking
replication
division
partitioning
98
A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center.
True
False
99
Which of the following is true about data mining applications?
C. Report delivery more difficult than report delivery for reporting system
A. They use sophisticated mathematical techniques.
D. Both A and B
B. They use sophisticated statistical techniques.
100
Big Data is the name given to the enormous datasets generated by Web 2.0 applications.
False
True

Intro to Databases Exam 3 Flashcards | StudBud