C2090-616 Online Practice Questions and Answers

Below are the SQL statements a DBA is planning to execute on a database:

CREATE TABLE t1 (name VARCHAR (1));

INSERT INTO t1 VALUES (`A'), (`B'), (`C'), (`D');

ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;

What will be the outcome of the last statement?

A. The statement will fail due to variable length character error

B. The statement will fail due to an incompatible data type error

C. The statement will execute successfully and it deletes the character data

D. The statement will execute successfully and it internally converts the character data into ASCII numbers

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

A. DB2 Connect

B. DB2 Runtime Client

C. DB2 Data Server Client

D. DB2 Enterprise Server Edition

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

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

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

What is the maximum precision for the DECIMAL data type?

A. 7

B. 15

C. 23

D. 31

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;

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

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

Given the following statement:

DECLARE GLOBAL TEMPORARY TABLE TEMP1 (

ID INTEGER NOT NULL,

ITEM CHAR(30),

AMOUNT DECIMAL (10,2)

ON COMMIT DELETE ROWS NOT LOGGED;

Which of the following statements are TRUE? (Choose two.)

A. Temp1 table is accessed under schema SESSION

B. Temp1 definition is available for use by other sessions

C. At the end of a transaction, data is deleted automatically

D. Definition of the table Temp1 is stored in database catalog

E. Rows inserted by one session are visible in other sessions