YouTube Icon

Interview Questions.

Ibm Db2 Placement Papers - Ibm Db2 Interview Questions and Answers - Jul 28, 2022

fluid

Ibm Db2 Placement Papers - Ibm Db2 Interview Questions and Answers

Q1. What Is The Difference Between Join And Union?

Join is used to retrive records from extraordinary tables using a single sq. Declaration.Union is used to combine the outcomes of  or greater sq. Querries.

Q2. What Is A Page?

This is the unit of storage within a desk area or index area this is accessed by way of DB2.

Q3. What Does Currentdata Option In Bind Indicate?

CURRENTDATA option ensures block fetch whilst selecting rows from a table. In DB2V4 the default has been modified to NO. Therefore it is important to alternate all of the bind cards with CURRENTDATA(YES) that's default in DB2V3 & in advance to CURRENTDATA(NO).

Q4. What Is An Alias?

It is an trade name that may be utilized in SQL statements to consult a desk or view within the identical or faraway DB2 subsystem.

Q5. What Will The Commit Accomplish?

COMMIT will allow information changes to be permanent. This then lets in the records to be accessed with the aid of different units of work. When a COMMIT occurs, locks are freed so different programs can reference the simply committed facts.

Q6. What Information Can You Find In Sysibm.Syslinks Table?

The SYSIBM.SYSLINKS table incorporates statistics about the hyperlinks between tables created by means of referential constraints.

Q7. What Are The Max. & Min. No. Of Partitions Allowed In A Partition Tablespace?

Minimum is 4.Most is 64.

Q8. In Which Column Of Which Db2 Catalog Would You Find The Length Of The Rows For All Tables?

In the RECLENGTH column of SYSIBM.SYSTABLES

Q9. When Does The Sql Statement Gets Executed When You Use Cursor In The Application Programming ?

Sq. Statement gets performed when we open cursor.

Q10. What Is A Db2 Catalog?

The DB2 catalog is a fixed of tables that comprise statistics about all the DB2 items(tables, perspectives, pl and so forth.).

Q11. What Is The Command Used By Tso Users To Invoke Db2?

DSN RUN

Q12. What Is A Data Page?

A data page is a unit of retrievable statistics, either 4K or 32K (relying on how the desk is defined), containing consumer or catalog statistics.

Q13. What Is Meant By The Attachment Facility?

The attachment facility is an interface among DB2 and TSO, IMS/VS, CICS, or batch deal with spaces. It permits utility packages to get admission to DB2.

Q14. How Do U Achieve Record Level Locking In Db2 Versions When Record Level Locking Is Not Allowed?

By having the duration of the report extra than that of a page!

Q15. What Is The Size Of A Data Page?

4K to 8K

Q16. What Is The Format (internal Layout) Of "timestamp"?

This is a seven component price that includes a date (yymmdd) and time(hhmmss and microseconds).

Q17. What Is The Sql Communications Area And What Are Some Of Its Key Fields?

It is a statistics shape that need to be blanketed in any host-language program the use of SQL. It is used to pass remarks about the square operations to this system. Fields are go back codes, blunders messages, dealing with codes and warnings.

Q18. Where Would You Find Information About The Type Of Database Authority Held By The User?

SYSIBM.SYSDBAUTH.

Q19. Explain What A Plan Is?

Plan is a DB2 object (produced in the course of the bind system) that friends one or greater database request modules with a plan name.

Q20. What Is Join And Different Types Of Join?

The ability to sign up for rows and combaine data from  or greater tables is one of the most effective capabilities of relational device.Three kind of joins:

Equi-join

Non-equijoin

self-join.

Q21. What's The Percentage Free Space ?

ZERO

Q22. In A Db2-cics Program Which Is Acts As Co-ordinator And Which Is Participant?

DB2 - participant CICS- coordinator

Q23. What Is The Name Of The Default Db2 Catalog Database?

DSNDB06

Q24. What Is The Function Of The Data Manager?

The Data Manager is a DB2 element that manager the physical databases. It invokes other system components, as vital, to carry out specific features which includes locking, logging, and bodily I/O operations (inclusive of seek, retrieval, replace, and index maintenance).

Q25. What Is The Function Of Buffer Manager?

The buffer supervisor is the DB2 thing accountable for physically trferring statistics between an external medium and (digital) garage (performs the actual I/O operations). It minimizes the amount of bodily I/O clearly accomplished with sophisticated buffering techniques(i.E., study-beforehand buffering and appearance-aside buffering).

