DB2 is a Database Management System for the MVS Operating System Top 50 DB2 Interview Questions & Answers .. Download PDF. Here are top 34 objective type sample DB2 Interview questions and their answers are given just below to them. These sample questions are framed by experts. DB2 INTERVIEW QUESTIONS AND ANSWERS MAINFRAME Interview Questions faqs DB2 ibm db2 sql interview questions and answers.

Db2 Interview Questions And Answers Pdf

Language:English, Japanese, French
Genre:Academic & Education
Published (Last):29.07.2016
ePub File Size:20.48 MB
PDF File Size:11.79 MB
Distribution:Free* [*Sign up for free]
Uploaded by: MARIS

+ Ibm Db2 Interview Questions and Answers, Question1: What is DB2 (IBM Database 2)? Question2: What is an access path? Question3: What is an alias?. IBM DB2 Interview Questions and Answers - Free download as PDF File .pdf), Text File .txt) or read online for free. IBM DB2 Interview Questions and Answers. DB2 Interview Questions - Learn DB2 Concepts in simple and easy steps starting and later they continue based on further discussion and what you answer −.

Top DB2 Interview Questions And Answers

Tables are stored in Table Space hence the name! There are three types of Table Space simple. What is the database descriptor? The database descriptor. Is there any advantage to De normalizing DB2 tables? De-normalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys. What is a cursor and what is its function?

An 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. What is a NULL value?

IBM DB2 Interview Questions and Answers

A 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.

What is referential integrity? Referential integrity refers to the consistency that must be maintained between primary and foreign keys. Flag for inappropriate content.

Related titles. Jump to Page. Search inside document. Pradeep Tiwari. Ashlesh Kumar. Miraz Galib. Maanas Khurana.

Poornima S. Satish Pandey. Sandeep Varma's. Adorn Chicle. Priyanka Kashyap. Satyendra Sah.

The Dangerous One. Sudheer Narne.

Lavanya Karthik. Le Minh.

Dinesh Aila. Laxmikant Yadav. To do partial search e. How can you get a list of employees who are not assigned to any project? A subquery in which the inner nested query refers back to the table in the outer query.

Correlated subqueries must be evaluated for each qualified row of the outer query that is referred to. Apart from cursor, what other ways are available to you to retrieve a row from a table in embedded SQL?

Other wise simply the cursor is placed on the first row. But, it has not effect in psuedo-conversational CICS programs. DCLGEN being a tool, would generate accurate host variable definitions for the table reducing chances of error. This is used by the pre-compiler to validate the table-name, view-name, column name etc. Locks should be taken on objects in single tablespace for escalation to occur.

A result of the BIND process. Determine the point at which DB2 acquires or releases locks against table and tablespaces, including intent locks.

It has not physical existence. Main usage is to group packages. What do you do? Off late, I find that the performance has deteriorated. What happened? A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path. It also collects statistics used for space management.

These statistics are stored in DB2 catalog tables.

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

A state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. It means that the LOAD utility did not perform constraint checking. Causes the data rows to be stored in the order specified in the index.

A mandatory index defined on a partitioned table space. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key. Unique index: There can be one or more unique indexes on a table.

Not all of them. Some views are updateable e. Inner Join: This kind of join which involve a match in both columns are called inner joins.

Outer join is one in which you want both matching and non matching rows to be returned. DB2 has no specific operator for outer joins, it can be simulated by combining a join and a correlated sub query with a UNION. Tablespace is divided into segments of 4 to 64 pages in increments of 4 pages. Each segment is dedicated to single table. A table can occupy multiple segments. Synonym is an alternate name for a table or view used mainly to hide the leading qualifier of a table or view..

A synonym is accessible only by the creator. Synonym is available only to the creator. ALIAS can be created even if the table does not exist. It is used mainly in distributed environment to hide the location info from programs. Use it when you do not want to have nulls but at the same time cannot give values all the time you insert this row.Now i want to change the first letter of every name with capital.

IBM DB2 Related Tutorials

Plan is marked as invalid. How do you filter out the rows retrieved from a Db2 table? What is the difference between group by and order by? CS: Releases the lock on a page after use RR: Retains all locks acquired till end of transaction 52 Where do you specify them?

Explain the Function done by data manager? These table or view descriptions are then used to check the validity of other SQL statements at precompile time.