Hi All. Im new to this site and am in the process of sitting the DB2 V8.1 Database admin exams. Having a few issues with the following questions. If anyone can throw some light on the issue I would really appreciate it.

How many indexes will be created by the following statement?


Question (1)
Create table mytab
(
Col1 int not null primary key,
Col2 char(64),
Col3 char(32),
Col4 int not null,
constraint c4 unique (Col4,Col1)
)

A. 0

B. 1

C. 2

D. 3

E. 4


Question (2)
Given the tables:

COUNTRY
ID NAME PERSON CITIES
1 Argentina 1 10
2 Canada 2 20
3 Cuba 2 10
4 Germany 1 0
5 France 7 5


STAFF
ID LASTNAME
1 Jones
2 Smith

Which of the following statements removes the rows from the COUNTRY table
that have PERSONS in the STAFF table?

A. DELETE FROM country WHERE id IN (SELECT id FROM staff)

B. DELETE FROM country WHERE id IN (SELECT person FROM staff)

C. DELETE FROM country WHERE person IN (SELECT id FROM staff)

D. DELETE FROM country WHERE person IN (SELECT person FROM staff)

Select the best answer.

Question (3)
Given the table;

STAFF
ID LASTNAME
1 Jones
2 Smith

When issuing the query SELECT * FROM staff, the row return order will be based on which of the following?

A. An ambiguous order

B. The primary key order

C. The order that the rows were inserted into the table

D. The values for the ID column, then the LASTNAME column

Question (4)

Given the transaction:

"CREATE TABLE t1 (id INTEGER,CONSTRAINT chkid CHECK (id<100))"
"INSERT INTO t1 VALUES (100)"
"COMMIT"

Which of the following results from the transaction?

A. The row is inserted with a NULL value

B. The row is inserted with a value of 100

C. The row insertion with a value of 100 is rejected

D. The trigger called chkid is fired to validate the data

Question (5)
Which of the following CANNOT have an autocommit setting?

A. Embedded SQL

B. The Command Center

C. The Command Line Processor

D. The DB2 Call Level Interface


Question (6)
Which of the following DDL statements creates a table where employee ids are unique?

A. CREATE TABLE t1 (employid INTEGER)

B. CREATE TABLE t1 (employid UNIQUE INTEGER)

C. CREATE TABLE t1 (employid INTEGER NOT NULL)

D. CREATE TABLE t1 (employid INTEGER NOT NULL, primary key (employid))


Thanks

Hi,

First of all you should read Must Read before posting. There are a lot of tips how to write the right thread name, etc.

You can also read certification or certification.

Hope this helps,
Grofaty