Your success in IBM C2090-616 is our sole target and we develop all our C2090-616 braindumps in a way that facilitates the attainment of this target. Not only is our C2090-616 study material the best you can find, it is also the most detailed and the most updated. C2090-616 Practice Exams for IBM {category} C2090-616 are written to the highest standards of technical accuracy.
NEW QUESTION 1
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 2
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 3
Which database object can be locked explicitly?
- A. Row
- B. View
- C. Index
- D. Table
Answer: D
NEW QUESTION 4
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 5
Which of the following authorities is sufficient for connecting to a database?
- A. SQLADM
- B. CONNECT
- C. DATAACESS
- D. ACCESSCTRL
Answer: D
NEW QUESTION 6
Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike. Mike grants SELECT privilege to Jeff.
Eddie revokes SELECT privilege from Mike. What will happen to Jeff’s SELECT privilege?
- A. Jeff’s SELECT privilege will be revoked
- B. Jeff’s SELECT privilege will be retained
- C. Jeff’s SELECT privilege will be retained only if he has ACCESSCTRL authority
- D. Jeff’s SELECT privilege will be retained only if Eddie has ACCESSCTRL authority
Answer: A
NEW QUESTION 7
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 8
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 9
Which of the following is fundamental to BLU acceleration?
- A. pureScale
- B. Column organized tables
- C. Multidimensional clustering
- D. Purchasing new hardware that is compatible with BLU acceleration and compression
Answer: B
NEW QUESTION 10
A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)
- A. Easy scalability
- B. Management of very large data sets
- C. Continuously available dataset solution
- D. Increased throughput of many concurrent short running queries
- E. Faster response time of long-running or complex queries with I/O spread across many computers
Answer: BE
NEW QUESTION 11
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 12
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 13
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 14
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 15
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
- A. Direct Standard Edition
- B. Enterprise Server Edition
- C. Workgroup Server Edition
- D. DB2 Direct Advanced Edition
- E. Advanced Enterprise Server Edition
Answer: BC
NEW QUESTION 16
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 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 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 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
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 21
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 22
......
Thanks for reading the newest C2090-616 exam dumps! We recommend you to try the PREMIUM Certshared C2090-616 dumps in VCE and PDF here: https://www.certshared.com/exam/C2090-616/ (63 Q&As Dumps)
