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

문제1

Which of the following is NOT true about schemas?

A. A schema enables the creation of multiple objects in a database without encountering namespace collisions

B. When most database objects are created, they are either implicitly or explicitly assigned to a schema

C. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default

D. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts

정답: D

문제2

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?

A. REVOKE EXECUTE ON EMPLOYEE FROM USER tom

B. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

C. REVOKE ALL PRIVILEGES FROM USER tom

D. REVOKE ALL ON EMPLOYEE FROM USER tom

정답: D

문제3

Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?

A. The cursor is only protected from updates and deletes by concurrent applications.

B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.

C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

정답: A

문제4

The following SQL statement:
DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR Is used to perform which type of delete operation?

A. Embedded

B. Searched

C. Positioned

D. Dynamic

정답: C

문제5

Which of the following is NOT true about schemas?

A. A schema enables the creation of multiple objects in a database without encountering namespace collisions

B. When most database objects are created, they are either implicitly or explicitly assigned to a schema

C. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default

D. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts

정답: D

문제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 read the row.

B. Application B will wait until applicationA releases the Update lock.

C. Application A will be terminated so that application B can read the row.

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

정답: A

문제7

If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

A. View V1 does not have to reside in the same schema as the EMPLOYEE table

B. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information

C. View V1 can be used as a data source for other views

D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

정답: D

문제8

Given the following two tables:
TAB1 C1 C2
1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY
5 Europe 6 North America 7 South America
Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?

A. INSERT INTO tab1 (c1, c2) VALUES (SELECTcx, cy FROM tab2)

B. INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

C. INSERT INTO tab1 VALUES (SELECTcx, cy FROM tab2)

D. INSERT INTO tab1 SELECTcx, cy FROM tab2

정답: D

문제9

If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING '1/1/2007' ENDING '12/31/2007'
EVERY 3 MONTHS)
Which of the following statements is true?

A. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level

B. If an index is created for the SALES table, its data must be stored in table space TBSP0

C. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

D. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned

정답: C

문제10

Given the following table definitions:
DEPARTMENT
DEPTNO CHAR(3) DEPTNAME CHAR(30) MGRNO INTEGER ADMRDEPT CHAR(3)
EMPLOYEE
EMPNO INTEGER FIRSTNAME CHAR(30) MIDINIT CHAR LASTNAME CHAR(30) WORKDEPT CHAR(3)
Which of the following statements will list every employee number and last name, along with the employee number and last name of their manager, including employees that have not been assigned to a manager?

A. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

B. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

C. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

D. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

정답: A

문제11

Which two of the following allow you to perform administrative tasks against database objects?

A. Control Center

B. Journal

C. Task Center

D. Health Center

E. Command Line Processor

정답: A,E

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

우리와 연락하기

유용한 링크

최신 업데이트