Online Access Free 000-610 Practice Test

Which object can a buffer pool be assigned to?

• A.Stored procedure
• B.Schema
• C.Table space
• D.Storage group

Which DB2 product is NOT suitable for very large data warehouse applications?

• A.DB2 for i
• B.DB2 for AIX
• C.DB2 for Linux
• D.DB2 for z/OS

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

• A.ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
• B.ALTER TABLE sales ALTER COLUMN item CHAR(40);
• C.ALTER TABLE sales ADD COLUMN item CHAR(40);
• D.ALTER TABLE sales MODIFY COLUMN item CHAR(40);

Which database object provides an alternative way of describing data that exists in one or more base tables?

• A.Alias
• B.Sequence
• C.View
• D.Index

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

• A.SELECT job, MIN(salary), MAX(salary)
  FROM employee
  GROUP BY job;
• B.SELECT job, MIN(salary), MAX(salary)
  FROM employee
  ORDER BY job;
• C.SELECT job, MIN(salary), MAX(salary)
  FROM employee
  GROUP BY job, MIN(salary), MAX(salary);
• D.SELECT JOB, MIN(salary), MAX(salary)
  FROM employee
  ORDER BY job, MIN(salary), MAX(salary);