题目内容

下列数据表。仓库(仓库号C(3)、所在地C(8)、人数N(2)) 职工(仓库号C(3)、职工号C(2)、姓名C(8)、工资I) 检索最少有4名职工仓库的职工平均工资( )。

A) SELECT 仓库号,COUNT() AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 WHERE COUNT()＞=4
B) SELECT 仓库号,COUNT() AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 HAVING COUNT()＞=4
C) SELECT 仓库号,COUNT() AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 职工号 WHERE COUNT()＞=4
D) SELECT 仓库号,COUNT() AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 职工号 HAVING COUNT()＞=4

查看答案

搜索结果不匹配？点我反馈

更多问题

Certificates are documents attesting to the of a public key to an individual or other entity. They allow verification of the claim that a given publickey does in fact belong to a given individual. Certificates help prevent some one from using a phony key to someone else. In their simplest form, Certificates contain a public key and a name. As commonly used, a certificate also contains an date, the name of the CA that issued the certificate, a serial number, and perhaps other information. Most importantly, it contains the digital __ of the certificate issuer. The most widely accepted format for certificates is X.509 , thus, Certificates can be read or written by any application complying with X.509.

A. connecting
B. binding
C. composing
D. conducting

Certificates are documents attesting to the of a public key to an individual or other entity. They allow verification of the claim that a given publickey does in fact belong to a given individual. Certificates help prevent some one from using a phony key to someone else. In their simplest form, Certificates contain a public key and a name. As commonly used, a certificate also contains an date, the name of the CA that issued the certificate, a serial number, and perhaps other information. Most importantly, it contains the digital __ of the certificate issuer. The most widely accepted format for certificates is X.509 , thus, Certificates can be read or written by any application complying with X.509.

A. impersonate
B. personate
C. damage
D. control

下列数据表。仓库(仓库号C(3)、所在地C(8)、人数N(2)) 职工(仓库号C(3)、职工号C(2)、姓名C(8)、工资I) 有下列SQL语句： INSERT INTO 职工 VALUES("WH4","E15","张清",2800) 在命令窗口执行该命令后( )。

A) 向表中任意位置插入一条新记录
B) 在当前记录之前，插入一条新语句
C) 在当前记录之后，插入一条新语句
D) 在表末尾新增一条记录

下列数据表。仓库(仓库号C(3)、所在地C(8)、人数N(2)) 职工(仓库号C(3)、职工号C(2)、姓名C(8)、工资I) 为“仓库”表增加一个“面积”字段，类型为数值型，宽度是7，小数位数为2，正确的命令是( )。

A) CREATE TABLE 仓库 ADD 面积 N(7,2)
B) CREATE TABLE 仓库 ALTER 面积 N(7,2)
C) ALTER TABLE 仓库 ADD 面积 N(7,2)
D) ALTER TABLE 仓库 ALTER 面积 N(7,2)