Top Tips Of Up To The Immediate Present C2090-320 Testing Bible

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 characteristic best describes a created global temporary table?

• A. Inserts are logged
• B. Rows are locked when they exist in the table
• C. They have permanent, shareable descriptions
• D. Access to rows can be shared across multiple processes

Answer: C

NEW QUESTION 3
Given the following sequence of events:
* 1) COL1 in SCHEMA.TABLE has a value of 10
* 2) Update COL1 in SCHEMA.TABLE to 20
* 3)SetSAVEPOINTA
* 4) Update COL1 in SCHEMA.TABLE to 30
* 5)SetSAVEPOINTB
After issuing the statement: ROLLBACK TO SAVEPOINT
What will be the value in COL1 of the SCHEMA.TABLE?

• A. 10
• B. 20
• C. 30
• D. An -880 SQLCODE will be issued when the statement is executed

Answer: D

NEW QUESTION 4
In a unique referential constraint, which type of key does a foreign key reference?

• A. Child key
• B. Collation key
• C. Parent key
• D. Secondary key

Answer: C

NEW QUESTION 5
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 6
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

• A. PAGE
• B. TABLE
• C. PARTITION
• D. TABLESPACE

Answer: C

NEW QUESTION 7
The following warning message is issued when the last available active log data set is 5% full: DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL
What will happen if you ignore this message?

• A. DB2 will shut down if it reaches the 100 % full condition
• B. DB2 will overwrite the oldest archive log without archiving
• C. DB2 will stop any activity that requires log writes if it reaches the 100 % full condition
• D. DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them

Answer: A

NEW QUESTION 8
Which statement is TRUE regarding ROLLBACK processing?

• A. It only reads active logs
• B. It always needs archive logs
• C. It can never be processed just from memory
• D. It uses output buffers, active and archive logs

Answer: D

NEW QUESTION 9
What is the proper sequence for running the steps of the program preparation process?

• A. Precompil
• B. compile, link edit, bind
• C. Bind, precompile, compile, link edit
• D. Precompil
• E. bind, link edit, compile
• F. Link edit, precompile, compile, bind

Answer: C

Explanation:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/db2z_programprepprocesses.ht

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

• A. SYSADM
• B. SECADM
• C. SYSCTRL
• D. Installation SYSADM
• E. Installation SYSOPR

Answer: DE

NEW QUESTION 11
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

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

Answer: A

NEW QUESTION 12
User1 creates table user1 .customers in a partitioned-by-growth (PBG) table space DB1.TS1
Which of the following operations CANNOT be performed by user1 with implicit owner privileges on the table?

• A. Run the LOAD utility to load data
• B. Create a VIEW on the customers table
• C. Run the REORG utility to reorganize the data
• D. Issue an SQL LOCK TABLE statement against the customers table

Answer: A

NEW QUESTION 13
Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

• A. Declaring a cursor
• B. Using the WHENEVER statement
• C. Using DCLGEN to produce declarations for tables
• D. Dynamically executing a statement with parameter markers

Answer: D

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

Answer: B

NEW QUESTION 15
Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two)

• A. MAXPARTITIONS
• B. ENDING AT clause on a CREATE INDEX statement for the table
• C. MEMBER CLUSTER
• D. ENDING AT clause on the CREATE TABLE statement
• E. A LOB column specified as a column of the partitioning key

Answer: B

NEW QUESTION 16
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 17
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 18
Given the following table:

Which of the following INSERT statements will be successful?

• A. INSERT INTO EMPSAMP (empno.name, salary, deptno, level,hiretyp
• B. hiredate) VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing705-06-2021');
• C. INSERT INTO EMPSAMP ('Mary Smith', 35000.00. 11, 'Associate', 'existing705-06-2021');
• D. INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing'05-06-2021');
• E. INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES('Mary Smith', 35000.00, 11, 'Associate'):

Answer: B

NEW QUESTION 19
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

• A. SELECT * FROM MYUSER.EMP;
• B. CONNECT TO MYREMOTE;SELECT * FROM MYUSER.EMP;
• C. SELECT * FROM MYUSER.MYREMOTE.EMP;
• D. CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP;SELECT * FROM MYUSER.EMP_ALIAS;

Answer: B

NEW QUESTION 20
Which CREATE TABLESPACE option specifies that a table space is partition-by-growth?

• A. DSSIZE
• B. PARTITION
• C. NUMPARTS
• D. MAXPARTITIONS

Answer: D

NEW QUESTION 21
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 22
Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?

• A. No
• B. Yes
• C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
• D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

Answer: B

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