Approved C2090-616 Free Practice Questions 2021

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 DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

• A. Sequence
• B. Row Identifier
• C. Identity Column
• D. Insert time clustering table

Answer: A

NEW QUESTION 3
Which method for restricting data access relies on security labels and security policies to control what data a user can access?

• A. Authentication
• B. Authorities and privileges
• C. Label-based access control
• D. Row and column access control

Answer: C

NEW QUESTION 4
Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2021?

• A. UPDATE t1 c1 = ‘DB2, c2’ = 11
• B. UPDATE t1 SET c1 = ‘DB2, c2’ = 11
• C. UPDATE t1 c1 = ‘DB2’, c2 = 11 WHERE c3 = 2021
• D. UPDATE t1 SET (c1, c2) = (‘DB2’, 11) = WHERE c3 = 2021

Answer: C

NEW QUESTION 5
Which database object can be locked explicitly?

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

Answer: D

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
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 8
The DDL statement is used to create table T1: CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL, c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?

• A. INSERT INTO t1 VALUES (100)
• B. INSERT INTO t1 (c1, c2) VALUES (100)
• C. INSERT INTO t1 (c1, c3) VALUES (‘100’, ‘100.00’)
• D. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Answer: B

NEW QUESTION 9
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

• A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
• B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT commandexecuted after the COMMIT command
• C. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT
• D. It finishes the current T1 unit of work and a new one is initiate
• E. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Answer: D

NEW QUESTION 10
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 11
With HADR, which of the following configuration and topology choices provides the highest level of protection
from potential loss of data in a pureScale environment?

• A. Principal standby with SYNC synchronization mode
• B. Auxiliary standby with SYNC synchronization mode
• C. Principal standby with NEARSYNC synchronization mode
• D. Auxiliary standby with SUPERSYNC synchronization mode

Answer: A

Explanation: Standby databases are synchronized with the primary database through log data that is generated on the primary and shipped to the standbys. The standbys constantly roll forward through the logs. You can choose from four different synchronization modes. In order of most to least protection, these are SYNC,
NEARSYNC,
ASYNC, and SUPERASYNC.

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 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 14
Which three facilities are used to control authorization in DB2?

• A. privileges, db2ssh, LBAC credentials
• B. privileges, authority levels, certificates
• C. db2ssh, trusted contexts, authority levels
• D. privileges, authority levels, LBAC credentials

Answer: D

NEW QUESTION 15
Which of the following is TRUE about indexes on column organized tables?

• A. No indexes are allowed
• B. Indexes are only allowed on numeric columns
• C. Indexes are automatically created to enforce unique constraints
• D. An index is only allowed on the synopsis table supporting a column organized table

Answer: A

NEW QUESTION 16
What is the primary use case for creating an index with the RANDOM option on a table?

• A. Maximize performance with OLTP random key queries
• B. Maximize performance when inserting into an expression based index containing the RAND() function
• C. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment
• D. Minimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Answer: C