Which product replaced the Control Center used in versions prior to DB2 v10、

试卷相关题目

• 1What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object、

  A.inline

  B.binary

  C.internal

  D.partitioned

  开始考试点击查看答案
• 2Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads、

  A.DB2 Connect

  B.DB2 pureScale

  C.Workload Manager

  D.High Availability Disaster Recovery

  开始考试点击查看答案
• 3Which statement about large object (LOB) locators is true、

  A.A LOB locator is a data type that is used to store LOB data in binary files.

  B.A LOB locator is a data type that is used to store LOB data in a database.

  C.A LOB locator represents a value for a LOB resource that is stored in a database.

  D.A LOB locator represents a value for a LOB resource that is stored in a binary fil

  开始考试点击查看答案
• 4Which object is used to cache table and index data as it is read from disk、

  A.Database

  B.Buffer pool

  C.Table space

  D.Package cache

  开始考试点击查看答案
• 5What needs to be defined in order to track changes made to a system-period temporal table overtime、

  A.Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.

  B.A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.

  C.A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefine

  D.B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined.D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history tabl

  开始考试点击查看答案
• 6Which DB2 product is NOT suitable for very large data warehouse applications、

  A.DB2 for i

  B.DB2 for AIX

  C.DB2 for z/OS

  D.DB2 for Linux

  开始考试点击查看答案
• 7Which platform supports DB2 pureScale environments、

  A.AIX

  B.iOS

  C.z/OS

  D.Windows

  开始考试点击查看答案
• 8Which tool allows users to connect to a DB2 database using a wizard、

  A.Control Center

  B.IBM Data Studio

  C.Universal Connection Expert

  D.DB2 Connection Pool Manager

  开始考试点击查看答案
• 9A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results、

  A.SELECT name, COUNT(*) AS transactions FROM sales

  B.SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

  C.SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

  D.SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

  开始考试点击查看答案
• 10Which statement about roll back operations is correct、

  A.When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

  B.When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

  C.When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are release

  D.D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

  开始考试点击查看答案