If a Transaction executes $2$ SQL Statements and the $2$nd Statement can only occur after the $1$st Statement has completed, which of the following Transaction Properties is met for the database to be in a consistent state?

Group of answer choices

A$.$ Atomicity

B$.$ Consistency

C$.$ Isolation

D$.$ Serializability

Flag this Question

Question $521$ pts

Which of the following phenomenon occurs to a database, when two transactions T$1$ and T$2$ are executed concurrently and the first transaction T$1$ is rolled back after the second transaction T$2$ has already accessed the uncommitted data?

Group of answer choices

A$.$ Lost Updates.

B$.$ Uncommitted Data.

C$.$ Inconsistent Retrievals.

D$.$ Inconsistent Aborts.

Flag this Question

Question $531$ pts

There is a need for order in which the operations within concurrent transactions are executed. Which of the following programs ensures this in a database management system?

Group of answer choices

A$.$ Access control

B$.$ Database administrator

C$.$ Scheduler

D$.$ Transaction log

Flag this Question

Question $541$ pts

Which one of the following is not part of the main database transaction properties?

Group of answer choices

A$.$ Atomicity

B$.$ Consistency

C$.$ Durability

D$.$ Individuality

Flag this Question

Question $551$ pts

What is the problem brought about by the growing number of remote locations over greater distance for a centralized database management system?

Group of answer choices

A$.$ High costs

B$.$ Performance degradation

C$.$ Reliability problems

D$.$ Scalability problems

Flag this Question

Question $561$ pts

Identify a distributed database management system drawback.

Group of answer choices

A$.$ Data located in demand proximity

B$.$ Lack of standards

C$.$ New sites can be added independently of other operation sites

D$.$ Processor independence

Flag this Question

Question $571$ pts

What is one advantage of replicating database fragments?

Group of answer choices

A$.$ Data redundancy

B$.$ Database dependence

C$.$ Improves data availability

D$.$ Participation intolerance

Flag this Question

Question $581$ pts

What is the purpose of a two$-$phase commit protocol?

Group of answer choices

A$.$ To ensure consistent database state during committing of changes

B$.$ To save only changes in a central database

C$.$ To save changes made to a database that were not saved before a power outage

D$.$ To reserve any changes made by a user

Flag this Question

Question $591$ pts

Which of the following Distributed Database Management System $($DDBMS$)$ components is found in each computer, and receives and processes the applications data requests both remote and local?

Group of answer choices

A$.$ Computer Workstation.

B$.$ Network Hardware and Software Components

C$.$ Communications Media

D$.$ Transaction Processor.

Flag this Question

Question $601$ pts

A company is considering using the cloud platform for data storage. What is the benefit of using this platform?

Group of answer choices

A$.$ Cost$-$effectiveness

B$.$ Legacy hardware

C$.$ Legacy software

D$.$ Data access