C2090-616 Free Practice Test

If you are already connected to a database, what does running the following statement do? Db2 CONNECT

1. A. Prompts you for the database name or alias
2. B. Returns information about the current server
3. C. Prompts you for the authentication information
4. D. Returns an error, because you provided no database or alias

Correct Answer: B

Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN ‘000020’ and ‘000070’ Result:
If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > ‘000020’ AND empno ‘000070’

1. A. 1
2. B. 3
3. C. 5

Correct Answer: C

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

1. A. Concurrency may be improved
2. B. Lock escalation will be prevented
3. C. Query performance will be reduced
4. D. The number of locks for the same workload will be reduced

Correct Answer: A

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?

1. A. The statement will fail due to variable length character error
2. B. The statement will fail due to an incompatible data type error
3. C. The statement will execute successfully and it deletes the character data
4. D. The statement will execute successfully and it internally converts the character data into ASCII numbers

Correct Answer: C

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

Correct Answer: A