Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is calleda.Lost Updateuncommitted dependencyinfinite loopd.Deadlocke.With holdDeadlock
Latest Answer: DeadLock ...
a.No rows were selected.b.DB2 not operationalc.SQL completed successfully.d.SQL cannot be executed because program not bound.e.No SQL statements were input.SQL completed successfully.
Latest Answer: sql completed successfully ...
a.Database Restrict Modelb.Database Resurrect Modelc.Database Request Moduled.Database Reference Modulee.Database Restrict ModuleDatabase Request Module
Latest Answer: Database Request module ...
Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately
Latest Answer: DB2 table may have many fields, All the users are not intended to see some fields. To customise this, Views are created for DB2 tables. A single DB2 tables can have any no.of views. ...
a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor
Latest Answer: DBD stands for database descriptor ...
A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String
Thread
a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL statements cannot be executed unless bind is performed.e.The
Latest Answer: e. access path created by bind command. ...
a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2.
All the above can access DB2.
Latest Answer: all the given environments caln access db2 ...
Latest Answer: Open cursor is also executable ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
