Top Tips Of Replace C2090-320 Exam Dumps

NEW QUESTION 1
Using the SQL statement DECLARE GLOBAL TEMPORARY TABLE (DGTT) which of the following is TRUE?

• A. A DGTT is only stored in memory
• B. The qualifier for a DGTT is SESSION
• C. The DGTT can be specified in a referential constraint
• D. All privileges associated with the DGTT are stored in the DB2 catalog

Answer: B

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

• A. COPY
• B. REORG
• C. STOSPACE
• D. BACKUP SYSTEM

Answer: D

NEW QUESTION 3
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 4
Which of the following elements is affected by a ROLLBACK statement?

• A. LOB table spaces
• B. Changes in cursor positioning
• C. Acquisition and release of locks
• D. Caching of rolled back statements

Answer: A

NEW QUESTION 5
Which job generates the subsystem parameter module?

• A. DSNTIJIN
• B. DSNTIJJP
• C. DSNTIJUZ
• D. DSNTIJEN

Answer: C

NEW QUESTION 6
In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

• A. A unique key
• B. A foreign key
• C. A primary key
• D. A duplicate key
• E. A secondary key

Answer: AC

NEW QUESTION 7
To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table If D32 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?

• A. CHECK PENDING
• B. REORG PENDING
• C. REBUILD PENDING
• D. ADVISORY REORG PENDING

Answer: A

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

• A. GET DIAGNOSTICS
• B. DESCRIBE OUTPUT
• C. DECLARE STATEMENT
• D. SET CURRENT DEBUG MODE

Answer: A

NEW QUESTION 9
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 QUESTION 10
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 11
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 12
Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

• A. Data Facility Storage Management
• B. z/OS Parallel Sysplex Configuration
• C. Workload Manager
• D. z Systems Processor Resource

Answer: C

NEW QUESTION 13
Which type of constraint is NOT enforced by DB2 during SQL processing?

• A. Check
• B. Referential
• C. Primary key
• D. Informational referential

Answer: D

NEW QUESTION 14
Which catalog table provides information about the validity of a bound package?

• A. SYSIBM.SYSPACKLIST
• B. SYSIBM.SYSPACKAGE
• C. SYSIBM.SYSPACKDEP
• D. SYSIBM.SYSPACKAUTH

Answer: A

NEW QUESTION 15
Which of the following is TRUE for using LOAD on a partition-by-growth table space?

• A. Data can only be loaded at the partition level
• B. Data can only be loaded at the table space level
• C. Data can only be loaded using a clustering index
• D. Data can be loaded at either the table space level or the partition level

Answer: A

NEW QUESTION 16
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 17
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 18
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?

• A. All held LOB locators are retained
• B. All locks that are implicitly acquired during the unit of recovery are retained
• C. All rows and all logical work files of every created temporary table of the application process are deleted
• D. All cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated

Answer: C

NEW QUESTION 19
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 20
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

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

Answer: D

NEW QUESTION 21
If a scrollable cursor is INSENSITIVE, which of the following applies?

• A. The cursor is read only
• B. WITH ROWSET POSITIONING is not allowed
• C. The select-statement must not contain an SQL data change statement
• D. The cursor has sensitivity to changes that are made to the database after the result table is materialized

Answer: A

NEW QUESTION 22
Which SQL statement will retrieve the department number (WORKDEPT)
and the highest salary (SALARY) for each department in a table
named EMPLOYEE and arrange the result set in ascending order by department?

• A. SELECT workdept, salary FROM employee GROUP BY workdept ORDER BY workdept;
• B. SELECT workdept MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;
• C. SELECT workdept MAX(salary) FROM employee ORDER BY workdept;
• D. SELECT workdept MAX(salary) FROM employee GROUP BY workdept ORDER BY 1;

Answer: B

NEW QUESTION 23
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 QUESTION 24
The following definition for COL1 is given by this statement: CREATE TABLE… (COL1 BINARY (05))
Which of the following statements will successfully insert data into the table?

• A. INSERT INTO… (COL1) VALUES(HEX(‘12345’));
• B. INSERT INTO… (COL1) VALUES(BLOB(‘12345’));
• C. INSERT INTO… (COL1) VALUES(CHAR(‘12345’));
• D. INSERT INTO… (COL1) VALUES(BINARY(‘123456’));

Answer: C

NEW QUESTION 25
......