Which platform supports DB2 pureScale environments、

试卷相关题目

• 1Which 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

  开始考试点击查看答案
• 2Which product replaced the Control Center used in versions prior to DB2 v10、

  A.IBM Data Studio

  B.IBM Administrator

  C.IBM Data Manager

  D.IBM Command Center

  开始考试点击查看答案
• 3What 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

  开始考试点击查看答案
• 4Which 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

  开始考试点击查看答案
• 5Which 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

  开始考试点击查看答案
• 6Which 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

  开始考试点击查看答案
• 7A 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

  开始考试点击查看答案
• 8Which 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.

  开始考试点击查看答案
• 9When a COMMIT statement is executed, what happens、

  A.All locks held on the database are automatically released.

  B.Data stored in global temporary tables is automatically deleted.

  C.Open cursors defined WITH HOLD are closed, but their data is retaine

  D.D. The current transaction is terminated and a new transaction boundary is started.

  开始考试点击查看答案
• 10Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE、

  A.SELECT * FROM employee WHERE salary < 100000

  B.SELECT salary FROM employee WHERE salary > 100000

  C.SELECT salary FROM employee WHERE salary > 100,000.00

  D.SELECT * FROM employee WHERE salary GREATER THAN 100000

  开始考试点击查看答案