2012年计算机二级Access考试模拟试题9-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

2012年计算机二级Access考试模拟试题9

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:02 PM

accessLevel 2take an examcomputer

21．若要用设计视图创建一个查询，查找总分在255分以上（包括255分）的女同学的姓名、性别和总分，正确的设置查询准则的方法应为(21)。 A．在准则单元格键入：总分=255AND性别=女 B．在总分准则单元格键入：总分=255；在性别的准则单元格键入：女 C．在总分

21．若要用设计视图创建一个查询，查找总分在255分以上（包括255分）的女同学的姓名、性别和总分，正确的设置查询准则的方法应为(21) 。
A．在准则单元格键入：总分>=255  AND 性别=”女”
B．在总分准则单元格键入：总分>=255；在性别的准则单元格键入：”女”
C．在总分准则单元格键入：>=255；在性别的准则单元格键入：”女”
D．在准则单元格键入：总分>=255  OR  性别=”女”
22.在查询设计器中不想显示选定的字段内容则将该字段的（22）项对号取消。
A．排序   B．显示    C．类型   D．准则
23．交叉表查询是为了解决（23）
A．一对多关系中，对“多方”实现分组求和的问题。
B．一对多关系中，对“一方”实现分组求和的问题。
C．一对一关系中，对“一方”实现分组求和的问题。
D．多对多关系中，对“多方”实现分组求和的问题。
24.在“查询参数”窗口定义查询参数时，除定义查询参数的类型外，还要定义查询参数的（24）。
A．参数名称         B.参数值
C.什么也不定义      D.参数值域来自www.Examw.com
25．SQL查询能够创建（25）。
A．更新查询       B．追加查询
C．选择查询       D．以上各类查询

21~25 C B A A D

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How Do I Drop or Modify an Existing View in MySQL?May 16, 2025 am 12:11 AM

TodropaviewinMySQL,use"DROPVIEWIFEXISTSview_name;"andtomodifyaview,use"CREATEORREPLACEVIEWview_nameASSELECT...".Whendroppingaview,considerdependenciesanduse"SHOWCREATEVIEWview_name;"tounderstanditsstructure.Whenmodifying

MySQL Views: Which design patterns can I use with it?May 16, 2025 am 12:10 AM

MySQLViewscaneffectivelyutilizedesignpatternslikeAdapter,Decorator,Factory,andObserver.1)AdapterPatternadaptsdatafromdifferenttablesintoaunifiedview.2)DecoratorPatternenhancesdatawithcalculatedfields.3)FactoryPatterncreatesviewsthatproducedifferentda

What Are the Advantages of Using Views in MySQL?May 16, 2025 am 12:09 AM

ViewsinMySQLarebeneficialforsimplifyingcomplexqueries,enhancingsecurity,ensuringdataconsistency,andoptimizingperformance.1)Theysimplifycomplexqueriesbyencapsulatingthemintoreusableviews.2)Viewsenhancesecuritybycontrollingdataaccess.3)Theyensuredataco

How Can I Create a Simple View in MySQL?May 16, 2025 am 12:08 AM

TocreateasimpleviewinMySQL,usetheCREATEVIEWstatement.1)DefinetheviewwithCREATEVIEWview_nameAS.2)SpecifytheSELECTstatementtoretrievedesireddata.3)Usetheviewlikeatableforqueries.Viewssimplifydataaccessandenhancesecurity,butconsiderperformance,updatabil

MySQL Create User Statement: Examples and Common ErrorsMay 16, 2025 am 12:04 AM

TocreateusersinMySQL,usetheCREATEUSERstatement.1)Foralocaluser:CREATEUSER'localuser'@'localhost'IDENTIFIEDBY'securepassword';2)Foraremoteuser:CREATEUSER'remoteuser'@'%'IDENTIFIEDBY'strongpassword';3)Forauserwithaspecifichost:CREATEUSER'specificuser'@

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

See all articles