一起答
单选

数据库系统运行的基本工作单位是事务。事务通常以BEGIN TRANASCTION语句开始,以COMMIT或R<OI上BACK语句结束。COMMIT表示(46),ROLLBACK表示(47)。在多个事务并发执行时,系统应保证与这些事务先后单独执行时的结果一样,此时事务达到了(48)要求。

在关系SC(emp_id,emp_name,emp_phone,dept_name,dept_phone,dept_mgmame)中,有函数依赖:(1)emp_id→emp_name,emp_phone,dept_name:(2)dept_name→ dept_phone,dept_mgmame

 那么该关系满足最大范式是(49)。它的主要问题是数据冗余。如把SC分解成两个关系模式R1(50)和R2(51),则可以完全解决这一问题。

  • A.物理数据库尚未更新,事务执行失败
  • B.物理数据库尚未更新,事务执行成功
  • C.物理数据库已更新,事务执行失败
  • D.物理数据库已更新,事务执行成功
参考答案
查看试卷详情
相关试题
  1. (120)

    • A.control
    • B.inheritance
    • C.inference
    • D.connection
  2. (118)

    • A.mark
    • B.picture
    • C.symbol
    • D.notation
  3. (119)

    • A.instance
    • B.example
    • C.existence
    • D.implementation
  4. (117)

    • A.problem
    • B.solution
    • C.data
    • D.program
  5. (115)

    • A.assignment
    • B.design
    • C.value
    • D.dispatch
  6. Traditional structured analysis techniques focus upon the flow of(71)within a system. Object - oriented analysis emphasizes the building of real - world models. It examines requirements from the perspective of the classes and objects found in the vocabulary of the(72)domain.

    Traditional system design method emphasizes the proper and effective structure of a complex system. Object -oriented design method encompasses the process of object -oriented decomposition and a(73)for depicting both logical and physical as well as static and dynamic models of the system under design.

    Object - oriented programming is a method of implementation in which programs are organized as cooperative collections of objects, each of which represents an(74)of some class, and whose classes are all members of a hierarchy of classes united via(75)relationships.

    • A.control
    • B.program
    • C.data
    • D.reference
  7. (114)

    • A.tranverse
    • B.transportation
    • C.transmmision
    • D.translation
  8. (113)

    • A.middle
    • B.intermediate
    • C.previous
    • D.final
  9. (110)

    • A.above
    • B.upon
    • C.against
    • D.with
  10. A typical(66)language contains an applicative sub-language which approximates the mathematical abstractions of "timeless" functions applied to "spaceless" values, where the actual operation sequences and use of storage space during expression evaluation are organized behind the(67). In this setting, values are data structures of low volume, typically a few computer words or less, which means that an illusion of spacelessness can be realized by having(68)results during expression evalution stored at the discretion of the language implementation, and effecting parameter(69)and(70)operations through value copying.

    • A.imperative
    • B.mandatory
    • C.compulsory
    • D.voluntary