C2090-320 | The Leading Guide To C2090-320 Braindump

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

• A. A partitioned-by-range table
• B. A partitioned-by-growth table
• C. A system-period temporal table
• D. An application-period temporal table

Answer: C

NEW QUESTION 2
When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

• A. CREATE TRIGGER...;
• B. CREATE TABLE... IN dbl.ts1;
• C. CREATE DATABASE ... STOGROUP stogr1;
• D. CREATE TABLESPACE... USING STOGROUP stogr1;

Answer: C

NEW QUESTION 3
For a partition-by-range table, which data types can be used to define the key columns that are used to partition the data? (Choose two)

• A. XML I
• B. BINARY
• C. DECIMAL
• D. VARCHAR
• E. DECFLOAT

Answer: AD

NEW QUESTION 4
When you add an XML column to a table by using an ALTER TABLE statement, which of the following are TRUE? (Choose two)

• A. DB2 implicitly creates an XML table space
• B. DB2 implicitly creates an AUX table to store the XML data
• C. If this is the first XML column you created for the table, DB2 implicitly creates a unique index on the XML column
• D. If this is the first XML column you created for the table, DB2 implicitly creates a ROWID column on the base table
• E. If this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID column on the base table

Answer: DE

NEW QUESTION 5
Given the following SQL statement:
GRANT DELETE ON TABLE customer TO used; Which of the following statements is TRUE?

• A. User1 can only remove the customer table
• B. User1 can only remove rows from the customer table
• C. User1 can remove the customer table and grant the privilege to remove the customer table to other users
• D. User1 can remove rows from the customer table and can grant the privilege to remove rows from the customer table to other users

Answer: C

NEW QUESTION 6
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 QUESTION 7
Which SQL statement supports an insert or an update in a single SQL statement?

• A. MERGE
• B. UPSERT
• C. UPDATE or INSERT INTO....
• D. INSERT INTO table... ON DUPLICATE KEY ....

Answer: D

NEW QUESTION 8
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. LOGONLY
• B. FROMDUMP
• C. TOLASTCOPY
• D. CURRENTCOPYONLY

Answer: A

NEW QUESTION 9
Which type of lock is obtained when using a 'WITH UR1 clause on an SQL SELECT statement in a data-sharing environment?

• A. U-lock
• B. S-lock
• C. P-lock
• D. No lock is obtained

Answer: B

NEW QUESTION 10
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)

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: D

NEW QUESTION 11
Which two of the following functions are synonyms of one another? (Choose two)

• A. CLOB
• B. VALUE
• C. IFNULL
• D. DBCLOB
• E. COALESCE

Answer: CE

NEW QUESTION 12
How can a user-defined function (UDF) be invoked?

• A. Via an SQL SELECT statement
• B. Via a CALL statement using SPUFI
• C. Directly via a RUN PROGRAM command
• D. Via a CALL statement from within an application program

Answer: B

NEW QUESTION 13
Which of the following utilities or utility control statements require datasets for execution?

• A. LISTDEF
• B. OPTIONS
• C. TEMPLATE
• D. CHECK LOB

Answer: A

NEW QUESTION 14
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

Answer: D

NEW QUESTION 15
Which of the following SELECT statements returns a different data value than the other SQL statements ?

• A. SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• B. SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• C. SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENTTIMESTAMP(10))l6l2)t,0')l11l") FROM SYSIBM.SYSDUMMY1;
• D. SELECT TIMESTAMPDIFF(64. CHAR( CURRENT TIMESTAMP - TIMESTAMP('2021-01-01-00.00.00'))) FROM SYSIBM.SYSDUMMY1;

Answer: A

NEW QUESTION 16
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

Answer: C

NEW QUESTION 17
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. A
• B. B
• C. C
• D. D

Answer: D

NEW QUESTION 18
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is "DROP INDEX AAA". Which of the following statements must precede th$ DROP statement so that it drops the index?

• A. SET CURRENT PATH = 'DB2';
• B. SET CURRENT RULES = 'DB2';
• C. No preceding statement is needed
• D. SET CURRENT SCHEMA = 'DB2':

Answer: A

NEW QUESTION 19
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

• A. Contains scheduled tasks for the administrative scheduler
• B. Contains information about UDFs, BIFs and stored procedures
• C. Contains information about bound packages
• D. Contains information about UDFs and stored procedures

Answer: D

NEW QUESTION 20
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?

• A. Bind your application with ISOLATION(UR)
• B. Bind your application with ISOLATION(CS)
• C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
• D. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

Answer: D

NEW QUESTION 21
Which of the following is NOT a valid lock size in DB2?

• A. Table
• B. Partition
• C. Database
• D. Table space

Answer: C

NEW QUESTION 22
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 QUESTION 23
Which of the following statements concerning a bi-temporal table is TRUE?

• A. It provides business history, but is not useful for audit purposes
• B. It is defined with both an application period and a system period
• C. It is useful for audit purposes, but is not useful for business history
• D. It contains data reflecting two different times – current time and one previous time

Answer: B

NEW QUESTION 24
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

Answer: CE

NEW QUESTION 25
DB2 native SQL procedures execute in which DB2 address space?

• A. IRLM
• B. DIST
• C. DBM1
• D. WLM stored procedure

Answer: D

NEW QUESTION 26
......