IBM DB2 9 Family Fundamentals Set 6

Question - 15 Maximum mark : - 28

Home
All Exams
IBM DB2 9 Family Fundamentals Online Mock Tests
IBM DB2 9 Family Fundamentals Set 6

Which of the following CREATE TABLE statements will NOT be successful?

CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

✘

CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20))

✘

CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)

✘

CREATE TABLE t1 (c1 XML, c2 XML)

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

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 ✘ 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 ✘ If an index is created for the SALES table, its data must be stored in table space TBSP0 ✘ When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to producethe result data set returned ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following is NOT a characteristic of a declared temporary table?

Declared temporary tables are not persistent and can only be used by the application that creates them ✘ It is possible for many applications to create declared temporary tables that have the same name ✘ Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified ✘ Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed DataConcurrency ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following isolation levels will lock all rows scanned to build a result data set?

Uncommitted Read ✘ Cursor Stability ✘ Read Stability ✘ Repeatable Read ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read Stability isolation level, which of the following will occur?

Applications A and B will cause a deadlock situation ✘ Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it ✘ Application B will read the data in table TAB1 and see uncommitted changes made by Application A ✘ Application B will be placed in a lock-wait state until Application A releases its lock ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?

Uncommitted changes made by other transactions can be seen from one scan to the next. ✘ Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans. ✘ Rows added by other transactions that did not appear in one scan can be seen in subsequent scans. ✘ Rows that have been updated can be changed by other transactions from one scan to the next. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to 30 and both applications were started at the same time, what action will the deadlock detector take when it "wakes up" and discovers the deadlock?

It will randomly pick an application and rollback its current transaction ✘ It will rollback the current transactions of both applications ✘ It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock has not been resolved ✘ It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an application and rollback its current transaction ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Application A is running under the Repeatable Read isolation level and holds an Update lock on table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock. Which isolation level should Application B run under to achieve this objective?

Repeatable Read ✘ Read Stability ✘ Cursor Stability ✘ Uncommitted Read ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following DB2 UDB isolation levels will only lock rows during read processing if another transaction tries to drop the table the rows are being read from?

Repeatable Read ✘ Read Stability ✘ Cursor Stability ✘ Uncommitted Read ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, what will happen when Application B attempts to acquire a compatible lock on the same row?

Application B will acquire the lock it needs ✘ Application A will be rolled back if it still holds its lock after 20 seconds have elapsed ✘ Application B will be rolled back if Application A still holds its lock after 20 seconds have elapsed ✘ Both applications will be rolled back if Application A still holds its lock after 20 seconds have elapsed ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM DB2 9 Family Fundamentals Set 6

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner