i) Client needs_______ a through which it can submit operations and obtain a res

Question

i) Client needs_______ a through which it can submit operations and obtain a result
ii) The_______ establishes what operations can be performed over the system and how they take place.
iii) ___________ enforces the business rules
a. Presentation layer b. Application logic c. Resource Management
iv) ______________ establishes the business processes
b. Presentation layer b. Application logic c. Resource Management
v) The deals with the organization (storage, indexing, and retrieval) of the data necessary to support the application
vi) A is a collection of actions that belong logically together
vii) When a transaction is aborted none of the updates is reflected in the database T/F
viii) Abort might be ______________
c. user-induced b. system-induced c. a or b d: none
ix) Integrity constraints act as ________ determining whether a transaction is acceptable or not.
d. Pipe b. Filter c. Stone d. Screw
x) Replication means to generate different copies of data. (T/F)
xi) “ Execution of concurrent transactions controlled such that result the same as if executed serially”, is the ___________ property of transaction.
e. Isolation b. Atomic c. Consistency d. Durable
xii) Enforced by a concurrency control protocol
f. Isolation b. Atomic c. Consistency d. Durable
xiii) Committed updates persistent despite failures is the concern of
g. Isolation b. Atomic c. Consistency d. Durable
xiv) solved by replication: database backups, mirrored disks, etc.

Explanation / Answer

Dear user,

i) Client needs Presentation layer a through which it can submit operations and obtain a result.

iv) Application logic establishes the business processes.  

v)Resource Manager deals with the organization (storage, indexing, and retrieval) of the data necessary to support the application

vi)A transaction is a collection of actions that belong logically together.

vii) When a transaction is aborted none of the updates is reflected in the database (False)

viii) Abort might be d. none because,abort might be restart the transaction or kill the transaction.

ix)Integrity constraints act as Filter determining whether a transaction is acceptable or not.

x) Replication means to generate different copies of data. (True)

xi) “ Execution of concurrent transactions controlled such that result the same as if executed serially”, is the Isolation property of transaction.

xii) Enforced by a concurrency control protocol Isolation

xiii) Committed updates persistent despite failures is the concern of d. Durable

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.