Here is list of most common DB2 Questions and Answers for IBM Interview 2018. These questions are asked by every employer in the year 2018 and the sample answers provide for 2018. Please note these questions and collected from different forums, where recent job seekers have posted these DB2 Questions and Answers for IBM Interview.

Also Read List of other Sample IBM Questions and Answers for Interview.

Sample CICS Questions and Answers for IBM Interview Sample JCL Questions and Answers for IBM Interview
Sample VSAM Questions and Answers for IBM Interview Sample COBOL Questions and Answers for IBM Interview
Sample DB2 Questions and Answers for IBM Interview Sample IDMS Questions and Answers for IBM Interview
Sample IMS Questions and Answers for IBM Interview Sample MVS Questions and Answers for IBM Interview


Here is List of Sample DB2 Questions and Answers for IBM Interview
Sample DB2 Questions and Answers for IBM Interview

NODB2 Questions and Answers for IBM Interview
1
What are foreign keys?
ANSThese are attributes of one table that have matching values in a primary key in another table,allowing for relationships between tables.
2
Describe the elements of the SELECT query syntax.
ANS
SELECT element FROM table WHERE conditional statement.
3
Explain the use of the WHERE clause.
ANS
WHERE is used with a relational statement to isolate the object element or row.
4
What techniques are used to retrieve data from more than one table in a single SQL Statements?
ANS
Joins, unions and nested selects are used to retrieve data
5What do the initials DDL and DML stand for and what is their meaning?
ANSDDL is data definition language and DML is data manipulation language DDL statements are CREATE, ALTER, TRUNCATE DML statements are SELECT, INSERT,DELETE and UPDATE.
6What is a view? Why use it?
ANSA view is a virtual table made up of data from base tables and other views, but not stored separately.
7Explain an outer join.
ANS
An outer join includes rows from tables when there are no matching values in the Tables.
8What is a sub select? Is it different from a nested select?
ANS
Sub select is a select which works in conjunction with another select A nested select is a kind of Sub Select where the inner select passes to the where criteria for the outer select.
9What is the difference between group by and order by?
ANSGroup by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement .
10
Explain the EXPLAIN statement.
ANSThe explain statement provides information about the optimizer’s choice of access path of the SQL.
11What is Table Space?
ANS
Tables are stored in Table Space (hence the name)! There are three types of Table Spacesimple, segmented and partitioned.
12What is a cursor and what is its function?
ANSAn embedded Sql statement may return a number of rows while the programming language can only access one row at a time The programming device called a cursor controls the position of the row.
13What is referential integrity?
ANS
Referential integrity refers to the consistency that must be maintained between primary and foreign keys, ie every foreign key value must have a corresponding primary key value.
14
Usually, which is more important for DB2 system performance – CPU processingor I/O access?
ANSI/O operations are usually most critical for DB2 performance (or any other database for that matter)
15Is there any advantage to De normalizing DB2 tables?
ANS
De-normalizing DB2 tables reduces the need for processing intensive relational joins andreduces the number of foreign keys.
16What is the database descriptor ?
ANS
The database descriptor, DBD is the DB2 component that limits access to the database whenever objects are created, altered or dropped.
17What is lock contention?
ANSTo maintain the integrity of DB2 objects the DBD permits access to only on object at a time Lock contention happens if several objects are required by contending application processes simultaneously.
18What is SPUFI?
ANS
SPUFI stands for SQL processing using File input It is the DB2 interactive menu-driventool used by developers to create database objects.
19
What is the significance of DB2 free space and what parameters control it?
ANS
The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between each free page Free space allows room for the insertion of new rows.
20What is a NULL value? What are the pros and cons of using NULLS?
ANSA NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value It’s the DB2 equivalent of TBD on an organizational chart and often correctly portrays a business situation Unfortunately, it requires extra coding for an application program to handle this situation.
http://techhowdy.com/wp-content/uploads/2018/01/Sample-DB2-Questions-and-Answers-for-IBM-Interview-1024x614.pnghttp://techhowdy.com/wp-content/uploads/2018/01/Sample-DB2-Questions-and-Answers-for-IBM-Interview-150x150.pngDemonInterview QuestionsHere is list of most common DB2 Questions and Answers for IBM Interview 2018. These questions are asked by every employer in the year 2018 and the sample answers provide for 2018. Please note these questions and collected from different forums, where recent job seekers have posted these DB2...Latest technology news