A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?()
Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B. From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C. At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D. Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.
查看答案
认购C公司普通股10万股计划长期持有,每股面值1元,实际买价每股15元,其中包含每股已宣告发放但尚未收取的现金股利0.3元;另外支付相关费用6000元。该批股票的初始投资成本为()。
A. 1000000元
B. 1476000元
C. 1500000元
D. 1506000元
气动调节器要安装在垂直管道上。
A. 正确
B. 错误
我国《集体合同规定》,集体合同或专项集体合同期满前(),任何一方均可向对方提出重新签订或续订的要求。
A. 1个月内
B. 2个月内
C. 3个月内
D. 6个月内
转让专利申请权或者专利权的,当事人应当订立书面合同,并向国务院专利行政部门登记,由国务院专利行政部门予以公告。专利申请权或者专利权的转让自登记之日起生效。
A. 正确
B. 错误