Interview Questions

AJAX Interview Questions Android Interview Questions Angular 2 Interview Questions AngularJs Interview Questions Apache Presto Interview Questions Apache Tapestry Interview Questions Arduino Interview Questions ASP.NET MVC Interview Questions Aurelia Interview Questions AWS Interview Questions Blockchain Interview Questions Bootstrap Interview Questions C Interview Questions C Programming Coding Interview Questions C# Interview Questions C++ Interview Questions Cakephp Interview Questions Cassandra Interview Questions CherryPy Interview Questions Clojure Interview Questions Cobol Interview Questions CodeIgniter interview Questions CoffeeScript Interview Questions Cordova Interview Questions CouchDB interview questions CSS Buttons Interview Questions CSS Interview Questions D Programming Language Interview Questions Dart Programming Language Interview Questions Data structure & Algorithm Interview Questions DB2 Interview Questions DBMS Interview Questions Django Interview Questions Docker Interview Questions DOJO Interview Questions Drupal Interview Questions Electron Interview Questions Elixir Interview Questions Erlang Interview Questions ES6 Interview Questions and Answers Euphoria Interview Questions ExpressJS Interview Questions Ext Js Interview Questions F# Interview Questions Firebase Interview Questions Flask Interview Questions Flex Interview Questions Fortran Interview Questions Foundation Interview Questions Framework7 Interview Questions FuelPHP Framework Interview Questions Go Programming Language Interview Questions Google Maps Interview Questions Groovy interview Questions GWT Interview Questions Hadoop Interview Questions Haskell Interview Questions Highcharts Interview Questions HTML Interview Questions HTTP Interview Questions Ionic Interview Questions iOS Interview Questions IoT Interview Questions Java BeanUtils Interview Questions Java Collections Interview Questions Java Interview Questions Java JDBC Interview Questions Java Multithreading Interview Questions Java OOPS Interview Questions Java Programming Coding Interview Questions Java Swing Interview Questions JavaFX Interview Questions JavaScript Interview Questions JCL (Job Control Language) Interview Questions Joomla Interview Questions jQuery Interview Questions js Interview Questions JSF Interview Questions JSP Interview Questions KnockoutJS Interview Questions Koa Interview Questions Laravel Interview Questions Less Interview Questions LISP Interview Questions Magento Interview Questions MariaDB Interview Questions Material Design Lite Interview Questions Materialize CSS Framework Interview Questions MathML Interview Questions MATLAB Interview Questions Meteor Interview Questions MongoDB interview Questions Moo Tools Interview Questions MySQL Interview Questions NodeJS Interview Questions OpenStack Interview Questions Oracle DBA Interview Questions Pascal Interview Questions Perl interview questions Phalcon Framework Interview Questions PhantomJS Interview Questions PhoneGap Interview Questions Php Interview Questions PL/SQL Interview Questions PostgreSQL Interview Questions PouchDB Interview Questions Prototype Interview Questions Pure CSS Interview Questions Python Interview Questions R programming Language Interview Questions React Native Interview Questions ReactJS Interview Questions RequireJs Interview Questions RESTful Web Services Interview Questions RPA Interview Questions Ruby Interview Questions Ruby on Rails Interview Questions SAS Interview Questions SASS Interview Questions Scala Interview Questions Sencha Touch Interview Questions SEO Interview Questions Servlet Interview Questions SQL Interview Questions SQL Server Interview Questions SQLite Interview Questions Struts Interview Questions SVG Interview Questions Swift Interview Questions Symfony PHP Framework Interview Questions T-SQL(Transact-SQL) Interview Questions TurboGears Framework Interview Questions TypeScript Interview Questions UiPath Interview Questions VB Script Interview Questions VBA Interview Questions WCF Interview Questions Web icon Interview Questions Web Service Interview Questions Web2py Framework Interview Questions WebGL Interview Questions Website Development Interview Questions WordPress Interview Questions Xamarin Interview Questions XHTML Interview Questions XML Interview Questions XSL Interview Questions Yii PHP Framework Interview Questions Zend Framework Interview Questions

