16. 给定关系模式SP_P(供应商号,项目号,零件号,数量),按查询条件“查询至少供应了6个项目(包含6项)的供应商,输出其供应商号和供应零件数量的总和,并按供应商号降序排列”,将正确选项填入SQL语句的空项中。 SELECT 供应商号, SUM(数量)FROM______ GROUP BY供应商号 HAVING COUNT(DISTINCT(项目号))>5 ______;
59. COBIT (Control Objectives for Information and related Technology)是目前国际上通用的信息系统审计的标准,由信息系统审计与控制协会在1996年公布。是一个在国际上公认的、权威的安全与信息技术管理和控制的标准。该标准对IT资源进行了相关定义,下面______不属于标准中定义的IT资源。
The purpose of a programming system is to make a computer easy to use. To do this, it furnishes languages and various facilities that are in fact programs invoked and controlled bylanguage features. But these facilities are bought at a price: the external description of aprogramming system is ten to twenty times as large as the external description of the computersystem itself. The user finds it far easier to specify any particular function, but there are farmore to choose from, and far more options and formats to remember. Ease of use is enhanced only if the time gained in functional specification exceeds the time lost in learning, remembering, and searching manuals. With modem programmingsystems this gain does exceed the cost, but in recent years the ratio of gain to cost seems tohave fallen as more and more complex ______ have been added. Because ease of use is the purpose, this ratio of function to conceptual complexity is the ultimate test of system design. Neither function alone nor simplicity alone ______ a gooddesign. This point is widely misunderstood. Function, and not simplicity, has always been the measure of excellence for its designers. As soon as ease of use is held up as the criterion, eachof these is seen to be ______, reaching for only half of the true goal. For a given level of function, however, that system is best in which one can specify things with the most simplicity and straightforwardness. ______ is not enough. Mooers's TRAClanguage and Algol 68 achieve simplicity as measured by the number of distinct elementaryconcepts. They are not, however, straightforward. The expression of the things one wants to dooften requires involuted(复杂的) and unexpected combinations of the basic facilities. It is notenough to learn the elements and rules of combination; one must also learn the idiomatic usage,a whole lore of how the elements are combined in practice. Simplicity and straightforwardnessproceed from conceptual ______ Every part must reflect the same philosophies and thesame balancing of desiderata. Every part must even use the same techniques in syntax andanalogous notions in semantics. Ease of use, then, dictates unity of design, conceptualintegrity.