[2026] IBM DB2 9 Family Fundamentals - 000-730 무료 시험 문제

문제1

Which of the following DB2 data types CANNOT be used to create an identity column?

A. INTEGER

B. SMALLINT

C. DOUBLE

D. NUMERIC

정답: C

문제2

60 Which of the following best describes how locks are used in DB2?

A. To prevent multiple applications from accessing the same data simultaneously

B. To ensure only committed changes are altered by another application

C. To maintain control of updated rows for commit processing

D. To allow two applications to update the same row of data simultaneously

정답: B

문제3

Given the following information:
Protocol: TCP/IP Port Number: 5000 Host Name: DB_SERVER Database Name: TEST_DB Database Server Platform: Linux
Which of the following will allow a client to access the database stored on the server?

A. CATALOG TCPIP NODE 5000 REMOTE SERVERdb_server OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

B. CATALOG DATABASEtest_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000
OSTYPE LINUX;

C. CATALOG TCPIP NODEdb_server REMOTE db_server PORT 5000 OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

D. CATALOG TCPIP NODEdb_server REMOTE db_server SERVER 5000 OSTYPE LINUX;
CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

정답: D

문제4

Given that tables T1 and T2 contain the following rows:
Table T1: C1 C2
5 4 5 2 5 5 Table T2: C1 C2
5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2 ?

A. SELECT * FROM T1 EXCEPT SELECT * FROM T2

B. SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

C. SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1

D. SELECT * FROM T1 MINUS SELECT * FROM T2

정답: A

문제5

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

A. GRANT CONTROL ON INDEXempid_x TO user1

B. GRANT INDEX ON TABLE employee TO user1

C. GRANT DROP ON INDEXempid_x TO user1

D. GRANT DELETE ON INDEXempid_x TO user1

정답: A

문제6

A trigger can be created on which of the following objects?

A. Catalog Table

B. Stored Procedure

C. View

D. Global Temporary Table

정답: C

문제7

Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?

A. Informational constraint

B. Check constraint

C. Unique constraint

D. Default constraint

정답: C

문제8

Consider the following table called EMPLOYEES:
ID FIRSTNAME LASTNAME JOB LEVEL
1 Paul Jones DBA 2 2 George Baker MGR 1 3 Roger Melvin CLERK 3 4 Jim Smith MGR 1 5 Kevin Street CLERK 3 6 Chris Eaton MGR 1
If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1

A. 0

B. 6

C. 3

D. 1

정답: B

문제9

Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?

A. Application B will be placed in a lock-wait state until applicationA releases its lock.

B. Application B will read the previous version of the row.

C. Application B will read the row and see uncommitted changes made by application A.

D. Applications A and B will cause a deadlock situation.

정답: A

문제10

Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?

A. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

B. Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

C. Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

D. Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

정답: A

IBM DB2 9 Family Fundamentals - 000-730무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트