Online Access Free 000-544 Exam Questions

A user with Security Administrator (SECADM) authority executes the following statements:

If user USER2 queries the table S.TAB1, how many rows will be returned?

• A.2
• B.3
• C.1
• D.0

Table T1 was created by executing the following statement:

Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1. The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current statics exist for the table and index, which index will provide optimal performance for this query?

• A.CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)
• B.CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)
• C.CREATE INDEX idx1 ON t1 (deptno, empno)
• D.CREATE INDEX idx1 ON t1 (deptno)

Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node.
Explanation:
The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

• A.CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS
• B.CATALOG DCS DATABASE dsample AS db2t
• C.CATALOG DCS DATABASE db2t AS dsample
• D.CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

• A.In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
• B.In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.
• C.The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
• D.The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.

Which command CANNOT be used to create the compression dictionary for a table?

• A.INSPECT
• B.IMPORT
• C.RUNSTATS
• D.LOAD