已知关系模式Student （S# char（8) Primary key, Sname char（10), Ssex char（2),Sage integer, D# char（2), Sclass char（6))，在此基础上定义了视图create view CStud（S#, Sname, Sclass) as （select S#, Sname, Sclass from Student

● 设有职工关系Emp（Eno，Ename，Esex，EDno）和部门关系Dept（Dno，Dname，

Daddr），创建这两个关系的SQL语句如下：

CREATE TABLE Emp(

Eno CHAR(4),

Ename CHAR(8),

Esex CHAR(1) CHECK(Esex IN ('M', 'F')),

EDno CHAR(4) REFERENCES Dept(Dno),

PRIMARY KEY (Eno)

);

CREATE TABLE Dept(

Dno CHAR(4) NOT NULL UNIQUE,

Dname CHAR(20),

Daddr CHAR(30)

);

直接运行该语句，DBMS会报错，原因是： （53） 。若经过修改，上述两个表创建完毕之后（尚无数据），则下述语句中能被执行的是 （54） 。

（53）

A. 创建表Dept时没有指定主码

B. 创建表Dept时没有指定外码

C. 创建表Emp时，被参照表Dept尚未创建

D. 表Emp的外码EDno与被参照表Dept的主码Dno不同名

（54）

A. INSERT INTO Emp VALUES('e001', '王', 'M ', 'd1');

B. INSERT INTO Emp VALUES(NULL, '王', 'M', 'd1');

C. INSERT INTO Emp VALUES('e001', '王', 'M', NULL);

D. INSERT INTO Emp VALUES('e001', '王', 'X', 'd1');

● 设有职工关系Emp（Eno，Ename，Esex，EDno）和部门关系Dept（Dno，Dname，

Daddr），创建这两个关系的SQL语句如下：

CREATE TABLE Emp(

Eno CHAR(4),

Ename CHAR(8),

Esex CHAR(1) CHECK(Esex IN ('M', 'F')),

EDno CHAR(4) REFERENCES Dept(Dno),

PRIMARY KEY (Eno)

);

CREATE TABLE Dept(

Dno CHAR(4) NOT NULL UNIQUE,

Dname CHAR(20),

Daddr CHAR(30)

);

直接运行该语句，DBMS会报错，原因是： （53） 。若经过修改，上述两个表创建完毕之后（尚无数据），则下述语句中能被执行的是 （54） 。

（53）

A. 创建表Dept时没有指定主码

B. 创建表Dept时没有指定外码

C. 创建表Emp时，被参照表Dept尚未创建

D. 表Emp的外码EDno与被参照表Dept的主码Dno不同名

（54）

A. INSERT INTO Emp VALUES('e001', '王', 'M ', 'd1');

B. INSERT INTO Emp VALUES(NULL, '王', 'M', 'd1');

C. INSERT INTO Emp VALUES('e001', '王', 'M', NULL);

D. INSERT INTO Emp VALUES('e001', '王', 'X', 'd1');

● 设有职工关系Emp（Eno，Ename，Esex，EDno）和部门关系Dept（Dno，Dname， Daddr），创建这两个关系的SQL语句如下：

CREATE TABLE Emp(

Eno CHAR(4),

Ename CHAR(8),

Esex CHAR(1) CHECK(Esex IN ('M', 'F')),

EDno CHAR(4) REFERENCES Dept(Dno),

PRIMARY KEY (Eno)

);

CREATE TABLE Dept(

Dno CHAR(4) NOT NULL UNIQUE,

Dname CHAR(20),

Daddr CHAR(30)

);

直接运行该语句，DBMS会报错，原因是： （53） 。若经过修改，上述两个表创建完毕之后（尚无数据），则下述语句中能被执行的是 （54） 。

（53）

A. 创建表Dept时没有指定主码

B. 创建表Dept时没有指定外码

C. 创建表Emp时，被参照表Dept尚未创建

D. 表Emp的外码EDno与被参照表Dept的主码Dno不同名

（54）

A. INSERT INTO Emp VALUES('e001', '王', 'M ', 'd1');

B. INSERT INTO Emp VALUES(NULL, '王', 'M', 'd1');

C. INSERT INTO Emp VALUES('e001', '王', 'M', NULL);

D. INSERT INTO Emp VALUES('e001', '王', 'X', 'd1');

● 设有职工关系Emp（Eno，Ename，Esex，EDno）和部门关系Dept（Dno，Dname， Daddr），创建这两个关系的SQL语句如下：

CREATE TABLE Emp(

Eno CHAR(4),

Ename CHAR(8),

Esex CHAR(1) CHECK(Esex IN ('M', 'F')),

EDno CHAR(4) REFERENCES Dept(Dno),

PRIMARY KEY (Eno)

);

CREATE TABLE Dept(

Dno CHAR(4) NOT NULL UNIQUE,

Dname CHAR(20),

Daddr CHAR(30)

);

直接运行该语句，DBMS会报错，原因是： （53） 。若经过修改，上述两个表创建完毕之后（尚无数据），则下述语句中能被执行的是 （54） 。

（53）

A. 创建表Dept时没有指定主码

B. 创建表Dept时没有指定外码

C. 创建表Emp时，被参照表Dept尚未创建

D. 表Emp的外码EDno与被参照表Dept的主码Dno不同名

（54）

A. INSERT INTO Emp VALUES('e001', '王', 'M ', 'd1');

B. INSERT INTO Emp VALUES(NULL, '王', 'M', 'd1');

C. INSERT INTO Emp VALUES('e001', '王', 'M', NULL);

D. INSERT INTO Emp VALUES('e001', '王', 'X', 'd1');

已知x=[1,11,111]，那么执行语句x.sort(key=lambdax:len(str(x)),reverse=True)之后，x的值为__________________。

