Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
P.S. Actual C2090-320 torrent are available on Google Drive, GET MORE: https://drive.google.com/open?id=1XIupSsBUtO-ijoq0DwWZR2atFXSuzaPm
New Questions 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 SYSIBM.SYSENVIRONMENT
C. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES
D. The communications database table SYSIBM.USERNAMES
Answer: C
New Questions 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
Answer: C
New Questions 3
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
Answer: B
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.
References:
New Questions 4
COL1 is defined as CHAR(05) and contains CHAR(u202112345u2021). Which of the following expressions returns the digits 12345 for further calculation?
A. HEX(COL1)
B. DEC(COL1)
C. PACK(COL1)
D. DIGITS(COL1)
Answer: B
New Questions 5
Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?
GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;
A. BIND
B. REORG
C. TRIGGER
D. EXECUTE
Answer: D
New Questions 6
Which of the following can be defined on the basis of a query?
A. An alias
B. A base table
C. An accelerator-only table
D. A materialized query table
Answer: D
New Questions 7
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
Answer: C
New Questions 8
Which of the following is a characteristic of a stand-alone utility?
A. It can only be executed using JCL
B. It can only be executed by a user with SYSADM
C. It can only be executed if no other utilities are running
D. It can only be executed in a non-data sharing environment
Answer: A
New Questions 9
Which DB2 address space manages DB2 locking?
A. IRLM
B. DIST
C. DBM1
D. MSTR
Answer: A
New Questions 10
Which catalog tables are populated by RTS? (Choose two.)
A. SYSIBM.SYSTABLES
B. SYSIBM.SYSINDEXES
C. SYSIBM.SYSINDEXPART
D. SYSIBM.SYSINDEXSPACESTATS
E. SYSIBM.SYSTABLESPACESTATS
Answer: DE
100% Far out IBM C2090-320 Questions & Answers shared by Examcollection, Get HERE: http://www.examcollectionuk.com/C2090-320-vce-download.html (New Q&As)