IBM c2090-616 practice test

DB2 11.1 Fundamentals for LUW Exam


Question 1

What is the maximum precision for the DECIMAL data type?

  • A. 7
  • B. 15
  • C. 23
  • D. 31
Answer:

D

Explanation:
A decimal number is a packed decimal number with an implicit decimal point. The position of the
decimal point is determined by the precision and the scale of the number. The scale, which is the
number of digits in the fractional part of the number, cannot be negative or greater than the
precision. The maximum precision is 31 digits.

Discussions

Question 2

Which isolation level will allow application A to immediately read the committed value of a row that
is exclusively locked by application B?

  • A. Read Stability
  • B. Cursor Stability
  • C. Repeatable Read
  • D. Cursor Stability with WAIT FOR OUTCOME clause
Answer:

A

Explanation:
Read stability (RS) locks only those rows that an application retrieves within a unit of work. It ensures
that any qualifying row read during a unit of work is not changed by other application processes until
the unit of work completes, and that any row changed by another application process is not read
until the change is committed by that process

Discussions

Question 3

Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA,
you still want to maintain control over all maintenance and patching operations. Which of the
following Cloud offerings best suits your needs?

  • A. Cloudant
  • B. DB2 on Cloud
  • C. dashDB for analytics
  • D. dashDB for transactions
Answer:

B

Discussions

Question 4

Shadow tables are a special kind of Materialized Query Table, but what makes them different?
(Choose two.)

  • A. Shadow tables cannot be queried directly
  • B. Shadow tables do not store their data on disk
  • C. Shadow tables must be organized by column
  • D. Shadow tables must be maintained by replication
  • E. You cannot join shadow tables to other kinds of tables
Answer:

C,D

Discussions

Question 5

If you are already connected to a database, what does running the following statement do?
Db2 CONNECT

  • A. Prompts you for the database name or alias
  • B. Returns information about the current server
  • C. Prompts you for the authentication information
  • D. Returns an error, because you provided no database or alias
Answer:

B

Discussions

Question 6

The DDL statement is used to create table T1:
CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL,
c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?

  • A. INSERT INTO t1 VALUES (100)
  • B. INSERT INTO t1 (c1, c2) VALUES (100)
  • C. INSERT INTO t1 (c1, c3) VALUES (‘100’, ‘100.00’)
  • D. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)
Answer:

D

Discussions

Question 7

The creator of an index or an index specification automatically receives which privilege on the index?

  • A. SELECT
  • B. DELETE
  • C. UPDATE
  • D. CONTROL
Answer:

D

Discussions

Question 8

Below are the SQL statements a DBA is planning to execute on a database:
CREATE TABLE t1 (name VARCHAR (1));
INSERT INTO t1 VALUES (A), (B), (C), (D);
ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;
What will be the outcome of the last statement?

  • A. The statement will fail due to variable length character error
  • B. The statement will fail due to an incompatible data type error
  • C. The statement will execute successfully and it deletes the character data
  • D. The statement will execute successfully and it internally converts the character data into ASCII numbers
Answer:

B

Discussions

Question 9

Application 1 executes the following statements:
INSERT INTO TAB1 (NAME,AMOUNT) VALUES (John,100);
COMMIT;
UPDATE TAB1 SET AMOUNT=90 WHERE NAME=John;
After a few seconds, application 2 executes the following query:
SELECT AMOUNT FROM TAB1 WHERE NAME=John
Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of
the following is TRUE?

  • A. Application 2 will read the amount of 90
  • B. Application 2 will read the amount of 100
  • C. Application 2 will receive a warning message
  • D. Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires
Answer:

B

Discussions

Question 10

With HADR, which of the following configuration and topology choices provides the highest level of
protection from potential loss of data in a pureScale environment?

  • A. Principal standby with SYNC synchronization mode
  • B. Auxiliary standby with SYNC synchronization mode
  • C. Principal standby with NEARSYNC synchronization mode
  • D. Auxiliary standby with SUPERSYNC synchronization mode
Answer:

A

Explanation:
Standby databases are synchronized with the primary database through log data that is generated on
the primary and shipped to the standbys. The standbys constantly roll forward through the logs. You
can choose from four different synchronization modes. In order of most to least protection, these are
SYNC, NEARSYNC, ASYNC, and SUPERASYNC.

Discussions
To page 2