2023年中南大学数据库题库数据表.pdf

文档介绍：该【2023年中南大学数据库题库数据表 】是由【cjc201601】上传分享，文档一共【46】页，该文档可以免费在线阅读，需要了解更多关于【2023年中南大学数据库题库数据表 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。:.


 


“”
“
”“”!"#
$
%&'()$%*+,-.
/“”01234o
A
ALTERTABLE

ADDCHECKA
+
B
UPDATE
SETA
+

C
INSERTINTO
VALUES
+
D
CREATETRIGGERtgz
ON
:.
FORINSERT
AS
UPDATE
SETAa.

+a.
FROM
aJOININSERTEDbONa.

Ab.
ANDa.
Ab.

TUVW
D
#SQLServer\]\] 
^,
`,ab“cd”ef400`i0jk
l4o
A
UPDATE\]SET=+400
WHERE
^A‘cd’
B
UPDATE\]WITH=+400:.
WHERE
^A‘cd’
C
UPDATEFROM\]SET=+400
WHERE
^A‘cd’
D
UPDATE\]SET+400
WHERE
^A‘cd’
TUVW
A
#bstudent_dbqSt_Infor%&
stuavwvxy%“z”{|}“~”
0€i‚ƒ€„…†‡ˆ‰`
AŠ‹‡DEFAULTŒŽ1
BŠ‹‡CHECKŒ
CŠ‹‡UNIQUEŒŽ‘1
DŠ‹‡PRIMARYKEYŒŽ’“:.
TUVW
A
i0”‡•–b—˜sampleqtb_name
()o
Adeletefromtb_name



TUVW
C
SQLj™š›œžŸ "¡
¢£*¤jkINSERT>DELETE>UPDATE
+,()£*`
A›œ
BŸ 
C§
D¡¢
TUVW:.
c
CREATETABLEjk()`
A¨©# ^ªŸ«¬q
B¨©ª­«®
CªŸ«®" ^¯°±#q¨©
‘
D²³ ^&´-.Š‹‡
xµ&
TUVW
C
¶—˜Ž·¸rjk4
()O
AUPDATE
BDELETE
CDROP
DINSERT
TUVW
B:.
#¹º~»¼½¾Ÿ b¿Ÿ‘
+¤4`
A+¤¹º~
BÀ¹º~
CÁ¹º~
DÂß ¹º~
TUVW
A
iÄÅÅÆÇÈl4`
Aƒ#ɇʼ½ËÌ͊‹ÅÆ
Bƒ#ɇʼ½ ËÌ͊‹Å
Æ
Cƒ#ɇμ½Ê ^ËÌÍ
Š‹ÅÆ
D#Š‹ÅÆ&ÏÐÑÒƗ˜ÎŸr´Ó
“ÔÕ¸r—˜&ƒ-.—˜’“Å
Ƹr`
TUVW
C:.
'ÅÖq‡S×ØbSSN,CN,grade,
SNb|} CNbÚÛ É®ÜbËݽÞ
gradebßà1½`áaâ“ãäå|ßà80
ç”$%Sljk4`
AADDINTOSVALUESãäå|è80,
BINSERTINTOSVALUESãäå|
48/
CADDINTOSVALUESãäå|80
DINSERTINTOSVALUESãäå|80
TUVW
D
#SQLServeri0ê¸Ýƒ€žb
xµ&
4`
A##MyTable
B@***@MyTable
C©MyTable
DðyTable
TUVW
D:.
ƒ€'ñËÌCheckŒ†õŒ¬
()O
A+¤¹º~ö÷
BTø¹º~ö÷
Cù~ö÷
DÀ¹º~ö÷
TUVW
D
áÂúiSQLjkŠ‹Ñ‡SCû
CREATETABLESC
(SCHAR(6)NOTNULL,
CCHAR(3)NOTNULL,
SCOREINT,
NOTECHAR(20))
ÿSC
()

A'202309''111'60,:.
B(‘202323’,'101',NULL,NULL)
C(NULL,03',80,!)
D(‘202332’,NULL,86,'')
"#$%
B
&'()*S+,-./CN(012)3
()O
AADDTABLES(CNCHAR(8))
BADDTABLESALTER(CNCHAR(8))
CALTERTABLESADDCNCHAR(8)
DALTERTABLES(ADDCNCHAR(8))
"#$%
C
4()Transact-SQL56
AALTERTABLE
BCREATETABLE
CCREATEDATEBASE
DALTERVIEW
"#$%
B:.
(:Students_db;<S_C_Info=>?

***@ABCDEFG0HI>?HI100,
JKLMN9OP
STUV


SXY
"#$%
B
Z[\<“^_`”bcd3eZfghijk
l`Vmnopj78ghi<
QR
AXY
BqY
CNULL
DCHECK
"#$%
D:.
(rsZ[\+tuvwxydz{|}<j
()0
A~€yd
B‚dyd
CSQLyd
D†‡yd
"#$%
D
()ˆ‰<Š‹ŒjŽ‘+X
Yn <
An’
B“
C”3
D3•
"#$%
A
–—3Transact-SQL5678XY
j
()O:.
A
createtabletablel
(clchar(13)notnullprimary,
c2intnot)
onprimary
B
altertabletablel
addconstraint[PKtablel]primary
keynonclustered(cl)onprimary
C
altertabletablelclprimarykey
D
wx!°±
"#$%
B:.
²³>?grade+´hiscore(float),µ('¶·
´(55¸60¹º»<¹¼½5¹SQL56
¾<<j()o
AUpdategradesetscore=score+5wherescorein55..60
BUpdategradesetscore=score+5wherescore>=55
ANDscore<=60
CUpdategradesetscoreIscore+5wherescorebetween
55or60
DUpdategradesetscoreIscore+5wherescore<=55and
score>=60
"#$%
B
()Š‹Œj¿.9~+·´XÀŒtuÁ`
V
An’
B“
C”3
D3•
"#$%
A:.
/~e<Âþ<<jo
AÄ'3•Å´ÆA3ÇÈwÉÊ
B3•ËÌ
CÍËÌ
DÍÉÊ
"#$%
C
~;+XYj
A:ÎÏ+W.<n’
B78W.<Д^_`V
CÄ^_+Ñ.hi8f
D^_´Ò9XY<
"#$%
A
(:studentsdb;<student_info=

ÓÔÕ'.Ö×.ÖØl“Ù”Ú²³“ŒÛÜ/
JKLMN9OP
STUV

:.
(SXY)
"#$%
A
INSERTINTOGoods(Name,Storage,
Price)VALUES(,Keyboard,,3000,)<Ý3j
()o
AÞßÚ. +<·´/
BÆTUV
CÞßÚ. +<à¹/
DÒ9
"#$%
C
(SQL+8f3<áâj()o
ACREATESCHEMA
BCREATETABLE
CCREATEVIEW
DCREATEINDEX
"#$%
B:.
SQL5ã+ÉÊ+<áâj
o
ADELETE
BDROP
CCLEAR
DREMOVE
"#$%
A
SQL5ã+ÉÊ.9<áâjo
ADELETE
BDROP
CCLEAR
DREMOVE
"#$%
B
SQLServer2023+äå<áâj
AUSE
BSELECT
CUPDATE
DDROP:.
"#$%
C
(SQL+8fæÇ3<áâjo
ACREATETABLE
BCREATERULE
CCREATEVIEW
DCREATEINDEX
"#$%
B
çèéêëéêìÀí9~–éêîï
ð–
ñéê~+ÉÊgéê<cò|
(éêìÀ~
+ÉÊóð<ìÀcò(SQL5ã+N9Š
‹ŒQR<ô5j
AINSTEADOFDELETE
BINSTEADOFDROP
CAFTERDELETE
DAFTERUPDATE
"#$%
C:.
qYnµ<jõ.öˆŠ‹
Œ÷
An’Š‹Œ
B"øŠ‹Œ
C3•<Š‹Œ
Dn’Š‹Œù"øŠ‹Œë3•<Š‹Œ
"#$%
B
´.9~G²³²úû2ü揲ú<
V“j89hò><hýþN.æÇÀe
o
An’Š‹ŒQR
B"øŠ‹ŒQR
C3•ÿ

D


C
)O
F
:.
A!"#$"
B%&'(%&#)&*+
C,%&'(-%&*+
D'(./0123
45678#9
:


B
;<=>?***@ABC
A<=,%&'(*+DEFGH
B<='I'DEFGHJI*+K
C<=,'(*+DEFGH
D<=,./LDEFGH


C
',./L(%&MNOP./QJRS
BTU./VWC
AXY
BZ[:.
C\]
D^_


C
`Pabbooklist'(?bookname"4"bookl”c
“book2”d./J>efabgh()C
Adeletebooklistwherebooknamein('bookl'book2')
Bdeletebooklistwhere(bookname="booklx)or
(booknamekxbook2')
Cdeletebooklistwherebookname="bookl'or
bookname=xbook2'
Ddeletebooklistwherebookname='bookl'and
bookname=xbook2'


D
>
()o
A!"#$"
B%&'(%&#)&*+
C,%&'(-%&*+
D'(./0123
45678#9:

:.
B
SQLserver(()eflmtemp'(hostname*
+no4varchar(100)o
Aaltertabletempaltercolumnhostnamevarchar(HOO)
Baltertabletempcolumnhostnamevarchar(lOO)
Caltertabletempaltercolumnofhostnamevarchar(lOO)
Daltertabletempaddcolumnhostnamevarchar(lOO)


A
%pqr>J>()*+s4*C
At:uv
Bwx
Cyz
D{|}8~


D
%&€'J'(‚*+ƒUserid(inC„
UserName(varchar)>PassWord(varchar)…J†'‡
PˆGJ>‰Š‹Œ()C
AŽ'ˆJ‘/’“‹”•–J‹:.
—˜UseridcPassWords4™šC
BŽ'ˆJ‘/’“‹”•–J‹
—˜Userids4C
CŽ'ˆJ‘/’“‹”•–J‹
—˜UserNamecPassWords4™šC
D›˜Userids4Jœ,Userid?žŸ
."J ¡4$C


B
,%&'(J¢N£S¤}¥&¦™§¨
%JS¨%'©¥ª«4B0
A
B
C_
D<


A
ˆ¬­’®¯°'J¬­S¬8JyzJ±J
²³J{|}8BJ®´C®8J®zBJ’®SC¬
8J®8JgµBJ–'SC*4
A®8Jgµ:.
B¬8Jgµ
C¬8J®8
D¬8JyzJgµ


C
,¬­'(PZ¶d²³·;30¸y¹º¬,
¼˜<½¾
A’“
B¿À
CHÁ
D5ÂHÁ


A
`Pm“s_c_info”'(d¬­gµ“score”Ã5Ä,
–SQLef
AUPDATEs_c_infoSETscore=5
BUPDATEs_c_infoSETscore=score+5
CUPDATEFROMs_c_infoSETscore=5
DUPDATEFROMs_c_infoSETscore=score+5


B:.
>?;*
A%&'Å*
B-lm%&*+
4*
C›%&'-%ÆJ–**+Ç4
$"
D§


A
 ¡./L',È?ÉÊ"JË ¡
$"JÌ«;***@UBC
ADEFAULT
BCHECK
CPRIMARYKEY
DFOREIGNKEY


C
 ¡./L',È?ÉÊ"JË ¡
$"JÌ«;***@Uo
ADEFAULT
BCHECK
CPRIMARYKEY:.
DFOREIGNKEY


C
ÍÎÏÐÑÒo
Aaction
Bgo
Cfor
Dup


B
\Ó,./L(./ÔÕ«;o
A./
B./Ö
C./×Ø
Dɧ


A
,T-SQLeÙ(JÚÛ'ÐܐJ¼£ÝÞ
AUPDATE
BINSERT
CMODIFY:.
DALTER


D
`›>SQLefâFã%&'Sƒ
CREATETABLES
(S#CHAR(6)NOTNULL,
SNAMECHAR(8)NOTNULL,
SEXCHAR(2),
AGEINTEGER)
ö÷S'øŸ›>ªJ@%ªùøŸ
()O
A('991001','þÿ‘’23')
B('990746','',NULL,NULL)
C(NULL,‘‘‘‘32)
D('992345',NULL,''25)
!:.
B
"#$%&IDENTITY'()#*+,-

/
A0
B10
C20
D30
!
A
SQL45$670#$8-9:;<=#>?
***@ABCDo
ADELETE
BCLEAR
CDROP
DREMORE
!
A
%&DE4FGAccount#******@IJKLHM
8-NO“”/
AUpdateaccountSETSex='
'whereSexR‘’
BUpdateaccountSETSex=''whereSex='
':.
CUpdateFROMaccountSETSex=''whereSex='

DUpdateFROMaccountSETSex=''whereSex='
,
!
B
T"UV9:#$WXYVZKL@[\]^_`
"2023a4000,bc"VZKLdefD
o
ACHECKgh
Bigh
Cjkgh
Dlmgh
!
A
%&SQLABGno#STUDENT$***@nopq
AGEKL@\rs1tuv%&***@ABCDE/
AREPLACEAGEWITHAGE+1
BUPDATESTUDENTAGEWITHAGE+1
CUPDATESETAGEWITHAGE+1
DUPDATESTUDENTSETAGE=AGE+1
!:.
D
******@yzw@***@C{./o
AUPDATE|*}~O'@\
BUPDATE*}~O}€\
CUPDATEc‚`ƒ~O@'„…€†@‡\
DUPDATE}ˆWHERE‰Š
!
C
Tƒ679:‹$Œ="@#S,c&DE/
ADELETETABLES
BDELETES
CDROPTABLES
DDROPS
!
C
Tstudent#$Žlmsudentid,‘’$-
studentid100„101@“”,b•–4F{
UPDATEstudentSETstudentid=101WHERE
studentid=100:.
>—˜,CDE/
A™š›œ{lm'}‡/
B‡ž‰9:/
C™š›œ{Ÿ lmgh/
D¡›œ™š˜‡9:/
!
C
"SQLServer¢9:‹$Œ-9:#student,c6
7£#9:***@ABCDo
ADROPFROMstudent
BDELETEFROMstudent
CREMOVEFROMstudent
DKILLFROMstudent
!
B
"T-SQL4z$&¤¥¦„‡9:***@ABCDE/
AINSERT,UPDATE
BDELETE,INSERT
CDELETE,UPDATE
DCREATE,INSERT:.
!
A
Transact-SQL45G9:¥¦a9:#***@4FC
INSERTINTO,~O9:***@4FCUPDATE/
§!¨w@
0#c©eª0lm/
§!¨™š
«¬w–@‡Ÿ ž­0gh®¯bb[°£4
F±²™š‘‡³´“”/
§!¨w@
67#(µ£#¶·@¯b„gh¸¹67/
§!¨™š
º\»xºK¼½®9\¾¿À#ÁÂÃÄÅÂ
Æ(Unknown)Åc&®G"ÇȈ***@9:/
§!¨w@
"9:‹ÉÊËÌ$9:ÍÎIC‚9:***@******@IÅ
-ÏI„ÐI/
§!¨w@
09:#$*}-0lmgh;c-ª0
UNIQUEgh/
§!¨******@:.
jk\Ñx9:ÍÎI@]Ò/
§!¨w@
ÓÔÍÎIC¯`·Ë$lÑIÕº/
§!¨w@
Ö(#}×Ø<=ÙÚ/
§!¨w@
º\'NULL(ÛÜÝ9:ÞÂߦàµ0®ás
â¾***@K¼½D”E@ã¶»/
§!¨™š
9:@-ÏIäCåæ9:Cçè"8`ãé@-
Ï]^êH/
§!¨w@
SQLServer$***@9:#C0ëƒ***@9:‹wì#
`ã'@íî/
§!¨w@
9:@ÍÎIëƒï]***@wìCÕz&ð/
§!¨™š
¯b%&|äñò`ã|/
§!¨™š
SQLServer+,KLóôK:.
§!¨™š
õfögh@'+,º/
§!¨™š
lmcC÷îm/
§!¨w@
)09:#$ñò©e0lm„0øm/
§!¨™š
NULLùº\,úx0/
§!¨™š
jkghC"CREATETABLE®ALTERTABLE4
F$`ã@67#@(ûjkgh˜üê67ž/
§!¨w@
9:‹wì¯bcý`a'T67£'8"#
b£¯b˜»(¹67/
§!¨™š
%&INSERT4F|*}#Ȉ–9:/
§!¨w@
ef9:#(GpqKL\_þ"18~25têÿ



:.
!"#
!"#$%
&'()*+

,-./01
2345678'9:)*+;<=>?
+@#
A+
BCSQLServer+)*DEFGHI+JKL
M#NO+)*PQRSTUV%WXY)*P
QZCBinary>Varbinary[Image

BC\+NO-]^_`abc-de^
A+
)*fDghij/345+)k<=
lmnD+ohiF
FOREIGN
KEY
A+
@#ApqrisCHECKPt
A+
uY)*+
RSEv)*fD+)*wx
A+
Dyz\{6h(IDENTITY),|r}~Dj
/5+)*;€‚8ƒ{6h„k:.
A+
…+h†‡ˆ8‰

DELETEŠ‹Œ-12D+)*ŽF
)*fD
A+
$employee+haddress8varchar(150))*
PQ‘’†‡ˆ8‰
ALTER_1_employee
ALTERCOLUMNaddressvarchar(150)_2<

1=TABLE
2=NOTNULL
B“rCREATETABLE”•z–—+BOOK˜
CREATETABLEBOOK
(š›œchar(6),:.
Pœchar(6),
¥¦char(6),
§¨numeric(10,2))
#“§¨”h+)*PQ8)kQh³´8
_1_,¶D·¸%_2¹º»)

1˜10
2˜2
ASt_Info(Áœ,¦ÃÄÅÆÇ,ÈÉ,ÊË)
$mÌÍÁVÊË4¦8“ÎÏÐÑÁ06