20.SQL语言具有()功能。 A. 关系规范化、数据操纵、数据控制 B. 数据定义、数据操纵、数据控制 C. 数据定义、关系规范化、数据控制 D. 数据定义、关系规范化、数据操纵 正确答案:B满分:4分 21.E-R图中的联系可以与()实体有关 A. 0个 B. 1个 C. 1个或多个 D. 多个 正确答案:C满分:4分 22.How many rows can be retrieved using a single SELECT INTO statement? A. Only one row B. As many as are in the result C. As many as are host variables used in the call D. As many as host variable array structures can hold 正确答案:A满分:4分 23.Given the table T1 with the following data: C1 C2 -- -- 1 1 2 2 An application issues the following SQL statements with AUTOCOMMIT disabled: UPDATE t1 SET c1 = 10 WHERE c2 = 1 UPDATE t1 SET c1 = 20 WHERE c2 = 2 SAVEPOINT sp1 UPDATE t1 SET c1 = 30 WHERE c2 = 1 UPDATE t1 SET c1 = 40, c2 = 3 WHERE c2 = 2 SAVEPOINT sp1 UPDATE t1 SET c1 = 50 WHERE c2 = 1 UPDATE t1 SET c1 = 60 WHERE c2 = 2 ROLLBACK TO SAVEPOINT sp1 UPDATE t1 SET c1 = 50 WHERE c2 = 3 COMMIT What is the result of the following query? SELECT c1, c2 FROM t1 ORDER BY c2 A. 10 1 20 2 B. 30 1 50 3 C. 30 1 40 3 D. 10 1 50 3 正确答案:B满分:4分 (责任编辑:admin)要这答案加QQ:800020900 或加微信:q800020900 获取 |