A location where data can be temporarily Stored.A.AreaB.DiskC.BufferD.File
A location where data can be temporarily Stored.
A.Area
B.Disk
C.Buffer
D.File
A location where data can be temporarily Stored.
A.Area
B.Disk
C.Buffer
D.File
A location where data can betemporarily stored.
A.Area
B.Disk
C.Buffer
D.File
A.access
B.make
C.learn
D.bring
B.The shelf life expiration date check is activated for the movement type
C.The storage location where the material is received is warehouse-managed
D.The remaining shelf life is maintained in the purchase order
E.The material is managed in batches
A.Issue the vmkfstools -vmfs unmap command within the VMFS volume directory on the ESXihost console
B.Use VMware Converter to migrate the virtual machine to a new datastore. This will recreate the volumes and recover all unused space
C.Perform. a Storage vMotion to another volume in order to force free space recovery to occur.This recreates the volume in a new location and recovers all unused space
D.Execute the esxcli storage vmfs unmap command
● 试题(66)~(70)给出了计算机英文术语的解释,请从供选择的参考答案中
选择正确的术语。
(66) : An error can be caused by attempting to divide by 0.
(66)
A. Interrupt
B. Default
C. Underflow
D. Overflow
(67) : The process of identifying and correcting errors in a program.
(67)
A. Debug
B. Bug
C. Fault
D. Default
(68) : A collection of related information, organized for easy retrieval.
(68)
A. Data
. Database
C. Buffer
. Stack
(69) : A location where data can be temporarily stored.
(69)
A. Area
B. Disk
C. Buffer
D. File
(70 ) : A graphical bar with buttons that perform some of the most common commands.
(70)
A. Title bar
B. Tool bar
C. Status bar
D. Scroll bar
【问题 1】 (3 分) 请将下面创建销售单表的 SQL 语句补充完整,要求指定关系的主码和外码约束。 CREATE TABLE SALES(Sno CHAR(8) (a) VEMno CHAR(5) (b) Gno CHAR(8) (c) SDate DATE, STime TIME); 【问题 2】 (4分) 创建销售记录详单视图 SALES_Detail ,要求按日期统计每个售货机上各种商品的销售数量,属性有 VEMno、Location 、Gno、Brand 、Price 、amount 和 SDate。为方便实现,首先建立一个视图 SALES_Total ,然后利用SALES_Total 完成视图 SALES_Detail 的定义。 CREATE VIEW SALES _Total(VEMno,Gno,SDate,amount) AS SELECT VENno ,Gno ,SDate ,count(*) FROM SALES GROUP BY (d); CREATE VIWE (e) AS SELECT VEM.VEMno,Location ,GOODS.Gno ,Brand,Price,amount,SDate FROM VEM,GOODS,SALES_Total WHERE (f) AND (g) 【问题 3】 (3分) 每售出一件商品,就自动向销售单中添加一条销售记录。如果一天内某个售货机上某种商品的销售记录达到 10 条,则自动向缺货单中添加一条缺货记录。需要用触发器来实现缺货单的自动维护。程序中的 GetTime()获取当前时间。 CREAT(h) OOS_TRG AFTER (i) ON SALES REFERENCING new row AS nrow FOR EACH ROW BEGIN INSERT INTO OOS SELECT SALES .VENno, (j) GetTime() FROMSALES WHERE SALES.VEMno = nrow.VEMno AND SALES.Gno = nrow.Gno AND SALES.SDate = nrow.SDate GROUP BY SALES.VEMno,SALES.Gno,SALES.SDate HAVING count(*)> 0 AND mod(count(*), 10)=0; END 【问题 4】 (3分) 查询当天销售最多的商品编号、品牌和数量。程序中的 GetDate()获取当天日期。 SELECT GOODS.Gno ,Brand, (k) FROM GOODS,SALES WHERE GOODS.Gno=SALES.GNO AND SDATE =GetDate() GROUP BY (1) HAVING(M) (SELECT count(*) FROM SALELS WHERE SDATE = GetDate() GROUP BY Gno); 【问题5】 (2分) 查询一件都没有售出的所有商品编号和品牌。 SELECT Gno ,Brand FROM GOODS WHERE GNO(N) SELECT DISTINCT GNO FROM(o);