nba新赛季 :2017ܛyԇ̎Pԇ}Ŀ

rg2017-05-12 Pԇ}Ŀ ҪͶ

nbaֱ www.oivyya.tw һ.

1 ϵyyԇʹ( C )g, Ҫyԇyõĸ߼, o迼]yԇõăȲY

A Ԫyԇ B ɜyԇ C ںМyԇ D׺Мyԇ

2ԪyԇҪĜyԇg(B )

A ׺Мyԇ B ܜyԇ

C oByԇ D ϶

3(A )ĿnjKܛϵyMȫĜyԇ_KܛϵyMaƷѭϵyOӋ

A ϵyyԇ B ɜyԇ

C Ԫyԇ D ܜyԇ

4һaƷд·صȱݻͨ^͜y@AεijƷ( A )

A Alpha BBeta

C D϶

5ԵϷҪ(A )

A ӳ B Cӳ͘ D .϶

6yԇATMȡ֪ȡֻݔÿȡҪ100ıҲܴ500Ă_ğoЧȃr(C)

A(0100)(100200)(200300)(300400)(400500)(500+∞);

B(500+∞)

C(500+∞)0С500ķ100;

D(-∞100)(100200)(200300)(300400)(400500)(500+∞);

7D/ж̷ǷNr²m(C)

Aݔݔ_ݔݔPϵ_r

BԻcsݔĿܶr

Cϵyݔ֮g໥sҪ󷶇ĽMϜyԇr

Dϵyݔ֮g]໥“ϵ

8f_(D)

AyԇԭʼҪ_ˮaƷҪFʲô

BaƷyԇҎ_˜yԇOӋ

Cyԇ_˜yԇF

Df_

9ɜyԇPϵy^Եfǂe`( B)

AϵyеݔY^e`ݔRe;

Bϵy\РB̓Ȳ̎^Ϣ^;

CϵyȲ׃ȡֵ^;

DϵyȲҪĠB͌Կ^;

EϵyȲҪIJ̎rg^;

FϵyȲҪYԴռr΂YԴĄጷ^̿^

10yԇ_ľҎ{(ABCD )

Ax B CɾSo Dֲ

11^ijͨ?ЩǶȶԸiQԽ{}Է?(AC )

AʧЧӰ푶 B C^зʽ DÑԭʼ

12PܛyԇĔx_Ĕ(CD)

AúںзyԇryԇǸȲ߉݋OӋ

ByԇĿCԓܛ_ČFÑҪ

ClFe`ijK?еĴҲ?/p>

DyԇOӋrֿ]ݔr

13ܛ՜yԇĺϸͨ^ʄtǣ(ABCD)

A. ܛfжxйȫFָȫ_Ҫ

B. Мyԇ헛]Кһe`

C. 헌ęnOӋęn;aFһ

D. ՜yԇRȫ

13ܛyԇӋuҪЩˆT?(ABCD)

A.Ŀ

B.SQA ؓ؟

C.ؓ؟

D.yԇM

14.yԇOӋTš؟У(BC )

A.ƶyԇӋ

B.OӋyԇ

C.OӋyԇ^_

D.uyԇ

15.ܛʩӵMʄtǣ(ABC)

A.󹤼ѽ

B.ԔOӋѽ

C.ܹѽ

D.ĿAγɹѽ

 Д}(_√e`Ĩw)10ÿС}1

1. ܛyԇĿDZMܶҳܛȱ( Y)

2. ؓdyԇCҪzϵy_ʲô̶(N )

3. yԇˆTҪԳԭtȱδޏԛQͨ^(N)

4. ԄӻyԇֹܱyԇlFȱ(N)

5. e`œy@һNOǰ^e`Ժͬӕҷ^e`eͬӕǰ˷^e`ͬӕ(N)

6. ܛyԇеĶԭtʾyԇlFe`е80%ܿԴڳ??0%(Y)

7. ijWEBϵyOӋÑc“˳”oϵy˳صʼꑽ˕rP]ʹÞg[Ļ˹Իص֮ǰÑ^mMÑ@NmԻOӋǂÑ`c˳oµ䛵ķ;@NfǷ_(N)

8. ڴ_ܜyԇֵָrćH˜\IҎЌҪ󲢲һҕrx҂ֵָҪȸָ@ӲЈ(N)

9. yԇЕrԓÿһyԇYȫęz־@NfǷ_( N)

10. ڜyԇЕr҂ҪǻÑʹÈ]܌F_PICҪڔǷܴ惦־ݔǷüڴa̎҂yԇPעķǮaƷăȲFÑȻҲDzPĵ@NfǷ_( )

첿֣(15)

ijWԇɿϢքe±StudentͱAchievementʾ

ID Name

1 Jack

2 Marry

3 Rose

4 Bob

5 John

6 Betty

7 Robert

ID Mark

1 90

2 96

3 88

4 86

5 83

6 85

Student  Achievement

IDWľ̖NameMarkɿՈᘌ†}SQLZ䣺

1 Ոԃɿ>85ֵČW;

Select Name from Student where id in(select id from achievement where mark>85);

Select * from student where id in (select id from achievement where mark>85);

2 Ոԃɿ>=90ֵ˔;

Select count(*) from ac where mark=90;

Slect count(*) from achievement where mark>=90

3 Robert˴οԇ80dzɿ]ՈɿMȥ;

Insert into ac(idmark)values (‘7’‘80’);

Insert into achievement(id,name) values (‘1’,’80’);

4 ՈRoseijɿ޸Ğ87;

Update ac set mart=‘87’where id=4;

Update achievement set mark=87 where id=3;

5 ՈhBettyӛ;

Delete * from student where id=6;

Delete * from achievement where id=6;

OӋ}} 1 С}M 20

1. õȃrַOӋyԇ

һϵyҪÑݔҪ̎Oڵķ20001µ202012Ñݔڲ@t@ʾe`aϢҴϵyҎµ6λֽMǰ4λ2λ

(1) Ոгȃr(Ч͟oЧȃr)(10)

̖ ݔ ݔ

1 201001(Чȃr) _

2 012010(oЧȃr) @ʾe`aϢ

3 198811(oЧȃr) @ʾe`aϢ

4 202111(oЧȃr) @ʾe`aϢ

5 20102(oЧȃr) @ʾe`aϢ

7 abc

8 ո

9

(2) (1)еĵȃrOӋܸwеȃrĜyԇҪݔ딵Aݔָyԇwĵȃrľ̖(10)

P