You are the administrator of a SQL Server 2000 computer. The server contains a database named inventory. The database has a Parts table that has a field named InStock. When parts are shipped, a table named PartsShipped is updated. When Parts are received, a table names PartsReceived is updated. The relationship of these tables is shown in the exhibit.
You want the database to update the InStock field automatically. What should you do?
Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B. Create a user-defined function those calculations that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C. Use a view that creates an InStock as a part of an aggregate query.
D. Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock fielding the parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.
查看答案
某公司预计2002年应收账款的总计金额为3 000万元,必要的现金支付为2100万元,应收账款收现以外的其他稳定可靠的现金流入总额为600万元,则该公司2002年的应收账款收现保证率为()。
A. 0.7
B. 0.2075
C. 0.5
D. 0.2857
有以下结构体说明和变量定义,如下图所示,指针p、q、r分别指向一个链表中的3个连续结点。 struct node { int data; struct node *next; } *p,*q,*r;
现要将q和r所指结点的先后位置交换,同时要保持链表的连续,以下错误的程序段是()。
A. r->next=q;q->next=r->next;p->next=r;
B. q->next=r->neaxt;p->next=r;r->next=q;
C. p->next=r;q->next=r->next;r->next=q;
D. q->next=r->next;r->next=q;p->next=r;