1、吉大17春學期數據庫應用技術在線作業一一、單選題(共25道試題，共100分。)1. Given the tables: EMPLOYEDEPTemp_numemp_namedept dept_id dept_name 1 Adams 1 1 Planning 2 Jones 1 2 Support 3 Smith 2 4 Williams 1 and the statement: ALTERTABLE employee ADDFOREIGNKEY(dept) REFERENCESept (dept_id) ONDELETECASCADEiowmany rows will be deleted

2、when the following statement is executed? DELETEFROMemployee WHERE dept=1A. 0B. 1C. 3D. 4正確答案：C2. Given the following code: BEGIN ATOMIC UPDATE country SET cities=:count WHERE CURRENT OF C1; INSERT INTO country VALUES(:co11,:co12,:co13); INSERT INTO country VALUES(:co14,:co15,:co16); INSERT INTO cou

3、ntry VALUES(:co17,:co18,:co19); INSERT INTO country VALUES(:co110,:co111,:co112); COMMIT; END Given that all statements succeed except the following: INSERT INTO country VALUES(:co17,:co18,:co19); How many rows will be affected in table COUNTRY?A. 0B. 3C. 4D. 5正確答案：A3. How many rows can be retrieved

4、 using a single SELECT INTO statement?A. Only one rowB. As many as are in the resultC. As many as are host variables used in the callD. As many as host variable array structures can hold 正確答案：A4 .實體是信息世界中的術語，與之對應的數據庫術語為：()A.文件B.數據庫C.字段D.記錄正確答案：D5 .如果開發人員在AIX操作系統上開發訪問后臺AS400上的DB2數據庫，則需要在 AIX開發環境中安裝：(

5、)A. DB2個人開發版(PDEB. DB2通用開發版(UDE正確答案：B6 .關系模型中的關系模式至少是()A. 1NFB. 2NFC. 3NFD. BCNF正確答案：A7 .若用如下的 SQM句創建一個 student 表：CREATETABLEstudent(NO CHAR4) NOT NULL NAMECHAR(8) NOT NULL SEX CHAR(2), AGE NUMBERIC2)可以插入到 student 表中 的是哪一項？A. ('1031 ','曾華'，男，23)B. ('1031 ','曾華'，NULL N

6、ULLC. (NULL 曾華，男，23')D. ('1031 ' , NULL '男'，23)正確答案：B8. 執行下面兩條 SQL語句后： CREATETABLE t1 ( c1 char(10) NOTNULL PRIMARYCEY, c2 int, c3 char(10), c4 char(10) NOT NULL, CONSTRAINT c4 UNIQUE (c1,c4) ) /自動創建索引 CREATE INDEX Index1 ON t1 (c2 ASC) 表 t1 上有幾個索引？A. 0B. 1C. 2D. 3E. 4正確答案：D9. Gi

7、ven the code: EXECSQLWITHmost_citiesAS ( SELECTb.id, , a.cities FROMcountry a, staff b WHERE a.person = b.id AND cities > :threshold ) SELECT id, name, cities FROMmost_cities INTO :id, :name, :cities WHEREities IN (SELECT MAX(cities) FROM most_cities) Which of the following can reference MO

8、ST_CITIES?A. The current statementB. Statements from any applicationC. All statements within this applicationD. All statements within the current unit of work正確答案：A10. An application uses static SQL to connect to a remote DB2 server and insertsdata into the CUST.ORDERS table on that remote DB2 serve

9、r. To enable access to theremote DB2 server, FOO needs to create a package with default options so that BARis the only non-administrative user that can use this package on the remote DB2server. Which statement describes the privileges that FOO requires to accomplish this?A. FOO requires EXECUTE priv

10、ilege on the package.B. FOO requires the privilege to create the package on the remote DB2 server.C. FOOrequires EXECUTEprivilegeon the package and INSERTprivilege on CUST.ORDERS.D. FOOrequires the privilege to create the package on the remote DB2server and INSERT privilege on CUST.ORDERS.正確答案：D11.

11、Given the table T1 with the following data: COL1IDX - - A single-threaded CLI application executes the following pseudocode in sequence: SQLAllocHandle( SQL_HANDLE_ENV,ULL, &hEnv ) SQLAllocHandle( SQL_HANDLE_DB(hEnv, &hDbc ) SQLConnect( hDbc, "SAMPLE", SQL_NTS, NULL, SQL_NTS, NULL,

12、 SQL_NTS ) SQLSetConnectAttr( hDbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_ON ) SQLAllocHandle( SQL_HANDLE_STMhTD, bc, &hStmt ) SQLExecDirect( hStmt, "UPDATEtable1 SET col1=10 WHERidx=1", SQL_NT§ SQLExecDirect( hStmt, "UPDATEtable1 SET col1=20 WHERE idx=2", SQL_NTS ) SQLEnd

13、Tran( SQL_HANDLE_DBC, hDbc, SQL_COMMIT ) SQLExecDirect(hStmt,"UPDATE table1SET col1=30WHERE idx=1",SQL_NTS )SQLExecDirect(hStmt,"UPDATE table1SET col1=40WHERE idx=1",SQL_NTS )SQLEndTran( SQL_HANDLE_DBCh,Dbc, SQL_ROLLBAC)K SQLExecDirect( hStmt, "SELECT col1 FROM table1 WHERE

14、idx=1", SQL_NTS ) Which of the following values for COL1 will be fetched when the sequence for the pseudocode listed above is successfully executed? A. 10B. 20C. 30D. 40 正確答案：D 12.下面哪個工具可以保存終端用戶需要存取的元數據？ A. Query Management FacilityB. DB2 Query PatrollerC. DB2存儲過程構建器 D.信息目錄 正確答案：D13. 設有兩個事務 T1,

15、 T2,其并發操作如下所示：T1 : T2: 1)讀A=10, B=5 2)讀A=10 3) 讀A=20, B=5求和25驗證錯正確的評價是哪個？A.該操作不存在問題B.該操作丟失修改C.該操作不能重復讀D.該操作讀“臟”數據 正確答案：C14. 關系規范化中的刪除操作異常是指()A.不該刪除的數據被刪除 B.不該插入的數據被插入 C.應該刪除的數據未被刪除 D.應該插入的數據未被插入 正確答案：A15. Given the table COUNTRwith the following data: ID NAME PERSON CITIES1 Argentina 1 - and the cod

16、e: EXEC SQL DECLARE c1 CURSOR FOR SELECT id,name FROM country; EXEC SQL OPEN c1; EXEC SQL FETCH c1 INTO :id,:name; EXEC SQL FETCHc1 INTO :id,:name;Which of the following SQLCODE/SQLSTATEsll be containedin the SQLCA after the last fetch?A. SQLCODE 0, SQLSTATE 00000B. SQLCODE 100, SQLSTATE 02000C. SQL

17、CODE -100, SQLSTATE 00100D. SQLCODE -501, SQLSTATE 24501 正確答案：B16. Given the following code: EXEC SQL EXECUTE IMMEDIATE :sqlstmt Which of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?A. DROP TABLE staffB. DELETE FROM staffC. DROP * FROM staffD. DELETE *

18、 FROM staff正確答案：B17. The following commandsare issued against a data source: CREATETABLE(i INT) CREATE ALIAS FOR CREATE TABLE org.sample ( c CHAR(1) CREATEALIAS FOR CREATEALIAS userid.sample FOR When issued by USER1, which of the followin

19、g statements will havea different result setthan this SELECT statement? SELECT * FROM orgA. SELECT * FROM org.sampleB. SELECT * FROM C. SELECT * FROM D. SELECT * FROM userid.sample 正確答案：A18. Which of the following is used to run an embedded dynamic SQLUPDATEstatement?A. UPDATEB.

20、. PREPAREC. . DECLARED. . EXECUTE正確答案：D19. Which of the following is TRUE for all cursors defined as FOR FETCH ONLY?A. The cursors are unambiguous.B. Only the first row is returned.C. Cursor stays open after a commit.D. A temporary table is created on the server.正確答案：A20 .在數據庫中存儲的是：()A.數據B.數據模型C.數據以及數據之間的聯系D.信息正確答案：C21 . 在語句 CREATE VIEW EMP_VIEW2 (EMPNO,