db2 udb v8.1 advanced db admin for linux,unix+windwos
Index >> IBM >> DB2 >> "000-704"Exam
VUE/Prometric Code：000-704
Exam Name：db2 udb v8.1 advanced db admin for linux,unix+windwos
Questions and Answers：112 Q&As
Price：$79
Updated：2008-09-01
Questions and Answers：112 Q&As
Price：$79
Updated：2008-09-01
| db2 udb v8.1 advanced db admin for linux,unix+windwos | |||
| Test | Q&A | Updated | Price |
| 000-704 | 112 Q&A | 2008-09-01 | $79 |
please download in PDF format Demo:
killtest 000-704 Exam Features
High quality and Value for the 000-704 Exam.
Killtest Practice Exams for db2 udb v8.1 advanced db admin for linux,unix+windwos 000-704 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.
We guarantee your success in the first attempt. If you do not pass the 000-704 (db2 udb v8.1 advanced db admin for linux,unix+windwos) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
killtest 000-704 Downloadable.
Printable Exams (in PDF format) Our Exam 000-704 Preparation Material provides you everything you will need to take your DB2 exam. The DB2 Certification details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get DB2 exam questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first DB2 exam try, but also save your valuable time .
- Comprehensive questions with complete details about 000-704 exam.
- 000-704 exam questions accompanied by exhibits.
- Verified Answers Researched by Industry Experts and almost 100% correct.
- Drag and Drop questions as experienced in the Real DB2 exam.
- 000-704 exam questions updated on regular basis.
- Like actual DB2 Certification exams, 000-704 exam preparation is in multiple-choice questions (MCQs).
- Tested by many real DB2 exams before publishing.
- Try free DB2 exam demo before you decide to buy it in http://www.Killtest.com.
High quality and Value for the 000-704 Exam:100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.
http://www.Killtest.com The safer.easier way to get DB2 Certification.
We offer Demo version of Q&A, Q&A are as follows (not to provide picture):
000-704：please download 000-704 in PDF format Demo
1.Which of the following database configuration parameters must be set to allow automatic log file shipping within DB2?
A.USEREXIT
B.DB2UEXT2
C.LOGRETAIN
D.MIRRORLOGPATH
Correct:A
2.A remote connection is being established from a Windows system running DB2 Connect to a DB2 for z/OS subsystem called DBX1. The following Node and database directory entries have already been cataloged: Node 1 entry: Node name = DBX1NODE Comment = Protocol = TCPIP Hostname = dbx1.company.com Service name = 2500 Database 1 entry: Database alias = DBX1 Database name = TEST Node name = DBX1NODE Database release level = 9.00 Comment = Directory entry type = Remote Authentication = SERVER Catalog node number = -1 Which of the following commands will catalog the DCS directory entry?
A.CATALOG DCS DATABASE test AS dbx1
B.CATALOG DCS DATABASE dbx1 AS test
C.CATALOG DCS DATABASE dbx1 AT dbx1node
D.CATALOG DCS DATABASE test AT dbx1node
Correct:A
3.Which of the following settings for the DB2MAXFSCRSEARCH registry variable ensures a complete search for space in the database tables, possibly making inserts slower?
A.1
B.5
C.-1
D.33554
Correct:C
4.Defining a table as VOLATILE indicates which of the following to the DB2 optimizer?
A.The table is frequently dropped and recreated.
B.The number of rows in the table typically varies significantly.
C.The table is the target of SELECT statements from a large number of users.
D.The entire table should be kept in the buffer pool so that DB2 can access it using table scans.
Correct:B
5.Given the content of the services file: DB2_db2inst1 50500/tcp DB2_db2inst2 50510/tcp DB2_db2inst3 50511/tcp DB2_db2inst4 50512/tcp DB2_db2inst5 50513/tcp DB2_db2inst6 50514/tcp DB2_db2inst1_END 50505/tcp What must be changed to start eight database partitions on this server?
A.Add DB2_db2inst1_END 50507/tcp
B.Add DB2_db2inst7 50515/tcp DB2_db2inst8 50516/tcp
C.Change DB2_db2inst1_END 50505/tcp to DB2_db2inst1_END 50507/tcp
D.Change DB2_db2inst1_END 50505/tcp to DB2_db2inst8_END 50507/tcp
Correct:C
6.Which of the following actions must be performed in order to use online backups?
A.Enable LOGRETAIN followed by BACKUP database
B.Enable LOGRETAIN followed by QUIESCE database
C.Disable LOGRETAIN followed by BACKUP database
D.Disable LOGRETAIN followed by QUIESCE database
Correct:A
7.Increasing the value of NUM_POOLAGENTS can result in:
A.more agent pools being available for each application.
B.multiple agents being available if MAXAGENTS is set to 1.
C.more agents being available before the transaction starts.
D.more buffer pools being available for parallel query processing.
Correct:C
8.Given the following information: Database DB_1 on 4 partitions, 1, 2, 3, and 4 Database partition group DP1 on partitions 1, 2, and 3 Database configuration parameter BUFFPAGE = 1000 a nd the statement: CREATE BUFFERPOOL bp1 DATABASE PARTITION GROUP dp1 SIZE 4000 EXCEPT ON (DBPARTITIONNUMS 3 SIZE 3000) How many pages will be in BP1 on each partition?
A.1: 4000 2: 4000 3: 4000 4: 1000
B.1: 4000 2: 4000 3: 3000 4: 1000
C.1: 4000 2: 4000 3: 3000 4: BP1 is not created
D.1: 4000 2: 4000 3: 4000 4: BP1 is not created
Correct:C
9.TSP1 is a table space defined in database partition group DPG4 with 4 database partitions. Given the following table definition: CREATE TABLE tab_b AS SELECT * FROM tab_a) DATA INITIALLY DEFERRED REFRESH IMMEDIATE DISABLE QUERY OPTIMIZATION IN tsp1 REPLICATED ; Which of the following statements is correct?
A.The table TAB_B cannot be queried directly.
B.The data from table TAB_A is replicated into table TAB_B when the CREATE TABLE statement completes.
C.A full copy of the data from table TAB_A is replicated to each of the 4 database partitions in DPG4 after a refresh is completed.
D.The data from table TAB_A will be replicated into table TAB_B and partitioned across the 4 database partitions after a refresh is completed.
Correct:C
10.Given the following DDL statement: CREATE TABLE "DEW"."TABLE45" ( "I1" INTEGER , "D11" DECIMAL(1,0) NOT NULL , "D12" DECIMAL(1,0) NOT NULL , "S7" SMALLINT , "C8" CHAR(1) WITH DEFAULT ' ' ) organize by ( "D11" , "D12" ) How many indexes will be created?
A.0
B.1
C.2
D.3
Correct:D
11.What option on the SQL statement ALTER TABLESPACE guarantees there will be no rebalance when adding a container to an existing table space?
A.ADD AT END
B.NO REBALANCE
C.EXTEND STRIPE SET
D.BEGIN NEW STRIPE SET
Correct:D
12.In order to estimate the amount of space currently used by an existing table's data object per partition, which two of the following pieces of information are required?
A.fpages for the data object
B.number of rows in the table
C.number of indexes for the table
D.column definitions for the table
E.number of partitions in the database partition group for the table
Correct:A E
13.Which of the following database configuration parameters will avoid transaction rollback as a result of the database log path becoming full?
A.NUM_LOG_SPAN
B.MIRRORLOGPATH
C.OVERFLOWLOGPATH
D.BLK_LOG_DSK_FUL
Correct:D
14.Buffer pool BP1 is being used by a single table space TS1. The following statements are issued: ALTER TABLESPACE ts1 BUFFERPOOL bp2 DROP BUFFERPOOL bp1 What will happen as a result of these statements being issued?
A.The drop will be successful but the memory will not be released until the database has been stopped and started.
B.The drop will be successful and the memory will be released because it is no longer used by any of the table spaces.
C.The drop will fail stating that the user can attempt to drop the buffer pool again after the database has been stopped and started.
D.The drop will return a warning stating that the buffer pool is still in use and that it will be dropped automatically after the database has been stopped and started.
Correct:D
15.A 24 partition database spans four servers. Which command will run the mkdir command once per server?
A.rah "mkdir "
B.db2 "!mkdir "
C.db2_all "mkdir "
D.db2_all node +4 "mkdir "
Correct:A
16.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?
A.T2C1
B.T2C2
C.T2C3
D.T2C4
Correct:A
17.Which command needs to be run on the DB2 UDB Server in order to allow the clients to automatically find the server using Lightweight Directory Access Protocol (LDAP)?
A.ADD DB2 NODE IN LDAP AS PROTOCOL
B.CREATE DB2 SERVER IN LDAP AS PROTOCOL
C.REGISTER DB2 SERVER IN LDAP AS PROTOCOL
D.STORE DB2 SERVER INFORMATION IN LDAP AS PROTOCOL
Correct:C
18.Given a single physical server with a single OS image utilizing 24 CPUs and configured with 12 database partitions, how many of the database partitions can act as coordinator partitions for remote applications?
A.1
B.2
C.12
D.24
Correct:C
19.Given the following Event Monitor output: Statement Event ... Appl Handle: 0 Appl Id: *LOCAL.DB2.000523234208 Appl Seq number: 0001 Record is the result of a flush: FALSE ------------------------------------------- Type : Dynamic Operation: Close Section : 201 Creator : NULLID Package : SQLC29N3 Cursor : SQLCUR201 Text : select * from table1 order by deptno ------------------------------------------- ... Sorts: 1 T otal sort time: 927 Sort overflows: 1 Which of the following actions may resolve the problem shown in this event record?
A.Reorganize TABLE1
B.Increase the database heap size
C.Increase the sort heap threshold
D.Assign TABLE1 to its own buffer pool
Correct:C
20.When using the LIST INDOUBT TRANSACTIONS command to display transactions, which of the following actions CANNOT be performed on transactions listed?
A.They can be committed.
B.They can be forgotten.
C.They can be rolled back.
D.They can be acknowledged.
Correct:D
21.Given the following Explain Plan fragment: FETCH / \ RIDSCN T3 | IXAND / \ NLJOIN NLJOIN / \ / \ T1 T3 T2 T3 Which of the following is being performed?
A.Hash join
B.Star join
C.Index ORing
D.Index-only access
Correct:B
22.The INTRA_PARALLEL configuration parameter controls if DB2 can:
A.use multiple agents to handle a query.
B.use multiple buffer pools to handle a query.
C.perform parallel I/O to gather the result set for a query.
D.use multiple partitions to gather the result set for a query.
Correct:A
23.The split mirror technique was used to create a backup image of a database. A connection to the mirrored image of the database is possible after which of the following commands is issued?
A.db2inidb
B.db2start
C.restore database
D.activate database
Correct:A
24.Based on the following information: CREATE TABLE t1 ( t1c1 INT NOT NULL, t1c2 CHAR(5), t1c3 LONG VARCHAR, t1c4 INT) CREATE TABLE t2 ( t2c1 CHAR(7), t2c2 CHAR(5), t2c3 INT NOT NULL, t2c4 INT) and the query: SELECT t1c1, t2c1, SUM(t1c4) FROM t1, t2 WHERE t1c3 = 'ABCD' AND t2c1 = t1c2 AND t2c4 = 10 GROUP BY t1c1,t2c1; The cardinality of table T1 is 1,000,000 and the cardinality of the columns is as follows: T1C1 2 T1C2 500,000 T1C3 10 T1C4 1,000,000 Which of the following columns is the best partitioning key for table T1 to provide the fastest response time?
A.T1C1
B.T1C2
C.T1C3
D.T1C4
Correct:B
25.Which of the following SQL statements can increase the size of buffer pool IBMDEFAULTBP from 1000 pages to 5000 pages without requiring that the database be stopped and started?
A.ALTER BUFFERPOOL IBMDEFAULTBP SIZE 5000 NOW
B.ALTER BUFFERPOOL IBMDEFAULTBP NEW SIZE 5000
C.ALTER BUFFERPOOL IBMDEFAULTBP INCREASE BY 4000
D.ALTER BUFFERPOOL IBMDEFAULTBP IMMEDIATE SIZE 5000
Correct:D
26.Each Saturday, a full database backup of the PRODDB database is performed. Each weekday, incremental backups are performed. If a new table space is created on Wednesday, which of the following steps is required to ensure that the incremental backups will be successful?
A.Perform a full backup of the new table space.
B.Issue the command ARCHIVE LOG FOR DATABASE proddb.
C.Perform a cumulative backup of the new table space.
D.Set the TRACKMOD configuration parameter to NO, then reset it to YES.
Correct:A
27.When an active database fails over to the standby server, which of the following is required?
A.Crash recovery, roll forward recovery
B.Version recovery, roll forward recovery
C.Roll forward recovery, restart recovery
D.Point-in-time recovery, roll forward recovery
Correct:A
28.Given that a LOAD needs to spread the partitioning agents across the database partitions 1 and 2 out of database partitions 0 through 5, which of the following PARTITIONED DB CONFIG parameters is correct?
A.OUTPUT_DBPARTNUMS (1,2) MODE PARTITION_AND_LOAD
B.PARTITIONING_DBPARTNUMS (1,2) MODE PARTITION_AND_LOAD
C.PARTITIONING_DBPARTNUMBS (1,2) MODE PARTITION_AND_LOAD (0 TO 5)
D.PRE_PARTITIONING_DBPARTNUMS(0) MODE PARTITIONING_DBPARTNUMS (1,2)
Correct:B
29.Given the following DDL statement and data: CREATE TABLE "AJW"."TABLE46" ( "D10" SMALLINT NOT NULL , "D11" SMALLINT NOT NULL , "D12" SMALLINT NOT NULL , "S7" SMALLINT NOT NULL ) organize by ( ( "D12","D10" ) , "S7" ) D10 D11 D12 S7 --- ----- ------ ------ 4 -1 9 -22032 -6 -1 6 -22032 -5 -6 -6 -22032 4 2 9 -22032 -4 5 -6 -9232 -6 -9 9 11255 -3 -7 5 11255 4 6 5 11255 -3 2 5 11255 -3 6 5 11255 How many cells will contain data?
A.1
B.5
C.7
D.10
Correct:C
30.To check the integrity of a database image you would like to restore, which of the following DB2 commands can be used?
A.db2ckmig
B.db2ckimg
C.db2ckbkp
D.db2ckrst
Correct:C
A.USEREXIT
B.DB2UEXT2
C.LOGRETAIN
D.MIRRORLOGPATH
Correct:A
2.A remote connection is being established from a Windows system running DB2 Connect to a DB2 for z/OS subsystem called DBX1. The following Node and database directory entries have already been cataloged: Node 1 entry: Node name = DBX1NODE Comment = Protocol = TCPIP Hostname = dbx1.company.com Service name = 2500 Database 1 entry: Database alias = DBX1 Database name = TEST Node name = DBX1NODE Database release level = 9.00 Comment = Directory entry type = Remote Authentication = SERVER Catalog node number = -1 Which of the following commands will catalog the DCS directory entry?
A.CATALOG DCS DATABASE test AS dbx1
B.CATALOG DCS DATABASE dbx1 AS test
C.CATALOG DCS DATABASE dbx1 AT dbx1node
D.CATALOG DCS DATABASE test AT dbx1node
Correct:A
3.Which of the following settings for the DB2MAXFSCRSEARCH registry variable ensures a complete search for space in the database tables, possibly making inserts slower?
A.1
B.5
C.-1
D.33554
Correct:C
4.Defining a table as VOLATILE indicates which of the following to the DB2 optimizer?
A.The table is frequently dropped and recreated.
B.The number of rows in the table typically varies significantly.
C.The table is the target of SELECT statements from a large number of users.
D.The entire table should be kept in the buffer pool so that DB2 can access it using table scans.
Correct:B
5.Given the content of the services file: DB2_db2inst1 50500/tcp DB2_db2inst2 50510/tcp DB2_db2inst3 50511/tcp DB2_db2inst4 50512/tcp DB2_db2inst5 50513/tcp DB2_db2inst6 50514/tcp DB2_db2inst1_END 50505/tcp What must be changed to start eight database partitions on this server?
A.Add DB2_db2inst1_END 50507/tcp
B.Add DB2_db2inst7 50515/tcp DB2_db2inst8 50516/tcp
C.Change DB2_db2inst1_END 50505/tcp to DB2_db2inst1_END 50507/tcp
D.Change DB2_db2inst1_END 50505/tcp to DB2_db2inst8_END 50507/tcp
Correct:C
6.Which of the following actions must be performed in order to use online backups?
A.Enable LOGRETAIN followed by BACKUP database
B.Enable LOGRETAIN followed by QUIESCE database
C.Disable LOGRETAIN followed by BACKUP database
D.Disable LOGRETAIN followed by QUIESCE database
Correct:A
7.Increasing the value of NUM_POOLAGENTS can result in:
A.more agent pools being available for each application.
B.multiple agents being available if MAXAGENTS is set to 1.
C.more agents being available before the transaction starts.
D.more buffer pools being available for parallel query processing.
Correct:C
8.Given the following information: Database DB_1 on 4 partitions, 1, 2, 3, and 4 Database partition group DP1 on partitions 1, 2, and 3 Database configuration parameter BUFFPAGE = 1000 a nd the statement: CREATE BUFFERPOOL bp1 DATABASE PARTITION GROUP dp1 SIZE 4000 EXCEPT ON (DBPARTITIONNUMS 3 SIZE 3000) How many pages will be in BP1 on each partition?
A.1: 4000 2: 4000 3: 4000 4: 1000
B.1: 4000 2: 4000 3: 3000 4: 1000
C.1: 4000 2: 4000 3: 3000 4: BP1 is not created
D.1: 4000 2: 4000 3: 4000 4: BP1 is not created
Correct:C
9.TSP1 is a table space defined in database partition group DPG4 with 4 database partitions. Given the following table definition: CREATE TABLE tab_b AS SELECT * FROM tab_a) DATA INITIALLY DEFERRED REFRESH IMMEDIATE DISABLE QUERY OPTIMIZATION IN tsp1 REPLICATED ; Which of the following statements is correct?
A.The table TAB_B cannot be queried directly.
B.The data from table TAB_A is replicated into table TAB_B when the CREATE TABLE statement completes.
C.A full copy of the data from table TAB_A is replicated to each of the 4 database partitions in DPG4 after a refresh is completed.
D.The data from table TAB_A will be replicated into table TAB_B and partitioned across the 4 database partitions after a refresh is completed.
Correct:C
10.Given the following DDL statement: CREATE TABLE "DEW"."TABLE45" ( "I1" INTEGER , "D11" DECIMAL(1,0) NOT NULL , "D12" DECIMAL(1,0) NOT NULL , "S7" SMALLINT , "C8" CHAR(1) WITH DEFAULT ' ' ) organize by ( "D11" , "D12" ) How many indexes will be created?
A.0
B.1
C.2
D.3
Correct:D
11.What option on the SQL statement ALTER TABLESPACE guarantees there will be no rebalance when adding a container to an existing table space?
A.ADD AT END
B.NO REBALANCE
C.EXTEND STRIPE SET
D.BEGIN NEW STRIPE SET
Correct:D
12.In order to estimate the amount of space currently used by an existing table's data object per partition, which two of the following pieces of information are required?
A.fpages for the data object
B.number of rows in the table
C.number of indexes for the table
D.column definitions for the table
E.number of partitions in the database partition group for the table
Correct:A E
13.Which of the following database configuration parameters will avoid transaction rollback as a result of the database log path becoming full?
A.NUM_LOG_SPAN
B.MIRRORLOGPATH
C.OVERFLOWLOGPATH
D.BLK_LOG_DSK_FUL
Correct:D
14.Buffer pool BP1 is being used by a single table space TS1. The following statements are issued: ALTER TABLESPACE ts1 BUFFERPOOL bp2 DROP BUFFERPOOL bp1 What will happen as a result of these statements being issued?
A.The drop will be successful but the memory will not be released until the database has been stopped and started.
B.The drop will be successful and the memory will be released because it is no longer used by any of the table spaces.
C.The drop will fail stating that the user can attempt to drop the buffer pool again after the database has been stopped and started.
D.The drop will return a warning stating that the buffer pool is still in use and that it will be dropped automatically after the database has been stopped and started.
Correct:D
15.A 24 partition database spans four servers. Which command will run the mkdir command once per server?
A.rah "mkdir "
B.db2 "!mkdir "
C.db2_all "mkdir "
D.db2_all node +4 "mkdir "
Correct:A
16.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?
A.T2C1
B.T2C2
C.T2C3
D.T2C4
Correct:A
17.Which command needs to be run on the DB2 UDB Server in order to allow the clients to automatically find the server using Lightweight Directory Access Protocol (LDAP)?
A.ADD DB2 NODE IN LDAP AS PROTOCOL
B.CREATE DB2 SERVER IN LDAP AS PROTOCOL
C.REGISTER DB2 SERVER IN LDAP AS PROTOCOL
D.STORE DB2 SERVER INFORMATION IN LDAP AS PROTOCOL
Correct:C
18.Given a single physical server with a single OS image utilizing 24 CPUs and configured with 12 database partitions, how many of the database partitions can act as coordinator partitions for remote applications?
A.1
B.2
C.12
D.24
Correct:C
19.Given the following Event Monitor output: Statement Event ... Appl Handle: 0 Appl Id: *LOCAL.DB2.000523234208 Appl Seq number: 0001 Record is the result of a flush: FALSE ------------------------------------------- Type : Dynamic Operation: Close Section : 201 Creator : NULLID Package : SQLC29N3 Cursor : SQLCUR201 Text : select * from table1 order by deptno ------------------------------------------- ... Sorts: 1 T otal sort time: 927 Sort overflows: 1 Which of the following actions may resolve the problem shown in this event record?
A.Reorganize TABLE1
B.Increase the database heap size
C.Increase the sort heap threshold
D.Assign TABLE1 to its own buffer pool
Correct:C
20.When using the LIST INDOUBT TRANSACTIONS command to display transactions, which of the following actions CANNOT be performed on transactions listed?
A.They can be committed.
B.They can be forgotten.
C.They can be rolled back.
D.They can be acknowledged.
Correct:D
21.Given the following Explain Plan fragment: FETCH / \ RIDSCN T3 | IXAND / \ NLJOIN NLJOIN / \ / \ T1 T3 T2 T3 Which of the following is being performed?
A.Hash join
B.Star join
C.Index ORing
D.Index-only access
Correct:B
22.The INTRA_PARALLEL configuration parameter controls if DB2 can:
A.use multiple agents to handle a query.
B.use multiple buffer pools to handle a query.
C.perform parallel I/O to gather the result set for a query.
D.use multiple partitions to gather the result set for a query.
Correct:A
23.The split mirror technique was used to create a backup image of a database. A connection to the mirrored image of the database is possible after which of the following commands is issued?
A.db2inidb
B.db2start
C.restore database
D.activate database
Correct:A
24.Based on the following information: CREATE TABLE t1 ( t1c1 INT NOT NULL, t1c2 CHAR(5), t1c3 LONG VARCHAR, t1c4 INT) CREATE TABLE t2 ( t2c1 CHAR(7), t2c2 CHAR(5), t2c3 INT NOT NULL, t2c4 INT) and the query: SELECT t1c1, t2c1, SUM(t1c4) FROM t1, t2 WHERE t1c3 = 'ABCD' AND t2c1 = t1c2 AND t2c4 = 10 GROUP BY t1c1,t2c1; The cardinality of table T1 is 1,000,000 and the cardinality of the columns is as follows: T1C1 2 T1C2 500,000 T1C3 10 T1C4 1,000,000 Which of the following columns is the best partitioning key for table T1 to provide the fastest response time?
A.T1C1
B.T1C2
C.T1C3
D.T1C4
Correct:B
25.Which of the following SQL statements can increase the size of buffer pool IBMDEFAULTBP from 1000 pages to 5000 pages without requiring that the database be stopped and started?
A.ALTER BUFFERPOOL IBMDEFAULTBP SIZE 5000 NOW
B.ALTER BUFFERPOOL IBMDEFAULTBP NEW SIZE 5000
C.ALTER BUFFERPOOL IBMDEFAULTBP INCREASE BY 4000
D.ALTER BUFFERPOOL IBMDEFAULTBP IMMEDIATE SIZE 5000
Correct:D
26.Each Saturday, a full database backup of the PRODDB database is performed. Each weekday, incremental backups are performed. If a new table space is created on Wednesday, which of the following steps is required to ensure that the incremental backups will be successful?
A.Perform a full backup of the new table space.
B.Issue the command ARCHIVE LOG FOR DATABASE proddb.
C.Perform a cumulative backup of the new table space.
D.Set the TRACKMOD configuration parameter to NO, then reset it to YES.
Correct:A
27.When an active database fails over to the standby server, which of the following is required?
A.Crash recovery, roll forward recovery
B.Version recovery, roll forward recovery
C.Roll forward recovery, restart recovery
D.Point-in-time recovery, roll forward recovery
Correct:A
28.Given that a LOAD needs to spread the partitioning agents across the database partitions 1 and 2 out of database partitions 0 through 5, which of the following PARTITIONED DB CONFIG parameters is correct?
A.OUTPUT_DBPARTNUMS (1,2) MODE PARTITION_AND_LOAD
B.PARTITIONING_DBPARTNUMS (1,2) MODE PARTITION_AND_LOAD
C.PARTITIONING_DBPARTNUMBS (1,2) MODE PARTITION_AND_LOAD (0 TO 5)
D.PRE_PARTITIONING_DBPARTNUMS(0) MODE PARTITIONING_DBPARTNUMS (1,2)
Correct:B
29.Given the following DDL statement and data: CREATE TABLE "AJW"."TABLE46" ( "D10" SMALLINT NOT NULL , "D11" SMALLINT NOT NULL , "D12" SMALLINT NOT NULL , "S7" SMALLINT NOT NULL ) organize by ( ( "D12","D10" ) , "S7" ) D10 D11 D12 S7 --- ----- ------ ------ 4 -1 9 -22032 -6 -1 6 -22032 -5 -6 -6 -22032 4 2 9 -22032 -4 5 -6 -9232 -6 -9 9 11255 -3 -7 5 11255 4 6 5 11255 -3 2 5 11255 -3 6 5 11255 How many cells will contain data?
A.1
B.5
C.7
D.10
Correct:C
30.To check the integrity of a database image you would like to restore, which of the following DB2 commands can be used?
A.db2ckmig
B.db2ckimg
C.db2ckbkp
D.db2ckrst
Correct:C
