问题 问答题

设工程一零件数据库中有4个基本表:
供应商(供应商代码,姓名,所在城市,联系电话);
工程(工程代码,工程名,负责人,预算);
零件(零件代码,零件名,规格,产地,颜色);
供应零件(供应商代码,工程代码,零件代码,数量)。
试用SQL语句完成下列操作:

找出使用供应商S1所供零件的工程号码。

答案

参考答案:

解析:SELECT 工程代码 FROM 供应零件 WHERE 供应商.供应商代码=“S1” AND 供应商.供应商代码=供应商零件.供应商代码

探究题
单项选择题

Starting with his review of Skinner’s Verbal Behavior, Noam Chomsky had led the psycholinguists who argue that man has developed an innate (天生的) capacity for dealing with the linguistic universals common to all languages. Experience and learning then provide only information about the (1) instances of those universal aspects of language which are needed to communicate with other people within a particular language (2) .

This linguistic approach (3) the view that language is built upon learned associations between words. What is learned is not strings of words per se (本身), but (4) rules that enable a speaker to (5) an infinite variety of novel sentences. (6) single words are learned as concepts: they do not stand in a one-to-one (7) with the particular thing signified, but (8) all members of a general class.

This view of the innate aspect of language learning is at first not readily (9) into existing psychological frameworks and (10) a challenge that has stimulated much thought and new research directions. Chomsky argues that a precondition for language development is the existence of certain principles "intrinsic (原有的) to the mind" that provide invariant structures (11) perceiving, learning and thinking. Language (12) all of these processes; thus its study (13) our theories of knowledge in general.

Basic to this model of language is the notion that a child’s learning of language is a kind of theory (14) . It’s thought to be accomplished (15) explicit instruction, (16) of intelligence level, at an early age when he is not capable of other complex (17) or motor achievements, and with relatively little reliable data to go on. (18) , the child constructs a theory of an ideal language which has broad (19) power. Chomsky argues that all children could not develop the same basic theory (20) it not for the innate existence of properties of mental organization which limit the possible properties of languages.

1()

A.special

B.specific

C.definite

D.explicit