Page 1 of 1

DB2 Interview Questions -3

PostPosted: Wed Dec 08, 2010 4:10 pm
by Ravi Teja
If i am incorrect,please correct me



(1) What is physical storage of Date and Time in DB2?

a) 4 and 4 bytes
b) 4 and 3 bytes
c) 3 and 10 bytes
d) 3 and 3 bytes


(2) What does DBRM stand for?

a) Database Request Model
b) Database Resource Model
c) Database Request Module
d) Data Requisition Module



(3) Declare CURSOR is an executable statement

a) Yes
b) No
c) Either A or B
d) Cannot define


(4) What is 'LIKE' used for in WHERE clause?

a) To match date field
b) LIKE is used for partial string matches
c) Used to both A and B
d) None of the above



(5) Given that table T1 has defined on it a primary key, three foreign keys, four indexes, two check constraints, three views, and an alias the following
CREATE TABLE statement executed successfully;
CREATE TABLE a1 LIKE TABLE t1
Which two of the following statements describe how table A1 is created?


a) Check constraints on table T1 were copied to table A1.
b) Indexes of the same description as those on table T1 were automatically created table A1
c) Table A1 contains columns of the same names, data types and null characteristics as table T1
d) The primary key definition on table T1 was copied to table A1



(6) Which two of the following result from a successful ROLLBACK statement?

a) The current unit of work is restarted.
b) Tables in LOAD PENDING for the current unit of work are released.
c) Existing database connections are released
d) Locks held by the current unit of work are released


(7) USERA needs to be able to read rows from TAB1 and add new rows to TAB1.
Which of the following statements will give USERA only the needed privileges?


a) GRANT READ, INSERT ON TABLE tab1 TO usera
b) GRANT SELECT, ALTER ON TABLE tab1 TO usera
c) GRANT READ, ALTER ON TABLE tab1 TO usera
d) GRANT SELECT, INSERT ON TABLE tab1 TO usera


(8) What is the default type in isolation

a) Repeatable read
b) Read stability
c) Cursor stability
d) Uncommitted read


(9) What is the maximum volume in storage group?

a) 126
b) 123
c) 133
d) 136


(10) What is IMAGECOPY ?

a) Full back of Table space which can be used in recovery
b) Part of back up in database which can be used in recovery
c) partial backup of a DB table which can be used in recovery
d) It is full backup of a DB2 table which can be used in recovery


(11) SQLCODE -205 describes

a) Object already exists
b) No primary key mentioned
c) Column name is not column of table
d) None of the above


(12) SQLCODE -181 describes

a) does not have Privileged to perform operation
b) String representation of DATE/TIME is invalid
c) Duplicate object
d) Data type mismatch


(13) SQLCODE -183 describes

a) String representation of date is invalid.
b) DB2 connection error
c) Not a valid range
d) None of the above

If i am incorrect,please correct me