乌兰察布做网站,盐城网站建设建站,做网站的实施过程,网上商城推广方法SQL基础知识测试1 . SQL 指的是#xff1f;Strong Question LanguageStructured Question LanguageStructured Query Language2 . 哪个SQL 语句用于从数据库中提取数据#xff1f;EXTRACTSELECTOPENGET3 . 哪条SQL 语句用于更新数据库中的数据#xff1f;MODIFYSAVE ASUPDAT…SQL基础知识测试1 . SQL 指的是Strong Question LanguageStructured Question LanguageStructured Query Language2 . 哪个SQL 语句用于从数据库中提取数据EXTRACTSELECTOPENGET3 . 哪条SQL 语句用于更新数据库中的数据MODIFYSAVE ASUPDATESAVE4 . 哪条SQL 语句用于删除数据库中的数据COLLAPSEDELETEREMOVE5 . 哪条SQL 语句用于在数据库中插入新的数据INSERT NEWADD RECORDADD NEWINSERT INTO6 . 通过SQL您如何从 Persons表中选取 FirstName 列SELECT Persons.FirstNameSELECT FirstName FROM PersonsEXTRACT FirstName FROM Persons7 . 通过SQL您如何从 Persons表中选取所有的列SELECT [all] FROM PersonsSELECT PersonsSELECT * FROM PersonsSELECT *.Persons8 . 通过SQL您如何从 Persons表中选取 FirstName 列的值等于Peter 的所有记录SELECT [all] FROM Persons WHEREFirstNamePeterSELECT * FROM Persons WHERE FirstName LIKEPeterSELECT [all] FROM Persons WHERE FirstNameLIKE PeterSELECT * FROM Persons WHERE FirstNamePeter9 . 通过SQL您如何从 Persons表中选取 FirstName 列的值以a 开头的所有记录SELECT * FROM Persons WHERE FirstName LIKE a%SELECT * FROM Persons WHERE FirstNameaSELECT * FROM Persons WHERE FirstName LIKE%aSELECT * FROM Persons WHERE FirstName%a%10 . 请判断下列说法是否正确当所列出的某个条件为true 时OR 运算符会显示记录。当列出的所有条件为true 时AND 运算符会显示记录。正确错误11 . 通过SQL您如何在表 Persons 中选择FirstName 等于 Thomas 而LastName 等于 Carter 的所有记录SELECT * FROM Persons WHERE FirstName LIKEThomas AND LastName LIKE CarterSELECT FirstNameThomas,LastNameCarter FROM PersonsSELECT * FROM Persons WHERE FirstNameThomas AND LastNameCarter12 . 通过SQL您如何按字母顺序选取 Persons表中 LastName 介于 Adams 和 Carter 的所有记录SELECT * FROM Persons WHERE LastName BETWEEN Adams ANDCarterSELECT * FROM Persons WHERELastNameAdams AND LastNameSELECT LastNameAdams AND LastName13 . 哪条SQL 语句可返回唯一不同的值SELECT DIFFERENTSELECT DISTINCTSELECT UNIQUE14 . 哪个SQL 关键词用于对结果集进行排序ORDERSORT BYSORTORDER BY15 . 通过SQL您如何根据 FirstName列降序地从 Persons 表返回所有记录SELECT * FROM Persons SORT FirstName DESCSELECT * FROM Persons ORDER BY FirstName DESCSELECT * FROM Persons ORDER FirstName DESCSELECT * FROM Persons SORT BY FirstNameDESC16 . 通过SQL您如何向 Persons表插入新的记录INSERT (Jimmy, Jackson) INTO PersonsINSERT VALUES (Jimmy, Jackson) INTOPersonsINSERT INTO Persons VALUES (Jimmy, Jackson)17 . 通过SQL您如何向 Persons表中的 LastName 列插入Wilson INSERT INTO Persons (LastName) VALUES (Wilson)INSERT (Wilson) INTO Persons (LastName)INSERT INTO Persons (Wilson) INTOLastName18 . 您如何把Persons 表中 LastName 列的 Gates改为 Wilson MODIFY Persons SET LastNameWilson WHERELastNameGatesUPDATE Persons SET LastNameWilson WHERE LastNameGatesUPDATE Persons SET LastNameWilson INTOLastNameGatesMODIFY Persons SET LastNameWilson INTOLastNameGates19 . 通过SQL您如何在 Persons表中删除 FirstName 等于Fred 的纪录DELETE FROM Persons WHERE FirstName FredDELETE FirstNameFred FROM PersonsDELETE ROW FirstNameFred FROM Persons20 . 通过SQL您如何返回 Persons表中记录的数目SELECT COLUMNS() FROM PersonsSELECT COLUMNS(*) FROM PersonsSELECT COUNT() FROM PersonsSELECT COUNT(*) FROM Persons
