NEW QUESTION 1
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 2
The creator of an index or an index specification automatically receives which privilege on the index?

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

Answer: D

NEW QUESTION 3
Which optional NPS compatibility features will be activated by executing the following? (Choose two.) SET SQL_COMPAT=‘NPS’

• A. YEARSBETWEEN
• B. BINARY and VARBINARY data types
• C. Double-dot notation to specify a database object
• D. OFFSET x ROWS FETCH FIRST y ROWS ONLY
• E. TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Answer: CE

NEW QUESTION 4
Which of the following statements about stored procedures is TRUE?

• A. Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
• B. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
• C. There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
• D. Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Answer: B

NEW QUESTION 5
If you are already connected to a database, what does running the following statement do? Db2 CONNECT

• A. Prompts you for the database name or alias
• B. Returns information about the current server
• C. Prompts you for the authentication information
• D. Returns an error, because you provided no database or alias

Answer: B

NEW QUESTION 6
The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?

• A. Shadow Table
• B. Temporal Table
• C. Range-Partitioned Table
• D. Multidimensional Clustered Table

Answer: B

NEW QUESTION 7
Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

• A. No other applications can access the table
• B. Only uncommitted read (UR) applications can access the table
• C. The lock owner and other applications can read, but not update, the locked table
• D. The lock owner can both read and update dat
• E. Other applications can read the table
• F. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Answer: AE

NEW QUESTION 8
What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL
NO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)

• A. Row
• B. Table
• C. Scalar
• D. External

Answer: C

NEW QUESTION 9
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

• A. Deadlock
• B. Lock timeout
• C. Lock escalation
• D. Lock conversion

Answer: A

NEW QUESTION 10
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 11
Which of the following statements regarding locking is TRUE?

• A. The same lock modes apply to tables, rows, or blocks
• B. Lock conversion can take place implicitly as a query executes
• C. Changing the mode of a lock that is already held is called lock escalation
• D. Lock conversion is not necessary if an X lock is required and an S or U lock is currently held

Answer: B

NEW QUESTION 12
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 13
Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

• A. View
• B. Alias
• C. Table
• D. Schema

Answer: A

NEW QUESTION 14
Which database object can be locked explicitly?

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

Answer: D

NEW QUESTION 15
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?

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

Answer: D

NEW QUESTION 16
Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

• A. Read Stability
• B. Cursor Stability
• C. Repeatable Read
• D. Cursor Stability with WAIT FOR OUTCOME clause

Answer: A

Explanation:
Read stability (RS) locks only those rows that an application retrieves within a unit of work. It ensures that any qualifying row read during a unit of work is not changed by other application processes until the unit of work completes, and that any row changed by another application process is not read until the change is committed by that process

NEW QUESTION 17
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 18
Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?

• A. Cloudant
• B. DB2 on Cloud
• C. dashDB for analytics
• D. dashDB for transactions

Answer: B

NEW QUESTION 19
Which of the following statements will successfully create a table that scores index data in a different table space than the table data?

• A. CREATE TABLE t1 (c1 INT, c2 INT);
• B. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2;
• C. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1;
• D. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;

Answer: B

NEW QUESTION 20
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 21
......