IBM DB2 11 Fundamentals for z/OS C2090-320 Exam Practice Test

In order to run a DB2 program, the user issues the following commands:

TSO prompt: READY

USER enters: DSN SYS(SSTR)

USER enters: RUN PROGRAM(MYPROG)

USER enters: END

What is the result?

The following definition for COL1 is given by this statement:

CREATE TABLE... (COL1 BINARY (05))

Which of the following statements will successfully insert data into the table?

In a unique referential constraint, which type of key does a foreign key reference?

The PERIOD BUSINESS_TIME clause on a DDL statement is used in which of the following? (Choose two)

Which of the following automatically maintains historical versions of data over several years?

Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for all employees from the EMP table.

A)

B)

C)

D)

Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?