-
Move X TO XX
A PIC X(1) value A.B PIC X(2) VALUE SPACES.IF MOVE A TO B. WHAT IS THE VALUE OF B. Is it ' A' OR 'A '.
-
-
DB2 Index Space
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space Single index only
-
DB2 Cursor Declaration
The Cursor can be Declared in Working storage sectionLinkage sectionInput-Output section. Working storage section
-
How many rows will the query return ?
Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36
-
DB2 Table Delete Question
Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is deleted, the corresponding row from T2 also be deleted. Which option can be used? a.ON DELETE RESTRICTb.ON DELETE CASCADEc.ON DELETE SET NULLd.ON DELETE CHILDe.ON DELETE MATCHON DELETE CASCADE
-
-
-
-
-
-
-