DB2 Universal Database V8.1 Certification Exam 700 Study Guide

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

Related

Категории