最新的IBM C2090-320免費考試真題

問題1

Which of the following describes OLTP workload rather than an analytics workload?

A. A large number of short, discrete, atomic transactions

B. Temporary or intermediate staging of data

C. Set-oriented processing and bulk operations

D. Extreme data volume

正確答案: A

問題2

Given the following table:

Which of the following INSERT statements will be successful?

A. INSERT INTO EMPSAMP (empno.name, salary, deptno, level,hiretype. hiredate) VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing705-06-2016');

B. INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing\'05-06-2016');

C. INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES('Mary Smith', 35000.00, 11, 'Associate'):

D. INSERT INTO EMPSAMP ('Mary Smith', 35000.00. 11, 'Associate', 'existing705-06-2016');

正確答案: D

問題3

Which option is used with the RECOVER utility when the data sets of the target objects have already been restored to a point of consistency by another process offline?

A. TOLASTCOPY

B. LOGONLY

C. FROMDUMP

D. CURRENTCOPYONLY

正確答案: B

問題4

Which DB2 address space manages DB2 locking?

A. MSTR

B. DIST

C. DBM1

D. IRLM

正確答案: D

問題5

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

A. Data-partitioned secondary index

B. Data-partitioned partitioning index

C. Non-partitioned secondary index

D. Non-partitioned index

正確答案: A

問題6

Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

A. GET DIAGNOSTICS

B. DECLARE STATEMENT

C. DESCRIBE OUTPUT

D. SET CURRENT DEBUG MODE

正確答案: A

問題7

Which authorizations can change the value of the subsystem parameter SYSADM using the -SET SYSPARM command? (Choose two.)

A. Installation SYSADM

B. SECADM

C. Installation SYSOPR

D. SYSCTRL

E. SYSADM

正確答案: A,C

最新的IBM DB2 11 Fundamentals for z/OS - C2090-320免費考試真題

聯系我們

站內鏈接

最新更新