首页
登录
从业资格
A transaction is an action,or a series o
A transaction is an action,or a series o
资格题库
2022-08-02
64
问题
A transaction is an action,or a series of actions,carried out by a single user or( ),that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an( )unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of( )transactions should not be visible to other transactions.Durability.The effects of a successfully completed(committed)transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only( )property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the( )and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.问题1选项A.application developerB.all usersC.application programD.DBMS问题2选项A.IndivisibleB.permanentC.infrequentD.infinite问题3选项A.completedB.incompleteC.abortedD.committed问题4选项A.atomicityB.consistencyC.isolationD.durability问题5选项A.DBMSB.DBAC.end userD.DBS
选项
答案
CABBA
解析
a transaction is an action,or a series of actions,carried out by a single user or()that accesses or changes the contents of the database.
application developer,all users,application program,DBMS
事务是由单个用户或()访问或更改数据库内容的动作或一系列动作。
应用开发人员,所有用户,应用程序,数据库管理系统
atomicity,the"all or nothing"property,A transaction is an(72)unit that is either performed in its entirety or is not performed at all.
indivisible,permanent,infrequent,infinite
原子性,“全或无”属性,事务是一个()单位,要么整体执行,要么根本不执行。
不可分割的、永久的、罕见的、无限的。
isolation,transactions execute independently of one another.in other words,the partial effects of(73)transactions should not be visible to other transactions.
completed,incomplete,aborted,committed
隔离、事务彼此独立执行。换句话说,()事务的部分效应不应该对其他事务可见。
完成,未完成,中止,提交。
the four properties above,only()property is the responsibility of the concurrency control subsystem to ensure,it is the responsibility of both the()and the application developers to ensure consistency.
atomicity,consistency,isolation,durability.
DBMS,DBA,end user,DBS
上面的四个属性,只有()属性是并发控制子系统的责任,以确保,()和应用程序开发人员都有责任确保一致性。
原子性、一致性、隔离性、耐久性。
DBMS、DBA、终端用户、DBS。
转载请注明原文地址:https://tihaiku.com/congyezige/2419916.html
本试题收录于:
中级 数据库系统工程师题库软件水平考试初中高级分类
中级 数据库系统工程师
软件水平考试初中高级
相关试题推荐
InClanguage,a()isaseriesofcharact
______occurswhenaseriesofsynchroni
用于提交和回滚事务的语句为( )。A.ENDTRANSACTION和ROLL
Atransactionisanaction,oraserieso
事务(Transaction)是一个()A.程序 B.进程 C.操作序列
Atransactionisanaction,oraseries
Atransactionisanaction,oraseries
Atransactionisanaction,oraserieso
计划(Plan)、执行(Do)、()和行动(Action),简称
计划(Plan)、执行(Do)、()和行动(Action),简称PDCA。A.
随机试题
Two-year-oldAngelicaandAngelinaSabucolovelisteningtostoriesandmusi
Overthelasttwoyears,inthePCbusinessMichaelDellhasbeenbeatenlik
有明显精神神经症状的营养性巨幼细胞贫血选择下列哪项治疗A.叶酸 B.神经营养药
患者男性,64岁。15年来反复出现咳嗽、咳白色泡沫痰,当受凉或劳累后症状加重,咯
设an=n2-9n-100(n=1,2,3…),则数列{an}中取值最小的项为(
治疗气厥虚证,应首选( )。A.安宫牛黄丸 B.补中益气汤 C.四味回阳饮
从20世纪90年代“人类基因工程”计划启动之日起,美国,日本,欧洲等展开了一场激
上海证券交易所上市交易的某只股票,2009年末的每股税后利润为0.2元,市场利
某款以某只股票价格指数为标的物的结构化产品,该产品的收益公式为:收益=面值×[8
患者,男性,27岁。劳累时心悸,胸骨后疼痛1年。查体可闻及主动脉瓣区收缩期粗糙的
最新回复
(
0
)