You are a database developer for a marketing firm. You have designed aquarterly sales view. This view joins several tables and calculates aggregateinformation. You create a view. You want to provide a parameterised queryto access the data contained in your view. The output will be used in otherSELECT lists. How should you accomplish this goal?
A. Use an ALTER VIEW statement to add the parameter value tothe view definition.
B. Create a stored procedure that accepts the parameter asinput and returns a rowset with the result set.
Create a scalar user-defined function that accepts theparameter as input.
D. Create an inline user-defined function that accepts theparameter as input
查看答案
设关系R(A,B,C)和关系S(B,C,D),那么与R⋈S等价的关系代数表达式是
A. σ2=4（R⋈S）
B. σ2=4（R×S）
C. σ2=1（R⋈S）
D. σ2=1（R×S）
Sql语句：select * from students where SNO like‘010[^0]%[A,B,C]%’,可能会查询出的SNO是（）。
A. 01053090A
B. Hm3?
C. 01003090A01
D. 01053090D09
E. 0100A01
关于Truncate table, 以下（）描述是错误的。
A. Truncate table可跟Where从句，根据条件进行删除。
B. Truncate table可以删除表中所有数据。
C. 触发器对Truncate table依然有效。
D. delete比Truncate table速度快。
现有订单表orders，包含用户信息userid, 产品信息 productid, 以下（）语句能够返回至少被订购过两回的productid?
A. select productid from orders where count(productid)>1
B. select productid from orders wheremax(productid)>1
C. select productid from orders where having count(productid)>1group by product id_
D. select productid from orders group by productid having count(productid)>1
微信支付 
支付宝支付