NEW QUESTION 1
Which of the following set operators can be used to find all rows that are common in 2 queries?

• A. UNION
• B. UNION ALL
• C. EXCEPT ALL
• D. INTERSECT ALL

Answer: B

NEW QUESTION 2
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?

• A. DB2 HADR
• B. DB2 pureScale
• C. DB2 Express-C
• D. DS2 Database Partitioning Feature

Answer: B

NEW QUESTION 3
What of the following is TRUE about triggers?

• A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
• B. Triggers can be used to perform data manipulation operations against complex views
• C. Triggers can only be used to execute logic before or after appropriate SQL statements
• D. Only one trigger for a particular event and activation time can be created for a particular table

Answer: A

NEW QUESTION 4
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)

• A. Shadow tables cannot be queried directly
• B. Shadow tables do not store their data on disk
• C. Shadow tables must be organized by column
• D. Shadow tables must be maintained by replication
• E. You cannot join shadow tables to other kinds of tables

Answer: CD

NEW QUESTION 5
Which of the following editions of DB2 include support for Federation with Oracle database?

• A. DB2 Express-C
• B. DB2 Developer Edition
• C. DB2 Enterprise Server Edition
• D. DB2 Workgroup Server Edition

Answer: C

NEW QUESTION 6
What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

• A. 32672 bytes
• B. 65344 bytes
• C. 98016 bytes
• D. 130688 bytes

Answer: A

NEW QUESTION 7
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

• A. db2look with the –x option
• B. db2pd with the –auth option
• C. Query the SYSCAT.DBAUTH view
• D. Query the SYSCAT.TABLES view
• E. Query the SYSCAT.TABAUTH view

Answer: CE

NEW QUESTION 8
Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

• A. DB2 Connect
• B. DB2 Runtime Client
• C. DB2 Data Server Client
• D. DB2 Enterprise Server Edition

Answer: A

NEW QUESTION 9
Which of the following is TRUE about DB2 OLAP functions?

• A. They return scalar values and not array values
• B. There are no DB2 monitor elements specific to OLAP functions
• C. OLAP functions are not supported in a common table expression (CTE)
• D. OLAP aggregation functions are not supported with column organized tables

Answer: C

NEW QUESTION 10
The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?

• A. SYSCAT.DBAUTH
• B. SYSIBMADM.GRANTS
• C. SYSIBMADM.PRIVILEGES
• D. SYSCAT.USER_TAB_PRIVS

Answer: A

NEW QUESTION 11
Application 1 executes the following statements:
INSERT INTO TAB1 (NAME,AMOUNT) VALUES (‘John,100); COMMIT;
UPDATE TAB1 SET AMOUNT=90 WHERE NAME=‘John’;
After a few seconds, application 2 executes the following query: SELECT AMOUNT FROM TAB1 WHERE NAME=‘John’
Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?

• A. Application 2 will read the amount of 90
• B. Application 2 will read the amount of 100
• C. Application 2 will receive a warning message
• D. Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires

Answer: B

NEW QUESTION 12
A user executes the following statements: REATE TABLE t1 (c1 INT, c2 INT); CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement? DROP ALIAS a1;

• A. The alias A1 will be dropped
• B. The table T1 will be dropped
• C. Both T1 and A1 will be dropped
• D. Nothing, the statement will result in an error

Answer: A

NEW QUESTION 13
Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

• A. Implicit casting
• B. Double-dot notation
• C. Use of bitmap indexes
• D. Selecting from the DUAL table

Answer: D

NEW QUESTION 14
Which of the following authorities is sufficient for connecting to a database?

• A. SQLADM
• B. CONNECT
• C. DATAACESS
• D. ACCESSCTRL

Answer: D

NEW QUESTION 15
If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

• A. Concurrency may be improved
• B. Lock escalation will be prevented
• C. Query performance will be reduced
• D. The number of locks for the same workload will be reduced

Answer: A

NEW QUESTION 16
Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN ‘000020’ and ‘000070’ Result:
If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > ‘000020’ AND empno ‘000070’

• A. 1
• B. 3
• C. 5

Answer: C

NEW QUESTION 17
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

• A. Read Stability
• B. Cursor Stability
• C. Repeatable Read
• D. Uncommitted Read

Answer: C

NEW QUESTION 18
Which database object can be locked explicitly?

• A. Row
• B. View
• C. Index
• D. Table

Answer: D

NEW QUESTION 19
Which operation typically requires a Share (S) lock?

• A. INSERT
• B. SELECT
• C. DELETE
• D. UPDATE

Answer: D

NEW QUESTION 20
Which of the following is TRUE regarding user switching in a trusted context?

• A. You cannot switch user id in a trusted context
• B. You can issue a switch-user request within a transaction
• C. The new user must have the connect-privilege on the database for it to succeed
• D. No password is ever required for the new user as an authentication is established in the trusted connection

Answer: D

NEW QUESTION 21
......