問題詳情
23 有關延遲更新(deferred update)的資料庫回復(database recovery)技術之敘述,下列何者正確?
(A)所有交易之操作將先寫入資料庫內,然後再寫入系統日誌(system log)
(B)若在交易完成前,資料庫發生故障,資料庫管理系統將執行重作(redo)指令
(C)若在交易完成且送出提交確認(commit)指令,但在寫入資料庫之前發生故障,資料庫管理系統將須執行取消(undo)指令
(D)資料庫回復的延遲更新技術是基於「優先寫入日誌檔」(write-ahead logging, WAL)之機制
(A)所有交易之操作將先寫入資料庫內,然後再寫入系統日誌(system log)
(B)若在交易完成前,資料庫發生故障,資料庫管理系統將執行重作(redo)指令
(C)若在交易完成且送出提交確認(commit)指令,但在寫入資料庫之前發生故障,資料庫管理系統將須執行取消(undo)指令
(D)資料庫回復的延遲更新技術是基於「優先寫入日誌檔」(write-ahead logging, WAL)之機制
參考答案
答案:D
難度:適中0.666667
統計:A(0),B(1),C(0),D(2),E(0)
內容推薦
- 某工程師從其工廠生產出的燈泡中隨機抽出10個燈泡,得出平均壽命如下(單位:百小時)19,18,17,16,18,17, 16,18,20,16,已知該製程之燈泡整體壽命標準差爲1 (百小時),試
- Gina: How do you like the birthday gift from your dad and mom? Bella: ____________ (A) Well, I
- 22 資料庫生命週期(database life cycle, DBLC)主要包括六個階段:①資料庫設計(database design)②實作建置與資料載入(implementation and l
- How much did it ____ them to buy two movie tickets?They spent $500 _______ the two movie tickets
- 【題組】(A) spend (B) cost (C) take (D) pay
- John and Susan gave(給)____________ a nice jacket as(當作)a Christmas gift. (A) I (B) me (C) mine
- Max: What can we do for Mom this Mother’s Day?Jay: ____________ She can use them every day, an
- 21 有關資料倉儲運算之敘述,下列何者正確?(A)下鑽(drill-down)是指將維度資料旋轉,可讓查詢者看到不同的資料維度(B)切片(slice)是將某個維度設成一個區間,以查詢資料(C)切塊(d
- 【題組】(A) in the corner (B) around the corner(C) at the corner (D) on the corner of
- Let’s go to the museum ____________ the morning ____________ August (A) in; at (B) in; of (
內容推薦
- I didn’t hand in (繳交) my homework on time, so myteacher looked ______ at me. (L4)(A) angry (B) h
- 24 知識發掘流程(knowledge discovery process)主要包括五個階段:①資料清理(data cleaning) ②來源選擇(source selection) ③評估與解釋(e
- 【題組】What didn’t they eat in Penghu?(A) Seafood. (B) Ice cream.(C) Pumpkin rice noodles. (D) Frie
- 25 資料庫設計流程主要包括六個階段:①需求分析(requirement analysis) ②邏輯資料庫設計(logicaldatabase design) ③綱目改良(schema refinem
- Tom: What are you doing, Andy?Andy: I’m (41) fried noodles. Tom: Can you?Andy: (42) Just buy som
- 一、下列是一個大學的資料模型的片段,有四個實體:學生、大學生、研究生、老師。⑴學校只有兩種學生:大學生、研究生,這兩種身分是不重疊的,亦即是研究生就不會是大學生;反之,亦同。⑵每位學生都要選擇一位老師
- 二、UML(Unified Modeling Language 統一模型化語言)中有所謂四大基本關係:Dependency(相依)、Association(關聯)、Generalization(繼承)
- ( )A:You ___ late! Everyone is waiting for you.B:Sorry. The traffic ____ terrible.(A) are; are (B
- 【題組】⑵「Association」符號圖型為一條實線,除了實線外,它還可以有那些附加說明,以充實其語意。(10 分)
- ( )A: ____ Zack and Cody both heavy?B: No. Only Zack was.(A) Are (B) Were (C) Was (D)Is
- ( )A:The chicken salad is great. Do you want some?B:______ I like chicken salad.(A) Why not? (B)
- 三、試解釋下列之名詞:(每小題 5 分,共 10 分)【題組】⑴關聯式資料庫(Relational database)
- Richard and Tony are good (1) music. Theyare (2) the school band. Richard is the guitar player andTo
- ( )A: ____B: No. We were in the same class before, but we aren’t now.(A) Are you and Vivian classm
- Mom: Can’t you carry the bags for me?Allen: Yes, I ________.(A) can (B) don’t (C) do (D) can’t
- ( ) Abby: Does your mom _______ dinner for you?Cindy: Yes, she ________.(A) cook ; do (B) cooks;
- 【題組】⑵資料流程圖(Data flow diagram)
- 【題組】2) (A) in (B) to (C) on (D) for
- Look! The big bad wolf is coming ________ the threelittle sheep! Please do something.(A) about (B)
- A cantilever beam of rectangular cross section isisubjected to a concentrated load at the free end
- ( ) Ben: What time do you do your homework, Gary?Gary: _____________(A) For five hours. (B) On Fr
- ( )下列各「 」中的詞語,何者詞性相同? (A)她已經聽見這句「輕薄」的話了/他是一位莊重自愛的人,沒有人會想去「輕薄」他 (B)我會謹記母親的「教訓」/這位母親正嚴厲「教訓」犯錯的孩子 (C)
- 【題組】3) (A) practice (B) don’t practice (C) can practice(D) practicing
- The students can play ______ very well. They all like it.(A) piano (B) flute (C) violin (D) tennis
- ( )____ people go there to take a walk or tohave a cup of coffee.(A) A few (B) Much (C) A little(D