-
DB2 Cursor Stablity
i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency1 Both are True2 i) Is Only True3 ii) is only True4 Neither is TrueBoth are True
-
DB2 Storage groups
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices All of the Choices
-
What is the correct sequence of working with the cursors in a COBOL/DB2 program
1 Declare / fetch / open / close2 Open / Declare / fetch /close3 Declare / open / fetch /close4 None of the aboveDeclare / open / fetch /close
-
DB2 memory structures
What are memory structures used to handle multiple row selections at a time 1 Cursors2 Host Variables3 Indicator Variable4 SQLCACursors
-
DB2 Indexes
i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column. 1 Both are True2 i) is only True3 ii) is Only True4 Neither is True
-
DB2 Synonyms
i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False
-
DB2 Index Storate Format
Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree B - Tree format
-
DB2 IRLM module
IRLM is a module of DB2 which does1 Logging2 Thread creation3 Concurrency control using locking4 both logging and thread creation
-
When do you open cursor before Fetching
i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both are True2 i) is only True3 ii) is False Both are True
-
DB2 Index and Table Space
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 are False( I ) is Only True
-
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
-
DB2 SQL Query
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 will be the result of the querySELECT BOOK FROM TABLE1 GROUP BY BOOK HAVING COUNT(*) > 1a.DB2, COBOL, JCL, CICSb.DB2, COBOLc.JCL, CICSd.DB2, CICSe.JCL, COBOLDB2, COBOL
-
DB2 Operating System
The operating system in which DB2 runs isa.OS/2b.UNIXc.XENIXd.MVSe.None of the above MVS
-
What kind of Database DB2 is ?
DB2 is aa.Database/Data Communication Systemb.Databasec.Relational Database Management Systemd.Programming Languagee.Operating systemRelational Database Management System
-
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
-
DB2 WITH HOLD option
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 open after commit
-
How do we know that NULL value has been selected for a nullable column
?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
-
DB2 transactions
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
-
What does zero SQLCODE indicate
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.
-
What is the full form of DBRM ?
a.Database Restrict Modelb.Database Resurrect Modelc.Database Request Moduled.Database Reference Modulee.Database Restrict ModuleDatabase Request Module
-
DB2 View Purpose
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 for user copye.To get data from multiple tables To store data separately for user copy
-
What is DBD ?
a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor
-
DB2 control structure
A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String Thread
-
Which of the following is not true about Bind ?
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 program should determine the db2 access path before the bind is performed.The program should determine the db2 access path before the bind is performed.
-
Which of the environments cannot access DB2
a.TSOb.CICSc.IMSd.BATCHe.All the above can access DB2. All the above can access DB2.