DB2 Continued...

1.      From the fallowing statements choose the right option

A. Double can be used fro numbers ranging from 23digits to 53 digits.

 B. Size of the doble data type is 8 bytes.

a)      Only A is true and B is False.                                                

b)      Both A & B are Flase.

c)       A is false and B is Also false.

d)      Both A and B are true.

2.       Whats is Meant by cartesian Product.

a.       Its a row from the every combination of the joining tables.

b.      Its a row from ...

c.       Its a roe from ..

d.      Like this   4 options were given.

3.       The question was bit easy  and asked on Incremental Copy of the table(which kind of copy is used ?  they  have mentioned the situation.

4.       Q was like this defined on table create statements with  create stmt was given and one of the columns is defined as  ‘Blo clob(1000) loggedpicture Blob(24M)’ . Given the two state ments on this declarations to identify their correctenes. The question was asked like “if the value of the above column is changed will it going to log each of the changes to the column”.

5.       Foriegn Key

a)       Can not be Null.

b)      Must Match with the Unique Key of the Parent Table.(they have not mentioned as primary key.. and i did not go with this answer).

c)       Can have duplicates.

d)      None of these. 

6.       How to close the Access to a User

a)      SQL Remove

b)      SQL reovke

c)       One more choice

d)      Both A and B.

7.       For this question i could not get the right answer,

On a workstation platform  which of the fallowing locks can not be obtained.

Page.

Table.

Row.

All of the above.(i guess it should be none of the above).

8.       Access Startergy for a Static SQL statement is stored in the package permanently be a bind process. Give True or  False as choices.

9.       Using ‘Alter Table’ Statement its  not possible to (tricky qn ).

a.       Add a new Column.

b.      Alter the columnn Constraints.

c.       Alter the name of the column.

d.      Drop the Column.

Whats your Answer reply me?

When a  Drop Table command is given on a table choose the right statements

A: Table data is deleted from the table.

B:Catalogue Tables are updated. 

Whhich of the SQl tool Supports ‘Format Report Option’ given following choice to select.

a)      SPUFI

b)      Command Center

c)       QMF.

d)      One more tool name was given.