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?
