Practice Questions

Question 1

When attempting to connect to a database stored on a AIX server from a client workstation, the following message is displayed:

SQL1013N The database alias name or database name "TEST_DB" could not be found.

Which of the following is NOT a valid reason why this message was generated?

• A. The server's database directory does not contain an entry for the database TEST_DB

• B. The client's database directory does not contain an entry for the database TEST_DB

• C. The client's node directory does not contain an entry for the server

• D. The client's DB2 version is not compatible with the server's DB2 version

Question 2

Given the following command:

CREATE DATABASE TEST_DB ON /home/db2data/db_dir USER TABLESPACE MANAGED BY DATABASE USING (FILE '/home/db2data/ user ' 16777215)

How many SMS tablespaces are created?

• A. 1

• B. 2

• C. 3

• D. 4

Question 3

Which of the following are NOT stored in the system catalog tables?

• A. SQL statements used to create views

• B. SQL statements used to create triggers

• C. SQL statements used to create constraints

• D. Table names

Question 4

Given the following table:

TABLE1
C1	C2
(INTEGER)	(INTEGER)
1	2
2	3

Which two of the following could be used to automatically increment the value of C1 whenever a new row is added to table TABLE1?

• A. A sequence

• B. An index

• C. A view

• D. A trigger

• E. A transition variable

Question 5

Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?

• A. An alias named T1 that references table TABLE1

• B. A view named T1 that references table TABLE1

• C. A schema named T1 that references table TABLE1

• D. An alias named T1 that references view V1 that references table TABLE1

Question 6

Communications is being manually established between a Windows 2000 client and a Solaris server. Which of the following pieces of information is needed?

• A. The system administrator's user ID and password

• B. The client workstation name

• C. The server's operating system version

• D. The hostname

Question 7

Database MY_DB has just been created on a Windows 2000 server. Which of the following statements is accurate?

• A. Containers used by USERSPACE1 cannot be used by other tablespaces.

• B. Buffer pool IBMDEFAULTBP can hold up to 2000 4k pages.

• C. The system catalog must be manually created before the database can be used.

• D. Sequences can now be created in the SYSFUN schema.

Question 8

Given the following information:

Protocol: TCP/IP

Port Number: 5000

Host Name: DB_SERVER

Database Name: TEST_DB

Database Server Platform: Linux

Which of the following will allow a client to access the database stored on the server?

• A. CATALOG DATABASE test_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000 OSTYPE LINUX

• B. CATALOG TCPIP NODE 5000 REMOTE SERVER db_server OSTYPE LINUX

  CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER

• C. CATALOG TCPIP NODE db_server REMOTE db_server SERVER 5000 OSTYPE LINUX

  CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER

• D. CATALOG TCPIP NODE db_server REMOTE db_server PORT 5000 OSTYPE LINUX

  CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER

Question 9

Assuming DB2 UDB is installed on an AIX system, which of the following commands provides the information needed to connect to a local database?

• A. CATALOG NODE

• B. CATALOG DCS

• C. CATALOG DATABASE

• D. CATALOG ODBC DATA SOURCE

Question 10

Which of the following events will NOT cause a trigger to be activated?

• A. A select operation

• B. An insert operation

• C. An update operation

• D. A delete operation