Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Talking 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?


    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •