Unanswered: Any help would be gratefully appreciated!!
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?
Create table mytab
Col1 int not null primary key,
Col4 int not null,
constraint c4 unique (Col4,Col1)
Given the tables:
ID NAME PERSON CITIES
1 Argentina 1 10
2 Canada 2 20
3 Cuba 2 10
4 Germany 1 0
5 France 7 5
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.
Given the table;
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
Given the transaction:
"CREATE TABLE t1 (id INTEGER,CONSTRAINT chkid CHECK (id<100))"
"INSERT INTO t1 VALUES (100)"
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
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
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))