問題詳情
48. 當資料庫未執行「並行(Concurrency)控制」時,在資料分享上遭遇的問題,是以下何者?①資料異動遺失(Lost update)②未確認資料相依(Uncommitted dependency)③ 不一致資料分析(Inconsistent analysis) ④ 循序式存取(Sequential access)?
(A)① ②③
(B)①②④
(C)① ③ ④
(D) ② ③ ④ 。
參考答案
答案:A
難度:計算中-1
書單:沒有書單,新增
內容推薦
- 要修改關聯綱要中某個欄位的名稱與資料型態,應使用下列哪一個語法? (A) FORMATTABLE (B) CREATE TABLE (C) UPDATE TABLE (D) ALTER TAB
- 下列何者不是關聯式資料庫進行高度正規化設計所帶來的現象? (A)查詢速度大幅提升(B)不易發生更新時的異常現象 (C)查詢時進行較多的合併運算 (D)大幅減少資料重複。
- 下列SQL指令,何者不屬於資料操作語言(DML)? (A) SELECT (B) GRANT (C) UPDATE(D) INSERT。
- 應用程式存取 SQL Server 上的資料庫可以透過許多技術,以下何者錯誤? (A) OLE DB (B)DBCOM (C) ODBC (D) Embedded SQL。
- 資料庫設計中,每一個資料表設計的主鍵(Primary key)需符合以下何者之特性?(A) 樹狀鍵(Tree) (B) 候選鍵(Candidate key) (C) 超級鍵值(Superkey
- 屬於 ANSI/SPARC 資料庫模式的三層架構,是以下何者? (A)實體層(Physical) (B)關聯式(Relational) (C)中介層(Middle-ware) (D)外部層(E
- 對於資料庫管理系統(DBMS)的資料庫架構,以下何者錯誤? (A)層次結構(Hierarchical) (B)樹狀結構(Tree) (C)結構(Network) (D)關聯結構(Relatio
- 對於關聯式代數(relational algebra)之運算子,以下何者在執行時最耗時間與記憶體空間? (A)Select (B) Project (C) Union (D) Join。
- 若要從關聯式資料庫中刪除名為 member 的視界(View),應使用下列哪一個語法? (A)DELETE FROM member (B) TRUNCATE member (C) DELETE
- 欲在資料表中統計今日交易系統中的總扣款金額,應使用下列哪一個函數? (A) COUNT()(B) MAX() (C) SUM() (D) AVG()。
內容推薦
- 資料庫系統開發流程中,將客戶需求變成 Entity-Relation 圖的階段是以下何者? (A)系統需求搜集與分析 (B)系統實作 (C)概念設計 (D)資料庫管理系統選擇。
- Don’t worry. There a lot of dumplings in thekitchen.(A) is (B) are (C) has (D) have
- Look at yourself. You’re eighty years old and aren’t ________ at all. (A) married (B) light (C) yo
- We are all _____ at the _____ news.(A) surprised; surprised (B) surprising; surprising(C) surpri
- Jane isn’t in Taiwan now. She ____ to China.(A) has gone (B) has been (C) will go (D) goes
- Some people believe ___ there are ghosts in the world.(A) × (B) to (C) what (D) this
- Peter has to finish his report, _____ he?(A) hasn’t (B) doesn’t (C) isn’t (D) wasn’t
- 選出正確的句子。(A) It’s been a long time since I see him last time.(B) I’ve not had dinner already.(C)
- Mary is excited about ______ jogging with Brad.(A) go (B) goes (C) going (D) to go
- Sue seldom gets up early, ______ ?(A) isn’t she (B) is she (C) doesn’t she (D) does she
- A: Have you ever ridden a horse? B: _____(A) Yes, I have to. (B) No, I never do.(C) Yes, I ever
- A: I’m going to Sofia Pizza House. Are you comingwith me? B: No, thanks. ____ I’ll eat some dump
- 【題組】(A) that (B) what (C) this (D) to
- 【題組】(A) flyer (B) one (C) store (D) another
- 【題組】(A) interest (B) interesting (C) interested (D) interests
- 【題組】(A) scared (B) afraid (C) proud (D) scary
- 【題組】(A) around the corner (B) day after day(C) door to door (D) so far so good
- 【題組】(A) bats (B) candy (C) bodies (D) oil
- 【題組】(A) carry (B) carried (C) carrying (D) to carrying
- 【題組】(A) × (B) which (C) this (D) what
- 【題組】Which is NOT true?(A) Neal is interested in collecting stamps.(B) Stamps have been around fo
- 【題組】Why did Susie want to forget everything bad in hermind?(A) Her parents asked her to do so.(B
- 【題組】What happened after Susie died?(A) She tried to catch the murderer herself.(B) She could see
- Miss Wang: Find a seat and sit down. _________ quiet in this room. Students: OK.(A) Is (B) Are (
- Though Steve was poor and sick, he never ________ any chance to write. That is why he finally bec