Question

In: Computer Science

Which of the following best describes the isolation property in regards to transactions? A)Either all actions...

Which of the following best describes the isolation property in regards to transactions?

A)Either all actions in a transaction are executed or no actions are done

B)The DBMS changes from one consistent state to another consistent state when a transaction completes successfully

C)A transaction executes with the same outcome, without any impact from other transactions executing concurrently

D)The DBMS guarantees that changes are made persistently upon successful completion of a transaction

2)Which of the following statements best describes a phantom read

A)One user reads a set of rows from a table. Another user inserts a row that matches the where condition read by the first user. The first user reads the same set of rows again getting the new row in addition to the rows that the user read the first time.

B)A select from one user calculating a summary or aggregate function (e.g. avg, max, sum, etc.) reads some rows from a table. At the same time another user is updating some of those same rows to contain different values. The first user reads some of the rows before the update changes them and reads some rows after the update changes them.

C)Two users update the same columns of the same row of the same table at the same time. One update will be overwritten by the other.

D)One user reads the same row more than once. Between the reads, an update from another user modifies the row.

3)If a schedule’s dependency graph is cyclic, then the schedule it describes is serializable.

A)True

B)False

4)By themselves, exclusive write locks and shared read locks do not guarantee serializabililty.

A)True

B)False

Solutions

Expert Solution

Answer:-------------

Q:- 1) Which of the following best describes the isolation property in regards to transactions?
Answer:-------
C) A transaction executes with the same outcome, without any impact from other transactions executing concurrently

Q:- 2) Which of the following statements best describes a phantom read.
Answer:----------
A)One user reads a set of rows from a table. Another user inserts a row that matches the where condition read by the first user. The first user reads the same set of rows again getting the new row in addition to the rows that the user read the first time..

Q:- 3) If a schedule’s dependency graph is cyclic, then the schedule it describes is serializable.
Answer:---------
B)False

Q:- 4) By themselves, exclusive write locks and shared read locks do not guarantee serializabililty.
Answer:---------
A)True


Related Solutions

Which of the following best describes phenotypic plasticity?a) It is a property of “species”, not...
Which of the following best describes phenotypic plasticity?a) It is a property of “species”, not “individuals”.b) Is only found in species with complex societies.c) The expression of phenotype with little input from the environment.d) A given genotype may result in different phenotypes.
which of the following best describes the mass of an object? a. A physical property and...
which of the following best describes the mass of an object? a. A physical property and intensive property b. A chemical and intensive property c. An intensive and extensive property d. An extensive property and physical property
Which of the following best describes the electrical property of the lipid component of the phospholipid...
Which of the following best describes the electrical property of the lipid component of the phospholipid bilayer that makes up the membrane? A. It is a dielectric B. It is an insulator C. It is a capacitor D. It is all of the above
Which of the following best describes title insurance? Protection to an owner of property if he...
Which of the following best describes title insurance? Protection to an owner of property if he or she is unable to make mortgage payments. Protection to an owner of property against losses sustained as a result of a defective title to real estate. Protection to an owner of a property that he owns any personal property currently on his or her real estate. Protection to an owner of a property that he will receive the full appraised value of his...
Which of the following describes how property taxes work? (Check all that apply.) a Property taxes...
Which of the following describes how property taxes work? (Check all that apply.) a Property taxes are a percentage of the assessed value of residential and/or commercial property. b Like NH, Massachusetts has both state and local property taxes. c For residential property, tax rates tend to be about 1-3% (annually) of a home's assessed value. d Local taxes (such as property taxes) and fees, are used to fund local schools, roads, police, courts, trash collections, etc. e A town...
Which of the following best describes ribosomes?
Which of the following best describes ribosomes? Hollow cytoskeletal elements that act as organizers for the cytoskeleton, especially in cell division Contain digestive enzymes to breakdown non-functional organelles and foreign bodies that enter the cell The site of protein synthesis. Dense spherical body in the nucleus which are the synthesis site for ribosomal RNA and ribosomal subunits Houses all genetic material for the cell including DNA and RNA.
Which of the following properties are excepted property in regards to the special depreciation allowance? Property...
Which of the following properties are excepted property in regards to the special depreciation allowance? Property placed into service and disposed of in the next tax year. Property converted from personal use to business use in the same or later tax year. Property on which the taxpayer uses the Alternative Depreciation System. Listed property used 50% or less for business.
Which of the following best describes active surveillance?
Which of the following best describes active surveillance?
Which of the following best describes cis-transisomers?
Which of the following best describes cis-transisomers?They are mirror imagesThey have variations in arrangements around carbon carbon double bondsThey have different molecular formulasThey have the same chemical propertiesNone of the above
Which one of the following best describes a broker?
Which one of the following best describes a broker?A.intermediary who arranges trades between a buyer and a sellerB.trader who buys and sells from his or her inventoryC.firm which charges a commission for arranging a transactionD.person who buys securities for his or her own account on an exchange floorE.trader who transacts business on behalf of a securities issuer
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT