摘要:數(shù)據(jù)系統(tǒng)工程師上午考試為基礎(chǔ)知識,希賽小編為大家整理了2020年數(shù)據(jù)系統(tǒng)工程師上午真題(六),供考生參考。
51、在數(shù)據(jù)庫系統(tǒng)中,使數(shù)據(jù)恢復(fù)到故障發(fā)生前的一致狀態(tài)的機制稱為( )。
A、恢復(fù)機制
B、備份機制
C、封鎖機制
D、事務(wù)機制
52、通過將一個關(guān)系拆分成兩個更小的關(guān)系來使其滿足范式時,必須( )來保持?jǐn)?shù)據(jù)的完整性約束。
A、用相同的屬性使兩個子關(guān)系互相關(guān)聯(lián)
B、移除兩個子關(guān)系中所有的函數(shù)依賴
C、封鎖機制
D、事務(wù)機制
53、下列描述中,( )不是分布式數(shù)據(jù)庫數(shù)據(jù)透明性的表現(xiàn)形式。
A、代碼透明性
B、分片透明性
C、位置透明性
D、模型透明性
54、分布式數(shù)據(jù)庫的 CAP理論指的是:對于一個分布式數(shù)據(jù)庫系統(tǒng),一致性、可用性和分區(qū)容錯性這三個特點,最多只能滿足( )個。
A、0
B、1
C、2
D、3
55、NOSQL數(shù)據(jù)庫的四大分類是指( )。
A、鍵值存儲數(shù)據(jù)庫,列存儲數(shù)據(jù)庫,文檔型數(shù)據(jù)庫,關(guān)系型數(shù)據(jù)庫
B、列存儲數(shù)據(jù)庫,文檔型數(shù)據(jù)庫,關(guān)系型數(shù)據(jù)庫,分布式數(shù)據(jù)庫
C、鍵值存儲數(shù)據(jù)庫,列存儲數(shù)據(jù)庫,文檔型數(shù)據(jù)庫,圖數(shù)據(jù)庫
D、列存儲數(shù)據(jù)庫,文檔型數(shù)據(jù)庫,關(guān)系型數(shù)據(jù)庫,圖數(shù)據(jù)庫
56、A database system is a ollction of itererelated data and a set of programs that allow users to access and modify these data. A major purpose of a database system is to provide users with an( )view of the data. That is, the system hides certain details of how the data are stored and maintained. For the system to be usable, it must retrieve data( )。 The need for efficiency has led designers to use complex data( )to represent data in the database. Since many database-system users are not computer trained, developers hide the complexity from users through several levels of abstraction, to simplify users' interactions with the system. Physical level is the lowest level of abstraction that describes( )the data are actually stored. Logical level is the next-higher level of abstraction that describes( )data are stored in the database, and what relationships exist among those data. View level is the highest level of abstraction that describes only part of the entire database.
A、 abstract
B、 physical
C、 administrator
D、 operator
A、 completely
B、 safely
C、 usefully
D、 fficiently
A、 files
B、 structures
C、 graphs
D、 flows
A、 how
B、 what
C、 which
D、 when
A、 how
B、 what
C、 which
D、 when
相關(guān)推薦:2020年數(shù)據(jù)庫系統(tǒng)工程師上午真題及答案解析
軟考備考資料免費領(lǐng)取
去領(lǐng)取