吉大奥鹏15秋学期《数据库应用技术》在线作业二答案.docVIP

吉大奥鹏15秋学期《数据库应用技术》 在线作业二答案 一、单选题（共 25 道试题，共 100 分。） 1. Given the code: EXEC SQL WITH most_cities AS ( SELECT b.id, b.name, a.cities FROM country a, staff b WHERE a.person = b.id AND cities hreshold ) SELECT id, name, cities FROM most_cities INTO :id, :name, :cities WHERE cities IN (SELECT MAX(cities) FROM most_cities) Which of the following can reference MOST_CITIES? A. The current statement B. Statements from any application C. All statements within this application D. All statements within the current unit of work 正确答案：A 2. 如果一个用户USER1被授予了表TAB上的CONTROL特权，如果需要限制该用户对表的存取，应使用以下哪条命令？ A. REVOKE ALL ON TAB TO USER1 B. REVOKE ALL ON TAB FROM USER1 C. REVOKE CONTROL ON TAB TO USER1 D. REVOKE CONTROL ON TAB FROM USER1 正确答案：B 3. 事务的原子性是指（） A. 事务中包含的所有操作要么都做，要么都不做 B. 事务一旦提交，对数据库的改变是永久性的 C. 一个事务内部的操作及使用的数据对并发的其他事务是隔离的 D. 事务必须是使数据库从一个一致性状态变到另一个一致性状态 正确答案：A 4. Given the tables, the relationships and the statements: EMPLOYEE DEPT emp_num emp_name dept dept_id dept_name 1 Adams 1 1 Planning 2 Jones 1 2 Support 3 Smith 2 4 Williams 1 Relationship: employee.dept is a foreign key on dept.dept_id. stmt=INSERT INTO employee VALUES (5,jones,3); EXEC SQL EXECUTE IMMEDIATE :stmt; stmt=INSERT INTO employee VALUES (6,jhonson,2); EXEC SQL EXECUTE IMMEDIATE :stmt; How many rows are successfully inserted? A. One row is inserted in EMPLOYEE B. No rows are inserted in EMPLOYEE C. Two rows are inserted in EMPLOYEE D. One row is inserted in DEPT and 2 rows are inserted in EMPLOYEE 正确答案：A 5. 下述关于数据库系统的正确叙述是（） A. 数据库中只存在数据项之间的联系 B. 数据库的数据项之间和记录之间都存在联系 C. 数据库的数据项之间无联系，记录之间存在联系 D. 数据库的数据项之间和记录之间都不存在联系 正确答案：B 6. Given the expression: WITH most_cities AS ( SELECT b.id,b.name,a.cities FROM country a, staff b WHERE a.person = b.id AND cities hreshold ) SELECT * FROM most_cities In which of the following does MOST_CITIES exist? A. user tables B. server memory C. user table space D. system catalog tables 正确答案：B 7. Given an ODBC/CLI program with a single connection, two threads and the following ac