New Questions 1

You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

A. REAL

B. BIGINT

C. DECIMAL

D. INTEGER

View Answer

New Questions 2

Which of the following can activate a trigger?

A. A row is inserted

B. A table or view is created

C. A check constraint is defined

D. A referential constraint is violated

View Answer

New Questions 3

Given the following table and index definitions, what type of index will be created?

A. Non-partitioned index

B. Non-partitioned secondary index

C. Data-partitioned secondary index

D. Data-partitioned partitioning index

View Answer

New Questions 4

We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries(SALARY) for each of them. Which single SQL statement will do this?

A.

B.

C.

D.

View Answer

New Questions 5

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?

A. DB2 does not allow these commands

B. DSN command can not be used to run a program

C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session

D. Start a DSN session with system parameters SSTR, run a program and end the DSN session

View Answer

New Questions 6

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

A. COPY

B. REORG

C. STOSPACE

D. BACKUP SYSTEM

View Answer

New Questions 7

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

A. Child key

B. Collation key

C. Parent key

D. Secondary key

View Answer

New Questions 8

Which catalog tables are populated by RTS? (Choose two.)

A. SYSIBM.SYSTABLES

B. SYSIBM.SYSINDEXES

C. SYSIBM.SYSINDEXPART

D. SYSIBM.SYSINDEXSPACESTATS

E. SYSIBM.SYSTABLESPACESTATS

View Answer

New Questions 9

Consider the following scenario:

User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1

Is User3 able to retrieve rows from TABLE1?

A. No

B. Yes

C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES

D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

View Answer

New Questions 10

Which statement is TRUE regarding ROLLBACK processing?

A. It only reads active logs

B. It always needs archive logs

C. It can never be processed just from memory

D. It uses output buffers, active and archive logs

View Answer