C2090-320 시험 - IBM실제시험문제와 답 - 123문항

Question No : 1

Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

A.The resource limit facility table authid.DSNRLMTxx
B.The DB2 catalog table SYSIB
C.SYSENVIRONMENT
D.The profile table SYSIB
E.DSN_PROFILE_ATTRIBUTES
F.The communications database table SYSIB
G.USERNAMES

정답:

Question No : 2

You want to limit the access of a table to allow users to only see certain columns and/or rows.
Which of the following options CANNOT be used to accomplish this?

A.A view
B.Multilevel security
C.An MQT (Materialized Query Table)
D.A combination of row permissions and column masks

정답:

Question No : 3

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.

정답:

Question No : 4

What are two major encoding schemes? (Choose two.)

A.UNIX
B.Linux
C.CCSID
D.Unicode
E.EBCDIC

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/ db2z_introcodepage.html

Question No : 5

Which DB2 address space manages DB2 locking?

A.IRLM
B.DIST
C.DBM1
D.MSTR

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/inst/src/tpc/ db2z_irlmaddrspcstgreq.html

Question No : 6

COL1 is defined as CHAR(05) and contains CHAR(‘12345’).
Which of the following expressions returns the digits 12345 for further calculation?

A.HEX(COL1)
B.DEC(COL1)
C.PACK(COL1)
D.DIGITS(COL1)

정답:

Question No : 7

Which BIND option determines when DB2 will do authorization checking?

A.DEFER
B.DEPLOY
C.VALIDATE
D.CURRENTDATA

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_bindoptvalidate.html

Question No : 8

Which types of user-defined data types are supported? (Choose two.)

A.CHAR
B.ARRAY
C.NUMERIC
D.DISTINCT
E.TIMESTAMP

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_userdefineddatatypes.html

Question No : 9

Which of the following statements about a system-period temporal table is TRUE?

A.Rows can be archived into a history table which is always read only
B.Every row has a pair of timestamps which is set and managed by the application
C.AN SQL query for auditing can be run against current data or history data, but not both
D.The table contains only the current active rows

정답:
Explanation:
Explanation In a system-period temporal table, every row has a pair of timestamps, which are set by the DB2 system and recorded in the begin_column and end_column columns. DB2 uses the SYSTEM_TIME period to audit the data changes. It provides the application with the database managed row begin and row end timestamp maintenance, providing non-overlapping time periods with no gaps in time.
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1410temporal-tables-db2zos/ index.html

Question No : 10

The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)

A.DSSIZE
B.PRIQTY
C.NUMPARTS
D.BUFFERPOOL
E.MAXPARTITIONS

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html

Question No : 11

Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

A.Reduced active logs
B.Reduced storage use
C.Higher transaction rates
D.Reduced lock contention
E.Increased data availability

정답:

Question No : 12

Given the tables:

Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.
A.

B.

C.

D.

정답: A

Question No : 13

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

A.Extreme data volume
B.Temporary or intermediate staging of data
C.Set-oriented processing and bulk operations
D.A large number of short, discrete, atomic transactions

정답:
Explanation:
Reference: http://www.ibmbigdatahub.com/sites/default/files/document/IBM-Netezza-Understanding-Analytic-Workloads-eBook.pdf

Question No : 14

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

정답:
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_cmd_dsn.html

Question No : 15

Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?