Question

I need help with these questions on Normalization, Transaction, and Query processing.

1)

Which of the following has “all-or-none” property in Transaction processing?

a) Atomicity

b) Durability

c) Isolation

d) All of the mentioned

2)

Which one of the following is always a single-valued attribute?

a) a person’s phone number

b) a person’s address

c) a person’s age

d) a person’s car

3)

__________ states that only valid data will be written to the database.

a) Consistency

b) Atomicity

c) Durability

d) Isolation

4)

A transaction is delimited by statements (or function calls) of the form __________.

a) Start transaction and Stop transaction

b) Begin transaction and End transaction

c) Get transaction and post transaction

d) Read transaction and write transaction

Answer 1

1) a

Explanation:

Atomicity property  has “all-or-none” property in Transaction processing i.e Either all operations of the transaction are reflected properly in the database, or none are.

2) c

Explanation:

a person’s age  is always a single-valued attribute.

Age always single value .i.e no person has two ages.

3)a

Explanation:

Consistency property states that only valid data will be written to the database.

If for some reason, a transaction is executed that violates the database’s consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules.

4) b

Explanation:

The transaction consists of all operations executed between the begin transaction and end transaction.