某公司的部门(部门号,部门名,负责人,电话)、商品(商品号,商品名称,单价,库存量)

题型:单项选择题

问题:

某公司的部门(部门号,部门名,负责人,电话)、商品(商品号,商品名称,单价,库存量)和职工(职工号,姓名,住址)3个实体之间的关系如表1、表2和表3所示。假设每个部门有一位负责人和一部电话,但有若干名员工;每种商品只能由一个部门负责销售。

a.若部门名是唯一的,请将下述部门SQL语句的空缺部分补充完整。

CREATE TABLE部门(部门号CHAR(3) PRIMARY KEY,

部门名CHAR(10) (16)

负责人CHAR(4),

电话CHAR(20))

(17) );

b.查询各部门负责人的姓名及住址的SQL语句如下:

SELECT 部门名,姓名,住址 FROM部门,职工 (18)

(17)处填()。

A.PRIMARY KEY(部门号)NOT NULL UNIQUE

B.PRIMARY KEY(部门名)UNIQUE

C.FOREIGN KEY(负责人)REFERENCES职工(姓名)

D.FOREIGN KEY(负责人)REFERENCES职工(职工号)

考点:计算机软件水平考试中级信息系统管理工程师中级信息系统管理工程师2008上半年上午试题
题型:单项选择题

“不能光想,你动手做做看!”这句话中“光”的意思是[ ]

A.全没有了    

B.只    

C.明亮

题型:单项选择题

农产品市场价格与价值经常偏离的主要原因是()的影响。

A.市场秩序

B.供求关系

C.宏观政策

D.货币价值

题型:单项选择题

阅读理解.

     On April twenty-second, some American children stayed out of school but they were

not punished. They were with their parents. As Faith Lapidus tells us, it was Take Our

Daughters and Sons to Work Day.

     The Ms. Foundation for Women started the program seventeen years ago, in 1993.

At first it was just called Take Our Daughters to Work. Gloria Steinem and other

foundation leaders pointed to studies showing that self-image suffers as girls become

teenagers. They can lose trust in their abilities and intelligence, especially in areas like

science, math and technology. So the Ms. Foundation planned a day for parents in

New York City to show girls all the possibilities for them in the professional world.

But there was so much interest, the organizers decided to make it national.

     At first, girls mostly followed their mom or dad around at work to learn about their

jobs. Later, employers and schools began to offer organized activities. But from the

beginning there were protests (反对) from parents and others about the exception of

boys. So in 2003 the day was renamed Take Our Daughters and Sons to Work.

     2007 was the last year that the Ms. Foundation for Women headed the program.

Now, the event is run by a twelve-person group called the Take Our Daughters and

Sons to Work Foundation.

     Carolyn McKecuen is president of the foundation. She says a total of about

thirty-three million children and adults are involved in the program. About one-third

of the adults work at large companies or nonprofit organizations. Another third are

in small businesses. The rest work in education.

     Carolyn McKeeuen says the numbers from this year's event are not final yet. But

early reports suggest that participation was up at least ten percent from last year. And

she says the foundation is hoping to find support to expand the program internationally.

She says there are lots of requests from other countries for information about how to

set up similar programs.

1. It was called Take Our Daughters to Work at first because _____.

A. girls are considered to be clever than boys

B. gifts are considered to be more foolish than boys

C. girls aren't confident in some areas as they becomes older

D. girls don't want to learn some science subjects

2. Why was the day renamed as Take Our Daughters and Sons to Work Day later?

A. Because some parents were against only girls' having the chance.

B. Because some parents wouldn't like to take their daughters to work.

C. Because some employers were against parents' taking their children to work.

D. Because some schools didn't want to give any students' time to leave school.

3. How many years did the Ms. Foundation for Women head the program?

A. 17.

B. 18.

C. 14.

D. 10.

4. From this passage we can learn _____.

A. April twenty-second is a day for some American children to stay out of school for punishment

B. the Take Our Daughters and Sons to Work Day is a national in America

C. Mattel is the president of the foundation whose company makes Barbie dolls

D. lots of other countries want to set up similar programs for parents and children

题型:单项选择题

关于羊水过多,正确的是

A.急性羊水过多较慢性羊水过多发生率高
B.单胎妊娠较多胎妊娠发病率高
C.约有25%合并胎儿畸形
D.超过1000ml为羊水过多
E.超过2000ml出现临床症状

题型:单项选择题

下列哪项是决定肺部气体交换方向的主要因素()

A.气体分子量大小

B.气体的溶解度

C.肺泡膜的通透性

D.气体和血红蛋白的亲和力

E.气体的分压差

更多题库