Q26. Maxx Number Of Columns In A Db2 Table?

224

Q27. What Is Pagespace?

Pagespace refers to either to an unpartitioned table, to an index space, or to a unmarried partition of a partitioned desk of index area.

Q28. What Is A Corelated Subquerry?

In a subquerry, if the outer querry reffers returned to the outcome of innerquerry it's far referred to as corelated subquerry. That's why the outer querry is evaluated first in contrast to an normal subquerry.

Q29. What Does Dsndb07 Database Do?

DSNDB07 is where DB2 does its sorting. It includes DB2’s sort paintings area and outside garage.

Q30. What Should Be Specified Along With A Cursor In Order To Continue Updating Process After Commit?

With Hold option.

Q31. The Only Place Of Vsam Ksds In Db2 Is?

BSDS is a VSAM KSDS.

Q32. Can All Users Have The Privilage To Use The Sql Statement Select * (dml)?

NO THE USER SHOULD BE GRANTED PRIVILAGE TO USE IT.

Q33. Can You Define An Index If The Table Size Less Than 10 Pages?

NO

Q34. What's The Best Locksize That You Could Use When You Create A Tablespace?

The wer is Locksize = ANY.Unless you are Sure what's the Purpose of tablespace ie.,Read-only or R/W.If you operate lock size =any, Db2 could robotically determine what form of locks it must use.

Q35. What Is Meant By Concurrency?

Concurrency is what allows multiple DB2 software method to get right of entry to the same facts at essentially the same time. Problems may also occur, inclusive of misplaced updates, get entry to to uncommitted statistics, and un-repeatable reads.

Q36. What Will The Db2 Optimizer Do?

The optimizer is a DB2 issue that approaches SQL statements and selects the get admission to paths.

Q37. Describe What A Storage Group(stogroup) Is?

A STOGROUP is a named series of DASD volumes to be used by tablespaces and index areas of databases. The volumes of STOGROUP must be of the same device type.

Q38. What Is Declaration Generator(dclgen)?

DCLGEN is a facility that is used to generate SQL statements that describe a desk or view. These table or view descriptions are then used to check the validity of different SQL statements at precompile time. The table or view proclaims are used by the DB2I utility DCLGEN to build a bunch language structure, that is utilized by the DB2 precompiler to confirm that correct column names and data kinds had been distinctive within the SQL statement.

Q39. What Are The Functions Of Bind?

BIND specially plays two things syntax checking and authorization checking.It binds collectively all packages into an utility plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its characteristic is to determine the most suitable get entry to strategy.

Q40. What Is Meant By Repeatable Read?

When an utility program executes with repeatable examine safety, rows referenced via this system can’t be changed through different applications till this system reaches a devote factor.

Q41. What Is A Resource Control Table(rct)? Describe Its Characteristics.

The RCT is a table that is described to a DB2/CICS vicinity. It includes control traits which might be assembled via the DSNCRCT macros. The RCT matches the CICS traction ID to its related DB2 authorization ID andplan ID(CICS attachment facility).

Q42. Where Could You Look If You Had A Question About Whether A Column Has Been Defined As An Index?

This information may be observed in SYSIBM.SYSINDEXES.

Q43. Max. No Of Rows Per Page?

127

Q44. What Is A Host Variable?

This is a records object that is used in an SQL assertion to acquire a price or to supply a price. It have to be preceded with the aid of a colon (:) to tell DB2 that the variable isn't always a column name.

Q45. Name The Different Types Of Table Spaces?

@Simple Table Space@Segmented Table Space and@Partitioned Table Space

Q46. What Are The Three Types Of Page Locks That Can Be Held?

Exclusive, replace, and share.

Q47. What Is A Db2 Bind?

Bind is a method that builds “access paths” to DB2 tables. A bind makes use of the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input and produces an application plan. It also tests the person’s authority and validates the SQL statements in the DBRM(s).

Q48. Where Are Pl Stored?

Each plan is defined uniquely in the SYSIBM.SYSPLANS table to correspond to the traction (s) that are to execute that plan.

Q49. What Is The Maximum Number Of Tables That Can Be Joined ?

Fifteen

Q50. What's The Error Code For Unique Index Voilation?

-803




CFG