阿摩線上測驗
登入
首頁
>
高等資料庫設計
>
100年 - 100 高等考試_二級_資訊處理:高等資料庫設計#45001
>
題組內容
五、若 Wi(M)表示一個交易 Ti 將名為 M 的資料寫入資料庫中,Ri(M)表示一個交易 T,將名 為 M 的資料庫資料讀入程式變數中,Ci 代表交易 Ti 已提交(Commit)。下面此一排程 R1(X),R2(Y),W1(X),W2(Y),R3(Y),R1(Y),C2,W4(X),W3(Y),C3,W1(Y),W4(Y),C4,C1 是否具有以下性質,並說明原因:
⑴衝突可序列性(Conflict-Serializable)(4 分)
其他申論題
⑴σa<50,000 R(4 分)
#150144
⑵σa=50,000 R(4 分)
#150145
⑶σa>50,000 and a<50,010 R(4 分)
#150146
⑷σa≠50,000 R(4 分)
#150147
⑵視界可序列性(View-Serializable)(4 分)
#150149
⑶可復原性(Recoverable)(4 分)
#150150
⑷無連鎖中止駁回(Avoid-Cascading-Aborts)(4 分)
#150151
⑸嚴謹性(Strict)(4 分)
#150152
⑴According to the Norwegian law, to kill a group of civilians systematically is the basic criteria for charge against humanity. The maximum penalty for this offence is 30 years in jail, rather than 21 years under the anti-terrorism law.
#150153
⑵After years of development, Taiwan has transformed to be a distinct pluralized country full of vibrant energy. The democratic politics system, unleashing diversified social forces, has taken root firmly in the life of its citizens and formed an interactive living culture.
#150154