Top 25 DB2 Interview question for 2020

1) Give breif detail about DB2?

DB2 is a Relational Database Management System developed by IBM. It supports Object Oriented features and non-relational structures with XML.

2) Enlist the types of datatypes available in DB2?

  • Integer
  • Float
  • Decimal
  • Char
  • Varchar
  • Date
  • Time

3) What is Instance in DB2?

Instance is a logical Environment of DB2 Database Manager. It helps in managing database also, we can create multiple instance on one physical machine.

4) Enlist the content of instance directory.

  • Database Manager Configuration file
  • System Database Directory
  • Node Directory
  • Node Configuration File
  • Debugging files, dump files

5) What is Bufferpool?

The Database Manager allocates some memory on the main memory space known as Bufferpool. It is designed to cache table and index data from disk.

6) Enlist the types of bufferpool.

  • BP0
  • BP1
  • BP2
  • BP32

7) What are "Dirty Pages"?

Pages in the bufferpool which are updated with data but not written onto the disk those pages are known as Dirty Pages.

8) What is tables in DB2 and give its types?

Tables is a logical structure maintain by database manager. It consist of Tuple which is column and Entity which is row. Types of tables are:
  • Basic Tables
  • Temporary Tables
  • Materialized Query Tables

9) Describe DB2 constraint?

DB2 constraint is a set of rules which maintains database integrity. Here, are some types of constraint:
  • NOT NULL
  • Primary Key
  • Foreign Key
  • Unique Key etc.

10) What is the picture clause of Null indicator variable?

Picture clause of Null indicator variable is S9(4)COMP.

11) Define DCLGEN in DB2.

DCLGEN stands for Declaration Generator which describes a table or view for SQL statements.

12) What is the use of DB2 optimizer.

  • It is used to process SQL Statements.
  • To select the access path we uses DB2 optimizer.

13) What is SQLCA and its maximum length.

SQLCA (SQL Communication Area) is a structure of variable which is updated after each execution of SQL statements. Its maximum length is 136.

14) Explain DBRM in DB2.

DBRM stands for Database Request Model which is created by the pre-compiler of DB2. It consist of SQL source statements which is taken from application program.

15) Describe RCT.

RCT (Resource Control Table) which is defined in DB2/CICS region. It consist of the features which is gathered from macros of DSNCRCT.

16) What is DB2 bind?

The process that builds access paths to the DB2 table is known as bind. The bind uses Database Request Modules from the DB2 pre-compile step as input and produces an application plan.

17) Enlist types of page locks.

There are 3 types of page locks as enlisted below:
  • Exclusive
  • Update
  • Share

18) Define Predicate.

Predicate is the element of a search condition. Predicate is used to express or implies a search condition.

19) Explain Buffer Manager.

Buffer Manager helps in transferring data between virtual as well as external medium. The buffer manager reduces the quantity of physical input as well as output operations that are actually performed by making use of buffering techniques that are highly sophisticated.

20) What is cursor stability?

Cursor stability is the property that values of database that are read by making use of this application gets protected while the data is used.

21) What is RELEASE/ACQUIRE in BIND?

RELEASE in bind is used when we have to change the locks condition of the database for user. RELEASE helps in page locks to be free from cache memory.

22) What are different locking levels?

  • Table
  • Page
  • TableSpace

23) Explain component of DCLGEN.

There are two components of DCLGEN are:
  • A copy book of the host language, which will give alternative definitions for all the column names.
  • In terms of the data-types of DB2, EXEC SQL DECLARE TABLE shows an aesthetic layout of the table.

24) Explain SYSIBM.SYSLINKS table?

It is a table that contains information on the links that exists between the tables created through referential constraints.

25)What are the Isolation levels possible

  • CS: Cursor Stability
  • RR: Repeatable Read



ADVERTISEMENT
ADVERTISEMENT