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

Reprocessing will always return the database to its exact previous state

Which of the following is true about a shared lock?

It allows reads to the locked item.

studbud

Intro to Databases Exam 3

100 termsStudBud Administration3 plays

Imported from external platform

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

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

Intro to Databases Exam 3 Flashcards | StudBud

Intro to Databases Exam 3

100 termsStudBud Administration3 plays

Imported from external platform

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

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