I) Index Space are created automatically when Index are created. II) Table Space are created automatically when Tables are created. Of the above statementBoth are True( I ) is Only True( II) is only TrueBoth
Latest Answer: You need tablespace created when you want to create index or Table.We cant create the table/Index in the table Spaces, thus both are false ...
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space
Single index only
Latest Answer: There is nothing called Indexspace but the term used to define the tablespace having only indexes with in it. ...
The Cursor can be Declared in Working storage sectionLinkage sectionInput-Output section.
Working storage section
Latest Answer: Cursor could be declared in both Working storage section od data division & procedure division. ...
Table1 has the following data – Book Chapter ---------------------------- DB2 Retrieval DB2 Updates DB2 Locking COBOL File processing COBOL Working storage JCL Job statement CICS Maps What
The operating system in which DB2 runs isa.OS/2b.UNIXc.XENIXd.MVSe.None of the above
MVS
DB2 is aa.Database/Data Communication Systemb.Databasec.Relational Database Management Systemd.Programming Languagee.Operating systemRelational Database Management System
Latest Answer: c)Relational Database Management System ...
Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36
Latest Answer: It will retreive all rows from both the tables. i.e 6 rows from table1 and 6 rows from table2 will be retrieved and arranged horizontally. so it will have 6+6=12 columns horizontally. ...
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
What does WITH HOLD option do ?forces cursor to close after commitb.Keeps cursor open after commitc.Does not allow cursor to close till all rows are fetchedd.Locks the cursore.None of the aboveKeeps cursor
Latest Answer: Closes the cursor after commit operation is done ...
?a.Check if equal to NULLb.Use null indicator, 0 indicates nullc.Use null indicator, -1 indicates nulld.Use null indicator, -2 indicates nulle.None of the above.Use null indicator, -1 indicates null
Latest Answer: hi,-1 indicates null indicator.Regards,pradeep ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
