IBM Assessment DB2 10.1 Fundamentals Set 2

1.

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

SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY jobORDER BY job; SELECT job, MIN(salary), MAX(salary)FROM employeeORDER BY job; SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY SALARYORDER BY job; SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY MIN(salary), MAX(salary)ORDER BYjob;

2.

Which type of stored procedure is not associated with an external application program?

A Java stored procedure. A REXX stored procedure. A native SQL stored procedure. An external SQL stored procedure.

3.

Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?

SELECT workdept, AVG(salary)FROM employeeORDER BY workdeptGROUP BY 2 SELECT workdept, AVG(salary)FROM employeeORDER BY workdeptARRANGE BY 2 SELECT workdept, AVERAGE(salary)FROM employeeGROUP BY workdeptORDER BY 2 SELECT workdept, AVG(salary)FROM employeeGROUP BY workdeptORDER BY 2

4.

Which statement about system-period temporal tables is true?

They store user-based period information. They do not have a separate history table. They can be queried without a time period specification. They manage data based on time criteria specified by users or applications.

5.

A table named DEPARTMENT contains the following data: What will happen?

The statement will fail because a subquery cannot be used in an UPDATE statement. The statement will fail because the result set produced by the subquery will contain more than one row. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPTvalue for the update operation. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPTvalue for the update operation.

6.

Given the following statements: What will be the result?

Joe Smith Joe Smith Joe Smith>DB2 Joe Smith

7.

A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?

SELECT state_cd, COUNT(*)FROM statesORDER BY COUNT(*); SELECT state_cd, COUNT(*)FROM statesGROUP BY state_cdORDER BY state_cd; SELECT region_cd, COUNT(*)FROM statesGROUP BY state_cdORDER BY COUNT(*); SELECT region_cd, COUNT(*)FROM statesGROUP BY region_cdORDER BY COUNT(*);

8.

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

The SYSIBM schema. The SYSFUN schema. A schema with the name of the UDF. A schema with the userid of the UDF definer.

9.

What is a function of a table check constraint?

To provide a method of avoiding duplicate entries for a column. To provide a method of ensuring a column's values are within a specific range. To ensure that XML columns are properly populated in an associated XML table space. To enforce relationships between tables by checking the existence of rows in one table against another.

10.

Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?

Base Table Temporal Table Transition Table Temporary Table

IBM Assessment DB2 10.1 Fundamentals Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Assessment DB2 10.1 Fundamentals Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner