题目内容

If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）

All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.
B. Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.
C. Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.
D. A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.

查看答案

搜索结果不匹配？点我反馈

更多问题

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

A. db2advis -d proddb -i workload.sql -P
B. db2advis -d proddb -i workload.sql -partitioning
C. db2advis -d proddb -i workload.sql -m P
D. db2advis -d proddb -i workload.sql -m ALL

查看答案

After visiting several customers， the pSeries technical specialist returns to the office late in the day and makes a list of the various customer requests. The specialist decided to complete at least one task before leaving for the day. Which of the following is most important to complete immediately？（）

A. Send a flyer on new p5-520.
B. Provide shipment delivery status.
C. Order a new system per the purchase order.
D. Retrieve and send a whitepaper on SCSI performance.

查看答案

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

A. Code the application to issue a LOCK TABLE statement.
B. Code the application to issue a LOCK ROW statement.
C. Decrease the number of I/O servers.
D. Increase the locklist parameter.

查看答案

A customer left a message on the pSeries technical specialist’s voicemail that a proposal is needed for a p5-550 4-way 1.4GHz 8GB machine. The specialist configured a p5-570 4-way 1.5GHz 8GB machine and sent it to the customer with a note that this system was the closest match to that requested.could the specialist have done to minimize any customer dissatisfaction in an efficient manner？（）

A
B
C
D

查看答案