Pass4itsure > IBM > IBM Certified System Administrator > A2090-610 > A2090-610 Online Practice Questions and Answers

A2090-610 Online Practice Questions and Answers

Questions 4

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

A. 4

B. 8

C. 16

D. 32

Buy Now
Questions 5

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

A. CLI

B. XML

C. JDBC

D. RUBY

Buy Now
Questions 6

When is an INTENT EXCLUSIVE (IX) lock required?

A. When a transaction intends to read or change data.

B. When a transaction intends to change but not read data.

C. When a transaction intends to read but not change data.

D. When a transaction intends to change the system catalog.

Buy Now
Questions 7

A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

A. DBCTRL authority

B. SQLADM authority

C. DATAACCESS authority

D. ACCESSCTRL authority

Buy Now
Questions 8

When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

A. The data in the table is deleted and the table persists.

B. The data in the table is deleted and the table is implicitly dropped.

C. The temporary table is converted to a base table and the data is deleted.

D. The temporary table is converted to a base table and the data is persistent.

Buy Now
Questions 9

By default, a column defined as a TIMESTAMP includes which attributes?

A. No fractional digits or time zone.

B. 6 fractional digits and no time zone.

C. 12 fractional digits plus a time zone.

D. 12 fractional digits and no time zone.

Buy Now
Questions 10

A table named EMPLOYEES was created as follows:

What will be the results?

A. 0

B. 1

C. 2

D. 3

Buy Now
Questions 11

If a table named MY_TAB contains 100 rows and the following statement is executed:

How many rows will be updated?

A. 0

B. 1

C. 10

D. 99

Buy Now
Questions 12

Which statement about system-period temporal tables is true?

A. They store user-based period information.

B. They do not have a separate history table.

C. They can be queried without a time period specification.

D. They manage data based on time criteria specified by users or applications.

Buy Now
Questions 13

Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

A. Read Stability (RS)

B. Cursor Stability (CS)

C. Repeatable Read (RR)

D. Uncommitted Read (UR)

Buy Now
Exam Code: A2090-610
Exam Name: Assessment: DB2 10.1 Fundamentals - Assessment
Last Update: Mar 25, 2024
Questions: 138
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$45.99

VCE

$49.99

PDF + VCE

$59.99