IBM A2090-730 問題集

質問 1：
Which of the following describes the objects of a DB2 database and their relationships?
A. System catalog
B. Schema repository
C. Instance
D. Table space
正解：A

質問 2：
Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?
A. An alias named T1 that references a view named V1 that references table TABLE1
B. An alias named T1 that references table TABLE1
C. A schema named T1 that references table TABLE1
D. A view named T1 that references table TABLE1
正解：C

質問 3：
A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?
A. GRANT UPDATE ON TABLE department TO user1
B. GRANT UPDATE (dept_name) ON TABLE department TO user1
C. GRANT ALTER (dept_name) ON TABLE department TO user1
D. GRANT ALTER ON TABLE department TO user1
正解：B

質問 4：
Which of the following CREATE TABLE statements will NOT be successful?
A. CREATE TABLE t1 (c1 XML, c2 XML)
B. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
C. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)
D. CREATE TABLE t1 (c1 XML NOT NULL, c2CHAR(20))
正解：C

質問 5：
In which of the following situations should correlation names be used?
A. A table referenced in the FROM clause has no indexed column.
B. The FROM clause contains two or more tables in the SELECT statement.
C. Two or more tables in the FROM clause have identical column names.
D. The table referenced in the FROM clause has more than 200 columns.
正解：C

質問 6：
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?
A. Application B will wait until applicationA releases the Update lock.
B. Application A will be terminated so that application B can read the row.
C. Application B will read the row.
D. Applications A and B will cause a deadlock situation.
正解：C

質問 7：
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?
A. GRANT ADD DATA ON TABLE tab1 TO GROUP tomappgrp
B. GRANT INSERT TO USER tom, GROUPappgrp ON TABLE tab1
C. GRANT INSERT ON TABLE tab1 TO USER tom, GROUPappgrp
D. GRANT ADD DATA ON TABLE tab1 TO USERappgrp, GROUP tom
正解：C

質問 8：
Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
A. TABLE2 will have the same column defaults as TABLE1
B. TABLE2 will have the same referential constraints as TABLE1
C. TABLE2 will have the same indexes as TABLE1.
D. TABLE2 will have the samenullability characteristics as TABLE1
E. TABLE2 will have the same column names and column data types as TABLE1
正解：B,C