Monday, October 28, 2013

CHAPTER 5 (WORKING WITH DB2 TABLE,VIEWS,AND INDEXES) DB2 9 Exam 730 certification Dumps

Q.Which of the following is a valid DB2 data type?
A. NUMBER
B. INTERVAL
C. BYTE
D. NUM

Q.Which of the following DB2 data types does NOT have a fixed length?
A. INT
B. CHAR
C. XML
D. DOUBLE



Q.Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
A. CREATE DISTINCT TYPE currency AS NUMERIC(7,2)
B. CREATE DISTINCT TYPE currency AS SMALLINT
C. CREATE DISTINCT TYPE currency AS BIGINT
D. CREATE DISTINCT TYPE currency AS DOUBLE

Q.Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
A. BLOB
B. CLOB
C. DBCLOB
D. GRAPHIC

Q.Which of the following DB2 data types can NOT be used to create an identity column?
A. SMALLINT
B. INTEGER
C. NUMERIC
D. DOUBLE


Q.Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?
A. "<employee />"
B. "<name>John Doe</name>"
C. "<?xml version='1.0' encoding='UTF-8' ?>"
D. "<p></p>"

 

Q.Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?
A. Character Large Object
B. Time
C. Varying-Length Character String
D. Timestamp
 

Q.Given the requirements to store customer names, billing addresses, and telephone numbers, which of the following would be the best way to define the telephone number column for a table if all customers were located in the same country?
PHONE    CHAR(15)
PHONE    VARCHAR(15)
PHONE    LONG VARCHAR
PHONE    CLOB(1K)


Q. Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?
A. "<employee />"
B. "<name>John Doe</name>"
C. "<?xml version='1.0' encoding='UTF-8' ?>"
D. "<p></p>"


Q. Which two of the following are optional and do not have to be specified when creating a table?
A. Table name
B. Column name
C. Default constraint
D. Column data type
E. NOT NULL constraint


Q.Which of the following is a NOT a valid reason for defining a view on a table?
A. Restrict users' access to a subset of table data
B. Ensure that rows inserted remain within the scope of a definition
C. Produce an action as a result of a change to a table
D. Provide users with an alternate view of table data


Q.Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
A. TABLE2 will have the same column names and column data types as TABLE1
B. TABLE2 will have the same column defaults as TABLE1
C. TABLE2 will have the same nullability characteristics as TABLE1
D. TABLE2 will have the same indexes as TABLE1.
E. TABLE2 will have the same referential constraints as TABLE1


Q.  If the following SQL statements are executed:
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
                   name  VARCHAR(25));

CREATE TABLE tab2 (empid   SMALLINT,
                   weekno  SMALLINT,
                   payamt  DECIMAL(6,2),
    CONSTRAINT const1 FOREIGN KEY (empid)
        REFERENCES taba(id) ON UPDATE NO ACTION);


Which of the following statements is true?
A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
B. The updating of values in the ID column of table TAB1 is not allowed
C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well

No comments:

Post a Comment