IBM C2090-616 DB2 11.1 Fundamentals for LUW Online Training
IBM C2090-616 Online Training
The questions for C2090-616 were last updated at Oct 31,2025.
- Exam Code: C2090-616
- Exam Name: DB2 11.1 Fundamentals for LUW
- Certification Provider: IBM
- Latest update: Oct 31,2025
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
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
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
Which database object can be locked explicitly?
- A . Row
- B . View
- C . Index
- D . Table
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
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
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
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
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
Which edition of DB2 LUW has been discontinued in v11.1?
- A . DB2 Developer Edition
- B . DB2 Express Server Edition
- C . DB2 Enterprise Server Edition
- D . DB2 Connect Enterprise Server Edition
Latest C2090-616 Dumps Valid Version with 63 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
