SQL基础数据库测试试题及答案

SQL基础数据库测试试题及答案1.SQL指的是?StrongQuestionLanguageStructuredQuestionLanguage(正确答案)StructuredQueryLanguage2.哪个SQL语句用于从数据库中提取数据?EXTRACTSELECT(正确答案)OPENGET3.哪条SQL语句用于更新数据库中的数据?MODIFYSAVEASUPDATE(正确答案)SAVE4.哪条SQL语句用于删除数据库中的数据?COLLAPSEDELETE(正确答案)REMOVE5.哪条SQL语句用于在数据库中插入新的数据?INSERTNEWADDRECORDADDNEWINSERTINTO(正确答案)7.通过SQL，您如何从"Persons"表中选取所有的列?SELECT[all]FROMPersonsSELECTPersonsSELECT*FROMPersons(正确答案)SELECT*.Persons8.通过SQL，您如何从"Persons"表中选取"FirstName"列的值等于"Peter"的所有记录?SELECT[all]FROMPersonsWHEREFirstName='Peter'SELECT*FROMPersonsWHEREFirstNameLIKE'Peter'SELECT[all]FROMPersonsWHEREFirstNameLIKE'Peter'SELECT*FROMPersonsWHEREFirstName='Peter'(正确答案)9.通过SQL，您如何从"Persons"表中选取"FirstName"列的值以"a"开头的所有记录?SELECT*FROMPersonsWHEREFirstNameLIKE'a%'(正确答案)SELECT*FROMPersonsWHEREFirstName='a'SELECT*FROMPersonsWHEREFirstNameLIKE'%a'SELECT*FROMPersonsWHEREFirstName='%a%'10.请判断下列说法是否正确:当所列出的某个条件为true时，OR运算符会显示记录。当列出的所有条件为true时，AND运算符会显示记录。正确(正确答案)错误11.通过SQL，您如何在表Persons中选择FirstName等于Thomas而LastName等于Carter的所有记录?SELECT*FROMPersonsWHEREFirstNameLIKE'Thomas'ANDLastNameLIKE'Carter'SELECTFirstName='Thomas',LastName='Carter'FROMPersonsSELECT*FROMPersonsWHEREFirstName='Thomas'ANDLastName='Carter'(正确答案)12.通过SQL，您如何按字母顺序选取Persons表中LastName介于Adams和Carter的所有记录?SELECT*FROMPersonsWHERELastNameBETWEEN'Adams'AND'Carter'(正确答案)SELECT*FROMPersonsWHERELastName>'Adams'ANDLastName<'Carter'SELECTLastName>'Adams'ANDLastName<'Carter'FROMPersons13.哪条SQL语句可返回唯一不同的值?SELECTDIFFERENTSELECTDISTINCT(正确答案)SELECTUNIQUE14.哪个SQL关键词用于对结果集进行排序?ORDERSORTBYSORTORDERBY(正确答案)15.通过SQL，您如何根据"FirstName"列降序地从"Persons"表返回所有记录?SELECT*FROMPersonsSORT'FirstName'DESCSELECT*FROMPersonsORDERBYFirstNameDESC(正确答案)SELECT*FROMPersonsORDERFirstNameDESCSELECT*FROMPersonsSORTBY'FirstName'DESC16.通过SQL，您如何向"Persons"表插入新的记录?INSERT('Jimmy','Jackson')INTOPersonsINSERTVALUES('Jimmy','Jackson')INTOPersonsINSERTINTOPersonsVALUES('Jimmy','Jackson')(正确答案)17.通过SQL，您如何向"Persons"表中的"LastName"列插入"Wilson"?INSERTINTOPersons(LastName)VALUES('Wilson')(正确答案)INSERT('Wilson')INTOPersons(LastName)INSERTINTOPersons('Wilson')INTOLastName18.您如何把"Persons"表中"LastName"列的"Gates"改为"Wilson"?MODIFYPersonsSETLastName='Wilson'WHERELastName='Gates'UPDATEPersonsSETLastName='Wilson'WHERELastName='Gates'(正确答案)UPDATEPersonsSETLastName='Wilson'INTOLastName='Gates'MODIFYPersonsSETLastName='Wilson'INTOLastName='Gates'19.通过SQL，您如何在"Persons"表中删除"FirstName"等于"Fred"的纪录?DELETEFROMPersonsWHEREFirstName='Fred'(正确答案)DELETEFirstName='Fred'FROMPersonsDELETEROWFirstName='Fred'FROMPersons20.通过SQL，