2016年5月计算机技术与软件《中级数据库系统工程师（上午卷）》试题（网友回忆版）

In the fields of physical security and information security, access control is the selective restriction of access to a place or other resource.The act of accessing may mean consuming,entering, or using.Permission to access a resource is called authorization（授权）.An access control mechanism（　）between a user （or a process executing on behalf of a user） and system resources, such as applications, operating systems, firewalls; routers, files,and databases.The system must first authenticate（验证）a user seeking access.Typically the authentication function determines whether the user is （　） to access the system at all.Then the access control function determines if the specific requested access by this user is permitted.A security administrator maintains an authorization database that specifies what type of access to which resources is allowed for this user.The access control function consults this database to determine whether to（　） access.An auditing function monitors and keeps a record of user accesses to system resources.In practice, a number of（　）may cooperatively share the access control function.All Operating systems have at least a rudimentary（基本的）.and in many cases a quite robust, access control component.Add－on security packages can add to the （请作答此空）access control capabilities of the OS.Particular applications .or utilities, such as a database management system, also incorporate access control functions.External devices, such as firewalls, can also provide access control services .

In the fields of physical security and information security, access control is the selective restriction of access to a place or other resource.The act of accessing may mean consuming,entering, or using.Permission to access a resource is called authorization（授权）.An access control mechanism（　）between a user （or a process executing on behalf of a user） and system resources, such as applications, operating systems, firewalls; routers, files,and databases.The system must first authenticate（验证）a user seeking access.Typically the authentication function determines whether the user is （　） to access the system at all.Then the access control function determines if the specific requested access by this user is permitted.A security administrator maintains an authorization database that specifies what type of access to which resources is allowed for this user.The access control function consults this database to determine whether to（请作答此空） access.An auditing function monitors and keeps a record of user accesses to system resources.In practice, a number of（　）may cooperatively share the access control function.All Operating systems have at least a rudimentary（基本的）.and in many cases a quite robust, access control component.Add－on security packages can add to the （　）access control capabilities of the OS.Particular applications .or utilities, such as a database management system, also incorporate access control functions.External devices, such as firewalls, can also provide access control services .

使用150DPI的扫描分辨率扫描一幅3×4英寸的彩色照片，得到原始的24位真彩色图像的数据量是（　）Byte。

进程P1、P2、P3、P4和P5的前趋图如下图所示：

若用PV操作控制进程P1、P2、P3、P4和P5并发执行的过程，则需要设置5个信号量S1.S2.S3.S4和S5，且信号量S1～S5的初值都等于零。下图中a和b处应分别填写（请作答此空）；c和d处应分别填写（　），e和f处应分别填写（　）。

进程P1、P2、P3、P4和P5的前趋图如下图所示：

若用PV操作控制进程P1、P2、P3、P4和P5并发执行的过程，则需要设置5个信号量S1.S2.S3.S4和S5，且信号量S1～S5的初值都等于零。下图中a和b处应分别填写（　）；c和d处应分别填写（请作答此空），e和f处应分别填写（　）。

In the fields of physical security and information security, access control is the selective restriction of access to a place or other resource.The act of accessing may mean consuming,entering, or using.Permission to access a resource is called authorization（授权）.An access control mechanism（　）between a user （or a process executing on behalf of a user） and system resources, such as applications, operating systems, firewalls; routers, files,and databases.The system must first authenticate（验证）a user seeking access.Typically the authentication function determines whether the user is （请作答此空） to access the system at all.Then the access control function determines if the specific requested access by this user is permitted.A security administrator maintains an authorization database that specifies what type of access to which resources is allowed for this user.The access control function consults this database to determine whether to（　） access.An auditing function monitors and keeps a record of user accesses to system resources.In practice, a number of（　）may cooperatively share the access control function.All Operating systems have at least a rudimentary（基本的）.and in many cases a quite robust, access control component.Add－on security packages can add to the （　）access control capabilities of the OS.Particular applications .or utilities, such as a database management system, also incorporate access control functions.External devices, such as firewalls, can also provide access control services .

进程P1、P2、P3、P4和P5的前趋图如下图所示：

若用PV操作控制进程P1、P2、P3、P4和P5并发执行的过程，则需要设置5个信号量S1.S2.S3.S4和S5，且信号量S1～S5的初值都等于零。下图中a和b处应分别填写（　）；c和d处应分别填写（　），e和f处应分别填写（请作答此空）。

In the fields of physical security and information security, access control is the selective restriction of access to a place or other resource.The act of accessing may mean consuming,entering, or using.Permission to access a resource is called authorization（授权）.An access control mechanism（　）between a user （or a process executing on behalf of a user） and system resources, such as applications, operating systems, firewalls; routers, files,and databases.The system must first authenticate（验证）a user seeking access.Typically the authentication function determines whether the user is （　） to access the system at all.Then the access control function determines if the specific requested access by this user is permitted.A security administrator maintains an authorization database that specifies what type of access to which resources is allowed for this user.The access control function consults this database to determine whether to（　） access.An auditing function monitors and keeps a record of user accesses to system resources.In practice, a number of（请作答此空）may cooperatively share the access control function.All Operating systems have at least a rudimentary（基本的）.and in many cases a quite robust, access control component.Add－on security packages can add to the （　）access control capabilities of the OS.Particular applications .or utilities, such as a database management system, also incorporate access control functions.External devices, such as firewalls, can also provide access control services .

关系数据库中通常包含多个表，表与表之间的关联关系通过（　）来实现，通过（请作答此空）运算将两个关联的表合并成一张信息等价的表。

In the fields of physical security and information security, access control is the selective restriction of access to a place or other resource.The act of accessing may mean consuming,entering, or using.Permission to access a resource is called authorization（授权）.An access control mechanism（请作答此空）between a user （or a process executing on behalf of a user） and system resources, such as applications, operating systems, firewalls; routers, files,and databases.The system must first authenticate（验证）a user seeking access.Typically the authentication function determines whether the user is （　） to access the system at all.Then the access control function determines if the specific requested access by this user is permitted.A security administrator maintains an authorization database that specifies what type of access to which resources is allowed for this user.The access control function consults this database to determine whether to（　） access.An auditing function monitors and keeps a record of user accesses to system resources.In practice, a number of（　）may cooperatively share the access control function.All Operating systems have at least a rudimentary（基本的）.and in many cases a quite robust, access control component.Add－on security packages can add to the （　）access control capabilities of the OS.Particular applications .or utilities, such as a database management system, also incorporate access control functions.External devices, such as firewalls, can also provide access control services .

如右图所示的并发调度，假设事务T1、T2执行前数据项X、Y的初值为X＝100，Y＝200。该调度执行完成后，X、Y的值为（请作答此空）；此类不一致性称为（　）。