Highest Quality IBM C2090-616 Simulations Online

NEW QUESTION 1
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 2
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 3
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 4
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 5
What is the purpose of a role?

• A. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated
• B. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges
• C. To group a collection of privileges together so that they can be simultaneously granted to and revoked frommultiple users, groups, or other roles
• D. To assign one or more users that need to run local DB2 applications and tools on a particular server to theDB2ADMNS or the DB2USERS group

Answer: A

NEW QUESTION 6
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

• A. COMMIT
• B. SAVEPOINT
• C. ROLLBACK WORK
• D. UPDATE TERMINATE

Answer: C

NEW QUESTION 7
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 8
A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?

• A. Shadow tables
• B. Range-partitioned tables
• C. Materialized query tables
• D. Multidimensional clustering tables

Answer: A

NEW QUESTION 9
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 10
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 11
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 12
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 13
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 14
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 15
What is the maximum precision for the DECIMAL data type?

• A. 7
• B. 15
• C. 23
• D. 31

Answer: D

Explanation:
A decimal number is a packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits.
Reference https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/ db2z_numericdatatypes.html

NEW QUESTION 16
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 17
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuser

• A. An error is returned
• B. An entry is mane in SYSCAT.TABAUTH
• C. The REVOKE statement succeeds with no effect
• D. All privileges are granted to user MYUSER on MYTABLE

Answer: C

NEW QUESTION 18
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

• A. DELETE FROM t1
• B. DELETE* FROM t1
• C. DELETE* TABLE t1
• D. TRUNCATE TABLE t1 IMMEDIATE
• E. TRUNCATE TABLE t1

Answer: AB

NEW QUESTION 19
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 20
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 21
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 22
The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A; GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3; GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later? REVOKE ROLE roleB FROM USER db2inst3;

• A. This statement will succeed and DB2 INST3 will still be able to create in the database
• B. This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
• C. This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time
• D. This statement will succeed with a warning since CREATETAB cannot be totally revoke
• E. DB2INST3 willretain both roles

Answer: D

NEW QUESTION 23
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

• A. NOT NULL
• B. Foreign key
• C. Primary key
• D. Informational constraint

Answer: C

NEW QUESTION 24
......