Test09(选择题).docVIP

Test Bank—Chapter Nine (Database Systems) Multiple Choice Questions 1. Which of the following accesses a database in terms of a database model? A. Application software B. Database management system C. Actual database ANSWER: A 2. Which of the following describes only the portion of a database available to a particular user? A. Database model B. Schema C. Subschema D. DBMS ANSWER: C 3. Which of the following relational operations combine data from more than one relation? A. SELECT B. PROJECT C. JOIN ANSWER: C 4. Which of the following relational operations extracts entire columns from a relation? A. SELECT B. PROJECT C. JOIN ANSWER: B 5. Which of the following relational operations extracts entire rows from a relation? A. SELECT B. PROJECT C. JOIN ANSWER: A 6. Which of the following relational operations is performed by the SQL statement below? select A, B, C from X A. SELECT B. PROJECT C. JOIN ANSWER: B 7. Given the relation X below X: A B C 2 5 7 3 3 3 4 3 2 5 2 8 what value will be extracted by the following query? TEMP ( SELECT from X where B C RESULT ( PROJECT A from TEMP A. 2 B. 3 C. 4 D. 5 ANSWER: C 8. Given the relation X below X: A B C 2 5 7 3 3 3 4 4 2 5 2 8 what value will be retrieved by the following query? TEMP ( SELECT from X where B = C RESULT ( PROJECT B from TEMP A. 2 B. 3 C. 4 D. 5 ANSWER: B 9. Given the relation below X: A B C 2 5 7 3 3 6 4 4 2 5 2 2 what values will be retrieved by the following SQL statement? select A, B from X where X.B = X.C A. 2, 5 B. 3, 6 C. 2, 2 D. 5, 2 ANSWER: D 10. Given the two relations X and Y below X: A B Y: C D 7 s t 3 2 z r 2 what value would be retrieved by executing the following SQL statement? select Y.C from X, Y where X.A Y.D A. s B. z C. t D. r ANSWER: C 11. Which of the following is not a potential problem caused by multiple transactions manipulating a database at t