数据库期末复习资料-数据库判断题题库.doc

1、promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming

2、 majority of the people, maximize factors, enhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. To improve social governance, stimulating social organization, innovative and effective system of

3、preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of eco

4、logical system, using the system to protect the ecological environment. To improve natural resources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection manag

5、ement system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the peoples army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions

6、 and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. To deepen the adjustment of personnel system reform in the army, military policy a

7、nd system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve the partys leadership, give full play to the core role of the party commands the overall situation and coordinating all parties,

8、improving the partys leading water . Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-pings flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost a

9、ll political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however a

10、fter economic monopolized by powerful, vested interests grow, employers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat序 号数据库判断题题库 （括号内为改正内容）题 目判断1数据是表示信息的

11、具体形式，信息是数据表达的内容。V2在数据库的三级模式结构中内模式可以有多个。（只有一个）X3数据独立性指数据的存储与应用程序无关，数据存储结构的改变不影响应用程序的正常运行。V4当数据库的存储结构改变了，由数据库管理员对模式内模式映射作相应改变，可以使模式保持不变，从而保证了数据的物理独立性。V5数据处理是将信息转换成数据的过程。（数据转换成信息）X6数据库在计算机系统中(不)是以文件方式存储的。X7数据库系统其实就是一个应用软件。(应用系统)X8三级模式结构也就是从逻辑上对数据库的组织从内到外进行的3个层次描述。V9三级模式间存在三个映射关系。(二个)X10DBMS不需要操作系统的支持就可

12、以实现其功能。(需要)X11用二维表来表示实体之间联系的模型称为网状模型。(关系模型)X12在E-R图中，用来表示属性的图形是椭圆形。V13关系模型是目前最常用的数据模型。V14属性的取值范围称为属性的域。V15同类实体的集合称为实体型。(实体集)X16关系数据库模型的3个要素分别为数据增加、数据修改、数据查询。(数据结构，关系操作，完整性约束)X17消除了部分函数依赖的1nf的关系模式必定是2nf。(反了，应该是3NF2NF,2NF1NF)X18数据表的关键字用于唯一标识一个记录，每个表必须具有一个关键字，主关键字(只能)由一个字段组成。X19按照完整性规则，外部关键字应该关联表中的字段值保

13、持一致。V20关系数据库是用树结构来表示实体之间的联系的。(层次模型)X21关系表中的每一行称作一个元组。V22关系表中的每一列称为属性。V23候选关键字和主关键字不同，不能唯一标识一个记录。(是唯一的)X24e-r图是由实体、联系和属性3要素组成。V25数据库设计包括两个方面的设计内容，它们是内模式设计和物理设计。(数据模式设计，应用程序开发)X26在e-r图中，用来表示实体的图形是菱形。(矩形)X27在e-r图中，用来表示属性的图形是椭圆形。V28SQL Server 2000由两个部分组成：服务器组件和客户端工具。V29企业管理器中只能查看连接的SQL Server 服务运行状态，不能停

14、止服务。 X30身份验证模式是在安装SQL Server 过程中选择的，系统安装之后，可以重新修改SQL Server 系统的验证模式。V31查询窗口的编辑器窗口格是一个文本编辑器，可以在这里输入 Transact-SQL 语句，执行返回的结果集显示在结果窗口。V32数据库通常被划分为用户视图和物理视图。V33tempdb数据库保存所有的临时表和临时关系。(储存过程)X34数据文件是存放数据和数据库对象的文件，一个数据库只能有一个数据文件。(还包括一个事务日志文件)X35master数据库记录SQL Server系统的所有系统信息。V36空值不同于空字符串或数值零，通常表示未填写、未知（Unk

15、nown）、不可用或将在以后添加的数据。 V37SQL Server通过限制列中数据、行中数据和表之间数据来保证数据的完整性。V38每个表至多可定义256列。(定义102列)X39删除表时，与该表相关联的规则和约束不会被删除。 (约束会被删除)X40如果对行的更新违反了某个约束或规则，或者新值的数据类型与列不兼容，则取消该语句、返回错误并且不更新任何记录。 V41在查询分析器中，查询的显示结果也可以保存，并且扩展名为.SQL。V42SELECT语句中的条件可以用WHERE或HAVING引出，但HAVING必须在GROUP BY之后使用。V43SELECT语句中的ORDER BY子句中，如果有多