Theres a school of linguistics that believes language learning begins with a "silent period". Just as babies learn to produce language in hearing and parroting【M1】______ sounds, language learners need to practise listening in order to learn. This can reinforce learning vocabulary and structures, and help learners see patterns in【M2】______ language. As a language learner grows up, attitude can be the key factor in how he or【M3】______ she progresses. A learner who is keen about the target culture will be more successful in their language studies. The culturally curious students will be more receptive to the language and more open to form. relationships with native【M4】______ speakers. Linguists have found that students with a low tolerance of ambiguity tend to struggle with language learning. Language learning involves a lot of uncertainty—students will encounter new vocabulary daily, but for each【M5】______ grammar rule there will be a dialectic exception or irregular verb. Until native like fluency achieved, there will always be some level of ambiguity.【M6】______ The type of learner who sees a new word and reaches to the dictionary【M7】______ instead of guessing the meaning from the context may feel stressed and disoriented in an immersion class. Ultimately, they might quit their language studies out of sheer frustration. Its a difficult mindset to break, so small【M8】______ exercises can help. Some learners are most comfortable with the listen-and-repeat drills of a language lab or podcast. Some need a grammar textbook to make a sense of a【M9】______ foreign tongue. Every of these approaches is fine, but its a mistake to rely on【M10】______ only one.

【M1】

表达式sorted([111,2,33],key=lambdax:len(str(x)))的值为________________。

One problem with much personality research is that it examines and rates whatever traits the researchers are interested in at the time: conscientiousness, emotional stability and so on. But when we 【B1】______ someone in real life, we dont consider an array of personality measures; instead, we focus on a few【B2】______traits that sum up the【B3】______of the person. One is particularly anxious, another is【B4】______reliable, yet another is a "live wire". While we might hesitate to characterize individuals along every personality dimension, we can accurately identify them 【B5】______ their key characteristics. In research at Stanford University, Daryl Ben and Andrea Allen tested this idea by first asking college students 【B6】______ they were consistently or only occasionally friendly and then 【B7】______ their parents and friends how friendly the students were. Ben and Allen observed how the students acted under two specific conditions:【B8】______they spoke in small groups and how quickly they【B9】______a conversation with strangers. The researchers found that students who considered themselves consistently friendly were indeed more likely to be【B10】______in both circumstances than were those who【B11】______themselves only intermittently friendly.【B12】______that, the friendliness ratings by parents and peers of the students who were consistently friendly were very similar【B13】______the students self-ratings and【B14】______accurately how they would act in two conditions. It seems that we can【B15】______ourselves accurately and that others can rate us very well on traits【B16】______serve as our trademarks. To predict how someone will behave in a given situation, we must【B17】______the requirements of the situation with the trademark characteristics of the person【B18】______. People who are strongly of one type or【B19】______should react predictably in a given situation,【B20】______the behavior. of other, more diffuse personalities is harder to anticipate.

【B1】

A．illustrate

B．portray

C．paint

D．describe

The Australia-China relationship is now, as some of you have heard, thirty years old，and thirty years ago it is probably fair to say there were no official Chinese residents with appropriate visas studying in Australia. Today, that number exceeds 25,000 and is projected to exceed 100, 000 in ten years time. Education is the eighth largest export earner for Australia and to give you some idea of what that means, there are 38 universities in Australia. //My university, the University of New South Wales, has been active in the region, but last year overseas students brought in 128 million dollars to one university. Our local fee paying students brought in 34 million dollars. Those of you who don't know Australia might think that's strange, but of course the vast majority of our local students study in a government subsidized manner but also making some contribution themselves later on in life when they start to earn money. //

I wouldn't like you to think for one moment that I think education is about earning money, and I merely talked about the money education brings to Australia to reinforce what a big program it is and how important it is for Australia. and for Australian finances and there seems little doubt that governments really are obsessed by export dollars. I'm not saying that's wrong I'm just making a comment, but governments are obsessed by export dollars and therefore education is important. //

When I went to school, and I went to a government funded public school, there were about 750 boys at that school, and there were two Chinese students one of whom was me. Last year I spoke at a speech day. It is now a co-educational school, but 70 percent of the students were of Asian heritage, and of that 70 percent, about three quarters of them were Chinese. It's a selective school and therefore reflects, I think, the Chinese and the Vietnamese families' determination that education is important if they want their children to succeed. //I think that's great, but if any of you have visited the campus of my university you would notice one thing and that is it looks very Asian. At the present time, the University of NSW has about 34,000 students, 27 percent of whom are overseas students and the majority of those are ethnic Chinese but if you look at the campus you would think about 55 to 60 percent look Asian because the other quarter are like me, Asians who are Australians. And that's an interesting reflection of what's happened to Australia. //

(Excerpts from the speech delivered by Dr. John Yu, Chairman of the Australia-China Council, on the Australia-China Oration Series 2002, November 6, Beijing)

AcustomerwantstodeployanewCRMapplicationonan8-wayIntel-basedserver.Theyplantoupgradetoa16-wayserversixmonthslater，becausetheCRMapplicationwillsupportalargernumberofprocessors.Aftertheupgrade，theywillneedmoreI/OslotstosupporttheSANstorageandLANbandwidthrequirements.TheyareconsideringeithertheIBMx445ortheHPQDL740/DL760G2.WhichTWOofthefollowingchoicesarethekeycompetitiveadvantagesoftheIBMx445？（）

A.x445supportsPCI-Xadapters

B.x445canscaleupto16processors

C.x445supportsredundantpowersupplies

D.x445canexpandI/ObyaddingtheRXE-100

E.x445comesstandardwithsystemsmanagementsoftware