Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

LIS 3784 > Ch. 10/P2 > Flashcards

Ch. 10/P2 Flashcards

1
Q 
The main database transaction properties are atomicity, consistency, durability, isolation,
and \_\_\_\_\_\_\_\_.
a. serializability
b. capability
c. concurrency
d. transitivity
A

a. serializability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q 
In database terms, a(n) \_\_\_\_\_\_\_\_ is any action that reads from and/or writes to a
database.
a. lock
b. session
c. transaction
d. interaction
A

c. transaction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A ________ database state is one in which all data integrity constraints are satisfied.

a. fixed
b. secure
c. complete
d. consistent

A

d. consistent

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

If any of the SQL statements in a transaction fail, the entire transaction is ________ to
the original database state that existed before the transaction started.
a. abandoned
b. completed
c. rolled back
d. diverted

A

c. rolled back

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q 
All transactions are controlled and executed by the DBMS (subject to some limitations) to
guarantee database \_\_\_\_\_\_\_\_.
a. uniqueness
b. integrity
c. consistency
d. design
A

b. integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a database request?

a. A series of SQL statements that implement all of the business rules in an application.
b. One or more SQL statements that implement one business rule.
c. A single SQL statement in an application program or transaction.
d. A transaction.

A

c. A single SQL statement in an application program or transaction.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Each database request generates several ________.

a. input/output (I/O) operations
b. transactions
c. business processes
d. SQL statements

A

a. input/output (I/O) operations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The ________ statement is used to end a successful transaction.

a. COMMIT
b. DONE
c. END
d. QUIT

A

a. COMMIT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which DBMS does not support transaction management by default?
a. MS Access
b. Oracle
c. DB2
d. SQL Server
(Also, MySQL default tables, MyISAM, does not support transactions.)

A

a. MS Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q 
\_\_\_\_ requires that all operations of a transaction be completed; if not, the transaction is
aborted.
a. Atomicity
b. Durability
c. Consistency
d. Isolation
A

a. Atomicity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

____ means that the data used during the execution of a transaction cannot be used by
a second transaction until the first one is completed.
a. Isolation
b. Atomicity
c. Durability
d. Consistency

A

a. Isolation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

________ ensures that once transaction changes are done, they cannot be undone or
lost, even in the event of a system failure.
a. Consistency
b. Isolation
c. Atomicity
d. Durability

A

d. Durability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which property is especially important in a multiuser database?

a. Consistency
b. Atomicity
c. Serializability
d. Durability

A

c. Serializability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

If several concurrent transactions are executed over the same data set and the second
transaction updates the database before the first transaction is finished, the ________
property is violated and the database is no longer consistent.
a. atomicity
b. consistency
c. durability
d. isolation

A

d. isolation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q 
When a(n) \_\_\_\_\_\_\_\_ statement is reached, all changes are permanently recorded within
the database.
a. DONE
b. EXIT
c. COMMIT
d. ROLLBACK
A

c. COMMIT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When the end of a program is reached, all changes are permanently recorded within the
database; this action is equivalent to issuing the ________ statement.
a. EXIT
b. BYE
c. COMMIT
d. ROLLBACK

A

c. COMMIT

17
Q 
When a program is abnormally terminated, the equivalent of a(n) \_\_\_\_\_\_\_\_ command
occurs.
a. COMMIT
b. ROLLBACK
c. QUIT
d. EXIT
A

b. ROLLBACK

18
Q

According to the ANSI SQL standard, when does a transaction begin?

a. with the BEGIN TRANSACTION command
b. when the first SQL statement is encountered
c. with use of the START command
d. with the BEGIN command

A

b. when the first SQL statement is encountered

19
Q 
A DBMS uses a transaction \_\_\_\_\_\_\_\_ to keep track of all transactions that update the
database.
a. block
b. log
c. statement
d. table
A

b. log

20
Q

Part of the data stored in the transaction log is a(n) ________ to the previous and next
transaction log entries for the same transaction.
a. rowid
b. pointer
c. id
d. link

A

b. pointer

LIS 3784 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions