Exam Code: C2090-616
Exam Name: DB2 11.1 Fundamentals for LUW
Updated: Apr 29, 2024
Q&As: 63
At Passcerty.com, we pride ourselves on the comprehensive nature of our C2090-616 exam dumps, designed meticulously to encompass all key topics and nuances you might encounter during the real examination. Regular updates are a cornerstone of our service, ensuring that our dedicated users always have their hands on the most recent and relevant Q&A dumps. Behind every meticulously curated question and answer lies the hard work of our seasoned team of experts, who bring years of experience and knowledge into crafting these premium materials. And while we are invested in offering top-notch content, we also believe in empowering our community. As a token of our commitment to your success, we're delighted to offer a substantial portion of our resources for free practice. We invite you to make the most of the following content, and wish you every success in your endeavors.
Experience Passcerty.com exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your IBM C2090-616 exam.
Instant download
Latest update demo according to real exam
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 revoked. DB2INST3 will retain both roles.
Which of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?
A. pureScale
B. auto reorg
C. BLU acceleration
D. Self tuning memory manager
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
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.
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 command executed 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 initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed.
Viewing Page 3 of 3 pages. Download PDF or Software version with 63 questions