Skip to main content

C2090-616 Real Exam Questions

DB2 11.1 Fundamentals for LUW

62 questions available · Page 1 of 7

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Which of the following editions of DB2 include support for Federation with Oracle database?

  1. A

    DB2 Express-C

  2. B

    DB2 Developer Edition

  3. C

    DB2 Enterprise Server Edition

  4. D

    DB2 Workgroup Server Edition

Show answer and explanation

Correct answer: C

Question 2 Single choice

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

  1. A

    32672 bytes

  2. B

    65344 bytes

  3. C

    98016 bytes

  4. D

    130688 bytes

Show answer and explanation

Correct answer: A

Question 3 Single choice

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

  1. A

    Sequence

  2. B

    Row Identifier

  3. C

    Identity Column

  4. D

    Insert time clustering table

Show answer and explanation

Correct answer: A

Question 4 Single choice

Which of the following authorities is sufficient for connecting to a database?

  1. A

    SQLADM

  2. B

    CONNECT

  3. C

    DATAACESS

  4. D

    ACCESSCTRL

Show answer and explanation

Correct answer: D

Question 5 Single choice

Which edition of DB2 LUW has been discontinued in v11.1?

  1. A

    DB2 Developer Edition

  2. B

    DB2 Express Server Edition

  3. C

    DB2 Enterprise Server Edition

  4. D

    DB2 Connect Enterprise Server Edition

Show answer and explanation

Correct answer: B

Question 6 Single choice

Which of the following set operators can be used to find all rows that are common in 2 queries?

  1. A

    UNION

  2. B

    UNION ALL

  3. C

    EXCEPT ALL

  4. D

    INTERSECT ALL

Show answer and explanation

Correct answer: B

Question 7 Single choice

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?

  1. A

    INSERT INTO t1 VALUES (100)

  2. B

    INSERT INTO t1 (c1, c2) VALUES (100)

  3. C

    INSERT INTO t1 (c1, c3) VALUES (`100', `100.00')

  4. D

    INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Show answer and explanation

Correct answer: B

Question 8 Single choice

Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

  1. A

    DB2 Connect

  2. B

    DB2 Runtime Client

  3. C

    DB2 Data Server Client

  4. D

    DB2 Enterprise Server Edition

Show answer and explanation

Correct answer: A

Question 9 Single choice

Which of the following statements about stored procedures is TRUE?

  1. A

    Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

  2. B

    The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

  3. C

    There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

  4. 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

Show answer and explanation

Correct answer: B

Question 10 Single choice

What is the purpose of a role?

  1. A

    To define exactly what a specific user can and cannot do within a particular database once they have been authenticated.

  2. B

    To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

  3. C

    To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles.

  4. D

    To assign one or more users that need to run local DB2 applications and tools on a particular server to
    the DB2ADMNS or the DB2USERS group.

Show answer and explanation

Correct answer: A