16、个排序标准，它们之间是用分号分隔，查询结果与排序标准的先后顺序有关。(逗号)X44SELECT语句中的INTO可以将查询结果保存成表或文本文件。V45SELECT查询数据时，如果使用右连接，则是限制右边表的记录。(左边)X46一个表的多个属性的组合可以创建多个不同的索引。V47一个表的(一个属性)可以创建成主键索引和非聚集索引。X48非聚集索引不能保证表中索引列的数据的唯一性。V49唯一索引和(聚集索引)都能保证表记录的唯一性。X50创建视图时（不）能使用ORDER BY子句。X51可以在表或（临时表）上创建视图。X52视图是一个虚拟表，并不表示任何物理数据，而只是用来查看数据的窗口而已。V5

17、3通过视图可以修改表的属性。X54声明局部变量时不需要指明数据类型。 X55变量就是同时可以有多个值的量。X56SELECT和SET都可以为一个局部变量赋值。(UPDATE)X57在程序中写的注释必须单独占一行。X58在程序设计中，语句块 BEGINEND 可有可无。V59删除表时，默认对象也会自动删除。(默认对象不会自动删除)X60创建规则时,规则表达式可以包括表的列名。X61外键的值(唯一的)标识了表中的一行记录。X62并发性就是两个或两个以上的用户同时对数据执行的操作。V63事务死锁后,不用关机也可以解除死锁。V64一组相同的T-SQL语句可以在查询分析器中执行，也可以保存为存储过程后执

18、行，二者没有区别。X65以“sp_”为前缀的存储过程为系统存储过程，命名本地存储过程的时候，避免使用“sp_”前缀。V66存储过程在每次执行前都需要编译。X67存储过程允许嵌套，即在一个存储过程中可以调用其他存储过程。X68触发器是一种特殊类型的存储过程，可以直接通过名字调用。X69根据函数返回值形式的不同将用户自定义函数分为3种类型。V70使用用户定义函数的方法与使用SQL Server2000内置函数的方法完全相同。X71用户对“学生”表的SELECT权限为禁止，但该用户所属角色具有“学生”表的SELECT权限，则该用户仍可以查询“学生”表数据。X72SQL Server采用了标准SQL

19、Serve登录和集成WindowsNT登录两种方式。V73SQL Server管理员不能修改固定数据库角色所具有的权限。(除了公共角色外)X74DTS服务不能实现对规则、账户对象的传输。X75使用DTS服务，可以将SQL Server中表的数据转换成Flat File文件。V76分布式查询可以访问来自本机或其他机器上的异类数据源的数据。V77ASP程序既可以在服务器端运行,又可以在客户端运行。X78ASP程序在执行后，其结果在客户端将转化成标准的HTML文件。X79要访问数据库，必须通过ADO中的connection对象建立一个到数据源的连接。V80使用安全模式通过ADO连接到数据库时，不需要

20、输入用户名和密码。X过去的一年，对我来说，是一个既紧张又忙碌的一年，是一个不断接受新事物，迎接新挑战的一年，在局党组的领导下，在同志们的帮助下，无论是思想、工作还是作风上都有所进步Obviously, face Chinas Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn rig

21、ht or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First

22、, the Central eight articles as a starting point, starting from the Central Governments self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the societ

23、y a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dongs thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty t

24、alks jeopardize national interests and try again, is an affirmation of Deng Xiao-pings reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the talking to Mao Ze-Dongs historical cycle of high profile ant

25、i-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the law, while improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform a

26、nd opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the patient and low profile shadow began to gradually plan development. Signs show that the n

27、ew leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leaderships thinking is messy. New leaders both stressed the need to implement the Constitution, stressed the need to turn off the power in a cage. Also stresses th

28、at Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release seven does not speak of files of political constraints. Neither deny the history of the CPC Central Committee on several issues .Comrades: today br

29、ings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis