000-704 Demo and Sample
Note: Answers are below each question.
Samples are taken from full version.
What option on the CREATE TABLESPACE statement determines on which database partition(s) the table space will be created?
ON NODES <nodelist>
IN DATABASE NODE GROUP <node group name>
IN PARTITION GROUP <partition group name>
INDATABASE PARTITION GROUP <db partition group name>
A DB2 instance has been configured to have three partitions(0, 1, and 2) with hostnames SERVER1, SERVER2, and SERVER3 respectively.
Which of the following commands is required to create a database named XYZ in the instance?
On all of the 3 servers issue "CREATEDATABASE xyz"
On one of the 3 servers issue "CREATEDATABASE xyz"
On one of the 3 servers issue "CREATEDATABASE xyz AT DBPARTITIONNUMS(0,1,2)"
On one of the 3 servers issue "CREATDATABASE xyz ON server1,server2,server3"
A requirement for table spaces in DB2 is that:
a table space with multiple page sizes is assigned to one buffer pool.
a table space has the same page size as the buffer pool to which it is assigned.
a table space has a large size than the buffer pool to which it is assigned.
a table space has a smaller page size than the buffer pool to which it is assigned.
Given the following DDL statement: CREATE TABLE "DEW" "TABLE45" ( "11" INTEGER ,
"D11" DECIMAL (1,0) NOT NULL ,
"12" DECIMAL(1,0) NOT NULL , "S7" SMALLINT ,
"C8" CHAR (1) WITH DEFAULT ' ' ) ORGANIZE BY (
"D11" "D12" )
How many indexes will be created?
Which of the following actions must be performed in order to use online backups?
Enable LOGRETAIN followed by BACKUP database
Enable LOGRETAIN followed by QUIESCE database
Disable LOGRETAIN followed by BACKUP database
Disable LOGRETAIN followed by QUIESCE database
Given the following scenario: CREATE TABLE t1
(t1c1 INT NOT NULL, t1c2 CHAR(5), t1c3 LONG VARCHAR, t1c4 INT) PARTITIONING KEY (t1c2)
CREATE TABLE t2 (t2c1 CHAR(7) , t2c2 CHAR(5) , t2c3 INT NOT NULL, t2c4 INT)
And the query:
SELECT t1c1, t2c2, SUM(t2c3) FROM t1, t2
WHERE t1c3 LIKE 'ABCD% '
AND t2c1 = t1c2
And t2c4 = 10 GROUP BY t1c1, t2c2
The cardinality of table T2 is 1,000,000 and the cardinality of T2C4 is 10. To provide the fastest response time for the query, which of the following columns is the best partitioning key
for table T2?
Given the content of the services file:
DB2_db2inst1 50500/tcp DB2_db2inst 2 50510/tcp
DB2_db2inst 3 50511/tcp
DB2_db2inst 4 50512/tcp
DB2_db2inst 5 50513/tcp
DB2_db2inst 6 50514/tcp
DB2_db2inst 1_END 50505/tcp
What must be changed to start eight database partitions on this server?
DB2_db2inst1_END 50505/tcp to DB2_db2inst1_END 50507/tcp
Change DB2_db2inst1_END 50505/tcp to
Read more Details »