【单选题】
SQL Server 2000中表更新数据的命令是 。___
A. use
B. select
C. update
D. drop
查看试卷，进入试卷练习
微信扫一扫，开始刷题
相关试题
【单选题】
向用户授予操作权限的SQL语句是 。___
A. create
B. revoke
C. select
D. grant
【单选题】
数据库的三要素，不包括 。___
A. 完整性规则
B. 数据结构
C. 恢复
D. 数据操作
【单选题】
安装MSSQL Server时，系统自动建立几个数据库，其中有一个数据库被删除后，不影响系统的正常运行，这个数据库是 。___
A. master数据库
B. model数据库
C. tempdb 数据库
D. pubs数据库
【单选题】
以下情况发生，往往要求我们立即对master数据库进行备份，错误的是 。___
A. 增加用户数据库
B. 删除用户数据库
C. 执行与登录有关的操作
D. 增加数据库用户
【单选题】
能够实现执行SQL语句、分析查询计划、显示查询统计情况和实现索引分析等功能的SQL工具是 。___
A. 企业管理器
B. 查询分析器
C. 服务管理器
D. 事件探查器
【单选题】
当数据库损坏时，数据库管理员可通过何种方式恢复数据库 。___
A. 事务日志文件
B. 主数据文件
C. DELETE语句
D. 联机帮助文件
【单选题】
数据备份常用的方式主要有：完全备份、增量备份和 。___
A. 逻辑备份
B. 按需备份
C. 差异备份
D. 物理备份
【单选题】
SQL Sever 的默认DBA账号是 。___
A. administrator
B. sa
C. root
D. SYSTEM
【单选题】
主要用于加密机制的协议是 。___
A. HTTP
B. FTP
C. TELNET
D. SSL
【单选题】
当用户收到了一封可疑的电子邮件，要求用户提供银行账户及密码，这是属于何种攻击手段 。___
A. 缓存溢出攻击
B. 钓鱼攻击
C. 暗门攻击
D. DDOS攻击
【单选题】
使网络服务器中充斥着大量要求回复的信息，消耗带宽，导致网络或系统停止正常服务，这属于什么攻击类型 。___
A. 拒绝服务
B. 文件共享
C. BIND漏洞
D. 远程过程调用
【单选题】
如果要使H3C交换机当前配置在系统重启后继续生效，在重启设备前应使用_________命令将当前配置保存到配置文件中。___
A. save
B. delete
C. write
D. update
【单选题】
查看H3C交换机的系统版本信息的命令是_________。___
A. display current
B. show version
C. show running
D. display version
【单选题】
IP地址125.1.1.1对应的自然分类网段的广播地址为___。___
A. 125.1.1.1
B. 125.0. 0.1
C. 125.255.255.255
D. 125.0.0.0
【单选题】
IP地址172.15.1.1对应的自然分类网段包含的可用主机地址数为________个。___
A. 128
B. 256
C. 512
D. 65535
【单选题】
在windows操作系统的命令行下，进入控制台的命令是在“运行”里面键入___________。___
A. regedit
B. mstsc
C. mmc
D. gpedit、exe
【单选题】
在windows操作系统的命令行下，打开注册表的命令是___ __________。___
A. mstsc
B. gpedit、msc
C. regedit
D. nslookup
【单选题】
默认情况下，Windows远程桌面被启用后，被打开的端口为_______。___
A. 3306
B. 1433
C. 3389
D. 443
【单选题】
一般情况下，HTTPS默认使用TCP端口号________。___
A. 433
B. 1433
C. 8443
D. 443
【单选题】
H3C交换机查看当前所有配置信息的命令是________。___
A. show running-config
B. show current-config
C. dis running-config
D. display current-config
【单选题】
以下哪个选项不是防火墙提供的安全功能：___
A. IP地址欺骗防护
B. NAT
C. 访问控制
D. SQL注入攻击防护
【单选题】
下面对访问控制技术描述最准确的是：___
A. 保证系统资源的可靠性
B. 实现系统资源的可追查性
C. 防止对系统资源的非授权访问
D. 保证系统资源的可信性
【单选题】
以下哪种无线加密标准是安全性最弱？___
A. WEP
B. WPA
C. WPA2
D. WAPI
【单选题】
在关系型数据库系统中通过“视图（view）”技术，可以实现以下哪种安全原则？___
A. 纵深防御原则
B. 最小权限原则
C. 职责分离原则
D. 安全性与便利性平衡原则
【单选题】
攻击者在远程WEB页面的HTML代码中插入具有恶意目的的数据，用户认为该页面是可信赖的，但是当浏览器下载该页面，嵌入其中的脚本将被解释执行，这是哪种类型的漏洞？___
A. 缓冲区溢出
B. SQL注入
C. 设计错误
D. 跨站脚本
【单选题】
通常在网站数据库中，用户信息中的密码一项，是以哪种形式存在？___
A. 明文形式存在
B. 服务器加密后的密文形式存在
C. hash运算后的消息摘要值存在
D. 用户自己加密后的密文形式存在
【单选题】
张三将微信个人头像换成微信群中某好友头像，并将昵称改为该好友的昵称，然后向该好友的其他好友发送一些欺骗消息。该攻击行为属于以下哪类攻击？___
A. 口令攻击
B. 暴力破解
C. 拒绝服务攻击
D. 社会工程学攻击
【单选题】
_______是智慧高速公路的智慧引擎，是建设智慧高速公路的关键。___
A. GIS
B. BIM
C. AI
D. 大数据应用分析
【单选题】
“十三五”建设目标要实现监控视频数字高清率达到_______，高速公路重点路段动态监测覆盖率达到_______。___
A. 100%，100%
B. 90%，90%
C. 100%，90%
D. 90%，100%
【单选题】
为了实现快速、无损、智能的全自动化道路检测，为管理养护计划提供全面准确科学依据，最有效的设备为_______。___
A. 高清摄像头
B. 智能道路检测车等移动监测设施
C. 无人机
D. 人工巡查车
【单选题】
"BIM"的全称是_______。___
A. 建筑信息模型
B. 全球卫星定位系统
C. 北斗卫星定位系统
D. 建筑定位系统
【单选题】
_____是负责对物联网收集到的信息进行处理、管理、决策的后台计算处理平台。___
A. 感知层
B. 网络层
C. 云计算平台
D. 物理层
【单选题】
_____是物联网识别物体，采集信息的来源。 ___
A. 网络层
B. 感知层
C. 应用层
D. 云计算平台
【单选题】
RFID卡_____可分为：主动式标签（TTF）和被动式标签（RTF）。___
A. 按供电方式
B. 按工作频率
C. 按通信方式
D. 按标签芯片
【单选题】
云计算中SaaS是指____。 ___
A. 平台即服务
B. 软件即服务
C. 基础设施即服务
D. 通信即服务
【单选题】
以下特征中不属于物联网特征的是_____。 ___
A. 全面感知
B. 可靠传输
C. 智能处理
D. 虚拟化
【单选题】
由第三方服务商为用户提供的能够使用的云称为_____。 ___
A. 私有云
B. 公有云
C. 混合云
D. 社区云
【单选题】
车道车辆检测器计数精度偏差为≤0.1%，实测方法为人工记数核对，要大于_____。___
A. 100辆
B. 300辆
C. 500辆
D. 1000辆
【单选题】
电动栏杆起落总时间规定为≤4.0s，实测方法为_____。___
A. 秒表测10次，取平均值
B. 秒表测20次，取平均值
C. 秒表测50次，取平均值
D. 秒表测100次，取平均值
【单选题】
收费天棚信号灯的色度和亮度应符合_____。___
A. GB 14885
B. GB 14886
C. GB 14887
D. GB 14888
推荐试题
【单选题】
When is it possible to place a VMFS5 datastore in maintenance mode? ___
A. When it is a member of a Storage DRS cluster
B. When it is a member of Virtual SAN cluster
C. When it is a member of a multi-extent datastore
D. When it is a member of a Virtual Volume
【单选题】
Immediately after installing ESXi, an administrator observes that the Configure Lockdown Mode option is grayed out in the Direct Console User Interface (DCUI). What is the most likely explanation? ___
A. The host has not yet been added to a vCenter Server.
B. The BIOS on the host does not have NX/XD enabled.
C. The ESXi host is running in evaluation mode.
D. The host requires a reboot before this feature is available.
【单选题】
Immediately after installing ESXi, an administrator observes that the Configure Lockdown Mode option is grayed out in the Direct Console User Interface (DCUI). What is the most likely explanation? ___
A. The host has not yet been added to a vCenter Server.
B. The BIOS on the host does not have NX/XD enabled.
C. The ESXi host is running in evaluation mode.
D. The host requires a reboot before this feature is available.
【单选题】
Which Single Sign-On deployment mode should an administrator use for two 6.x vCenter Servers configured with linked mode? ___
A. Basic Single Sign-On with vCenter Server Heartbeat
B. Multisite Single Sign-On
C. Basic Single Sign-On
D. Single Sign-On with Linked Mode
【单选题】
What is required when changing a virtual machine name using the vSphere Web Client? ___
A. Verify connectivity to the ESXi host where the virtual machine is running and its inventory list is accessible.
B. Verify in which datastore the virtual machine resides and that you have access and its inventory list is accessible.
C. Verify that virtual machine files are stored in the same datastore and can be accessed in the datastore browser list.
D. Verify the virtual machine is not running in Fault Tolerant mode and that it is not in a Distributed Resource Scheduler cluster.
【单选题】
An administrator deploys vRealize Operations into a vSphere 6.x environment. After the deployment, the administrator notices that badges are not appearing. What is a likely cause of this behavior? ___
A. Badges do not appear until you register vRealize Operations with vCenter Server.
B. Badges do not appear until you register a vCenter Server in vRealize Operations.
C. The vRealize Operations appliance needs to be redeployed.
D. The vCenter Server appliance needs to be redeployed.
【单选题】
How are ports scaled on vSphere Standard Switches (vSS)? ___
A. Ports on a vSS can be dynamically scaled up and down.
B. Ports on a vSS can only be statically scaled up or down.
C. Ports on a vSS can only be dynamically scaled down.
D. Ports on a vSS can only be dynamically scaled up.
【单选题】
A High Availability (HA) cluster is configured to respond to a given number of host failures. The cluster contains virtual machines configured with these settings: VM1 has a 1GHz CPU reservation and no Memory reservation VM2 has a 2GHz CPU reservation and no Memory reservation VM3 has no CPU reservation and no Memory reservation . Given this information, what is the correct slot size for the cluster? ___
A. The CPU Reservation should be set to 32MHz and the memory reservation should be set to 32MB plus memory overhead.
B. The CPU reservation should be set to 1 GHz and the memory reservation should be set to 0MB plus memory overhead.
C. The CPU reservation should be set to 2 GHz, and the memory reservation should be set to 0MB plus the virtual machine memory overhead.
D. The CPU reservation should be set to 2 GHz, and the memory reservation should be set to 32MB, plus the virtual machine memory overhead.
【单选题】
An administrator is planning a vSphere infrastructure with the following specific networking requirements: <The ability to shape inbound (RX) traffic> <Support for Private VLANs (PVLANs)> <Support for LLDP (Link Layer Discovery Protocol)>. What is the minimum vSphere Edition that will support these requirements? ___
A. vSphere Essentials Plus
B. vSphere Standard
C. vSphere Enterprise
D. vSphere
E. nterprise Plus
【单选题】
When you add an ESXi 6.x host to a new Cluster, which vSphere object owns the CPU and Memory resources of the hosts? ___
A. vCenter Server
B. Datacenter
C. Cluster
D. Host
【单选题】
A user is trying to retrieve objects from a SharePoint server and finds the request is taking an excessive amount of time. An administrator tries to isolate the issue and notes the following: Application performance is poor when compared to virtual machines on other hosts. Performance improves when the virtual machine is moved to another host. The virtual machine encounters higher than expected CPU %Ready times. What conclusion can be reached regarding the performance issues for this virtual machine? ___
A. Host Power Management is directly impacting virtual machine performance.
B. The virtual machine has a large number of snapshots.
C. The Path Selection Policy for the storage device is set differently on the affected host.
D. Network I/O control is configured for the portgroup.
【单选题】
A virtual machine template is accidently removed from the vCenter Server Inventory. Which method would be used to recover the template back into the environment?___
A. Use the datastore browser to locate the template, then right click and add the .vmtx file to inventory.
B. Use the datastore browser to locate the template, then right click and add the .vmx file to inventory.
C. Using the Managed Object Browser and adding the template from the ManagedObjectReference:GuestFileManager object.
D. Using the Managed Object Browser and adding the template from the ManagedObjectReference:VirtualDiskManager object.
【单选题】
A vSphere administrator needs to backup a virtual machine that has a Microsoft SQL Server Database installed. Which solution allows for an application quiesce to occur during backup?___
A. VMware vCenter Converter
B. VMware vCenter Site Recovery Manager
C. VMware vSphere Replication
D. VMware vSphere Data Protection Advanced
【单选题】
An administrator is migrating a virtual machine from a Test cluster to a Production cluster. The two environments do not have any shared storage. What is the easiest way to accomplish this task? ___
A. Perform a Storage vMotion.
B. Perform a regular vMotion.
C. Perform a Virtual to Virtual migration.
D. Perform a backup and restore using VMware Data Protection.
【单选题】
An administrator must determine an appropriate backup solution, given these conditions: 50 of the virtual machines are in a resource pool named Finance. 50 of the virtual machines are in a resource pool named QA. Which solution allows an administrator the ability to backup 100 virtual machines? ___
A. Use Snapshot Manager on the vCenter Server to backup the virtual machines.
B. Use the VMware Consolidated Backup (vcb) tool on the ESXi Host to backup the virtual machines.
C. Use the VMware Data Recovery (VDR) Appliance on the vCenter Server to backup the virtual machines.
D. Use the VMware Data Protection (VDP) Appliance on one of the
E. SXi Hosts to backup the virtual machines.
【单选题】
What is a benefit of using Enhanced vMotion Compatibility for an environment? ___
A. EVC masks CPU features to allow compatibility between hosts that are dissimilar.
B. EVC allows for cross platform vMotion to occur.
C. EVC enables Long
D. istance vMotion.
【单选题】
How many Link Aggregation Groups (LAGs) can be configured on a vSphere 6.x Distributed Switch? ___
A. 64
B. 96
C. 128
D. 256
【单选题】
How many Link Aggregation Groups (LAGs) can be configured on a vSphere 6.x Distributed Switch? ___
A. 64
B. 96
C. 128
D. 256
【单选题】
An administrator needs to verify that vMotion operations can be performed in a vSphere data center.What round trip time (RTT) latency is the maximum value that will allow vMotion operations to succeed? ___
A. 50ms RTT
B. 100ms RTT
C. 150ms RTT
D. 200ms RTT
【单选题】
A storage administrator has reported that full utilization of all bandwidth from an ESXi 6.x host is not being seen. In troubleshooting the issue, the Adapter details are shown in the Exhibit. Based on the exhibit, what is cause of the issue? ___
A. The array is not setup to use the correct multipathing policy.
B. There are no virtual machines on the ESXi host.
C. Not all links are used because a path is disabled.
D. Another path needs to be configured.
【单选题】
An administrator is migrating a powered-on virtual machine, as shown in the exhibit. Which option should be selected to perform a Storage vMotion of the VM? ___
A. Change storage only
B. Change VM compute resource only
C. Change both compute resource and storage, changing the compute resource first.
D. Change both compute resource and storage, changing the storage resource first.
【单选题】
An administrator is attempting to enable Storage I/O Control on a datastore, but it is failing. What is the likely reason for this failure? ___
A. The host is connected to a datastore is running on ESX 4.0.
B. The host is connected to a Fibre Channel storage array.
C. The datastore has multiple extents.
D. The datastore is managed by a single vCenter Server.
【单选题】
A mission-critical virtual machine built on vSphere 4.1 needs to be moved to an ESXi 6.x host.Which virtual hardware version is needed to move the virtual machine without upgrading? ___
【单选题】
An administrator is analyzing a virtual machine as shown in the Exhibit. What is the current long term risk for this virtual machine? ___
A. The virtual machine may run out of memory before April 27.
B. The virtual machine may continue to function after April 27.
C. The virtual machine has adequate memory configured for operation for the next 120 days.
D. The virtual machine has adequate memory reservation configured for operation for the next 120 days.
【单选题】
An administrator is monitoring a High Availability (HA) and Distributed Resource Scheduler (DRS) enabled cluster and has noticed that virtual machines in the cluster are being migrated without user intervention. Why is this happening? ___
A. The DRS Automation level is set to Fully Automated.
B. The Automation level is set to Automatic.
C. The
D. PM Threshold is set to Aggressive.
【单选题】
An administrator attempts to migrate a suspended virtual machine to a newly deployed vSphere 6.x cluster. The compatibility check fails. What condition could cause this behavior?___
A. The new vSphere 6.x cluster is running Intel CPUs instead of AMD CPUs.
B. A suspended virtual machine cannot be migrated.
C. The hardware virtualization feature of the CPU is not enabled on the new hosts.
D. A vSphere Distributed Switch is required to migrate a suspended virtual machine.
【单选题】
A vSphere administrator has been using vSphere in evaluation mode and now wants to deploy an environment that provides the same features. Which edition of vSphere provides similar functionality to evaluation mode? ___
A. Enterprise Plus
B. Enterprise
C. Standard
D. Essentials
【单选题】
A vSphere administrator has been using vSphere in evaluation mode and now wants to deploy an environment that provides the same features. Which edition of vSphere provides similar functionality to evaluation mode? ___
A. Enterprise Plus
B. Enterprise
C. Standard
D. Essentials
【单选题】
An administrator has just configured the IP address on an ESXi host from the Direct Console User Interface. How can the configuration be validated as correct without any additional tools?___
A. Add the host to vCenter Server and if it works, then all networking settings are ok.
B. Select the Test Management Network option from the DCUI.
C. Connect to the host with the vSphere Client and click the Test Network option.
D. Use PowerCLI to connect to the host and initiate a network test.
【单选题】
An administrator is installing vCenter Server for an environment that has 40 ESXi 6.x Hosts and 150 virtual machines. Which database would meet the minimal requirements needed for this task? ___
A. vFabric Postgres
B. Microsoft SQL Express 2008
C. Microsoft SQL Server 2014
D. Oracle 11g
【单选题】
What is a requirement when enabling a Virtual SAN cluster in an existing High Availability (HA) and Distributed Resource Scheduler (DRS) Cluster? ___
A. Disable DRS and HA before enabling Virtual SAN
B. Enable DRS before enabling Virtual SAN
C. Disable HA before enabling Virtual SAN
D. Enable Storage DRS before enabling Virtual SAN
【单选题】
The vSphere administrator attempts to connect to an ESXi host via an SSH client and receives the following security alert: The vSphere administrator needs to determine whether the RSA key fingerprint shown in the security alert is the fingerprint of the intended ESXi host. Which tool should the vSphere administrator use? ___
A. Direct Console User Interface
B. vSphere Client
C. vSphere Web Client
D. vSphere Management Assistant
【单选题】
An administrator needs to monitor traffic on vSwitches in a vSphere 6.x environment. Which option, if configured, would accomplish this task? ___
A. Forged Transmits
B. MAC Address Changes
C. Promiscuous Mode
D. Notify Switches
【单选题】
What is true regarding datastores on ESXi 6.x? ___
A. NFS 4.1 datastore does not support Fault Tolerance (FT)
B. VMFS3 and VMFS5 datastores can be newly created
C. NFS datastore can be concurrently mounted using NFS 4.1 on one host and NFS on another
D. NFS 3.0 datastore does not support Fault Tolerance (FT)
【单选题】
An administrator is cloning and configuring five new web server virtual machines. What would be the benefit of configuring resource shares for the new VMs? ___
A. To prioritize access to a resource during contention.
B. To guarantee access to a resource during contention.
C. To prioritize access to a resource before contention occurs.
D. To guarantee access to a resource before contention occurs.
【单选题】
An administrator logs into the vSphere Web Client and sees the warning shown in the Exhibit. During a change control window, the warning was addressed. What should be done to verify that the host is no longer showing the warning? ___
A. Run a Remediate host operation.
B. Recheck the compliance of the host.
C. Restart the host to get rid of the warning.
D. Install VMware tools to clear the warning.
【单选题】
A vApp named Sales has a Memory Limit of 32 GB and a CPU Limit of 12,000 MHz. There are three virtual machines within the vApp: <Sales-DB -- Has a memory reservation of 20 GB. > <Sales-DC -- Has a memory reservation of 8 GB. > <Sales-Web -- Has a memory reservation of 8 GB.> Which statement is correct? ___
A. All three virtual machines can power on, but will have memory contention.
B. All three virtual machines can power on without memory contention.
C. Only two of the three virtual machines can power on.
D. Only one of the virtual machines can power on.
【单选题】
You are editing the management network configuration of an ESXi 6.x Host from the vSphere Web Client. You mistakenly put the incorrect VLAN in place for the management network. What action do you need to take to correct this? ___
A. You need to manually edit the configuration on the host with command line utilities.
B. No action is required. By default ESXi rolls back configuration changes that disconnect the host.
C. The ESXi host system configuration will need to be restored to the factory configuration to fix the issue.
D. The change can be reverted in the vSphere Web Client by simply editing the switch again.
【单选题】
What is true about resource pools created on a Distributed Resource Scheduler (DRS) cluster?___
A. A root resource pool is created with the specified values.
B. A root resource pool is automatically created using the aggregate total of the ESXi host resources in the cluster.
C. A root resource pool is automatically created using the aggregate total of all resources in the datacenter.
D. A root resource pool is not needed when creating resource pools on a DRS cluster.
【单选题】
An administrator attempts to enable Enhanced vMotion Compatibility (EVC) on a cluster. The operation results in a compatibility error, as shown in the exhibit. What is the likely cause of this error? ___
A. The CPUs in the ESXi host are not AMD CPUs.
B. The CPUs in the ESXi host do not support hardware virtualization capabilities.
C. The XD/NX CPU features have not been enabled in the BIOS of the server.
D. There is no shared storage between the hosts in the cluster.
