sppn.info Laws Db2 Interview Questions And Answers Pdf


Thursday, July 4, 2019

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, Spanish, Dutch
Genre:Science & Research
Published (Last):
ePub File Size: MB
PDF File Size: MB
Distribution:Free* [*Regsitration Required]
Uploaded by: BUCK

+ 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 −.

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.

DB2 Interview Questions

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. When a column which contains long text, e.

Give the exact DDL. Recording SQL statements that access a table. Specified at table creation time or through alter. SQL Query: What are the wildcard characters?

For three reasons: The chance of an index only scan is lost. What are correlated subqueries? Cursor should be used because the host language can deal with only one row at a time.

A host language copy book that gives the host variable definitions for the column names.

If not, why would you use it at all? Why it used?

Because the precompiler does not refer to the DB2 catalogue tables. An example is shown: What does it mean?

IBM DB2 Interview Questions and Answers

Use a question mark in place of a host variable or an unknown value. Cursor Stability RR: Releases the lock on a page after use RR: Retains all locks acquired till end of transaction 52 Where do you specify them? During the BIND process. I use CS and update a page. Will the lock be released after I am done with that page?

Based on the lock-size given while creating the tablespace 2. Programmer can direct the DB2 what lock-size to use 3. To lock a view, take lock on the underlying tables. There are three types of Table Space simple, segmented and partitioned 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 referential integrity?

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. 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 the database descriptor? The database descriptor, DBD is the DB2 component that limits access to the database whenever objects are created, altered or dropped.

No need to bind all the packages. What does a positive SQL code indicates? A negative SQL code indicates a failure while a positive one indicates an exception. Which statement is used to revoke the access from a database? Which statement is used to authorize access on database tables?

In which statement you can define primary key? How many primary keys can be declared on a table? A table can have only one primary key. Write a query to delete a table from database. Write the query to delete all the rows from a table.

20 DB2 Interview Questions and Answers

Char data type maximum size is of bytes. Varchar data type maximum size is of bytes. In which format index in stored?

An indexed is stored in B-tree format. Which index must be present for partitioned table space? A partitioned table space must have a clustered index.

What is Next ?

Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias? How many clustering index we can have for a single table?

We can have only one clustering index for a table.

What is Next? Further you can go through your past assignments you have done with the subject and make sure you are able to speak confidently on them.

If you are fresher then interviewer does not expect you will answer very complex questions, rather you have to make your basics concepts very strong. Second it really doesn't matter much if you could not answer few questions but it matters that whatever you answered, you must have answered with confidence.The Join statement combines data from more that two tables. Database services component is responsible for execution of SQL statements and it manages buffer pool also.

What Is Declaration Generator dclgen? Online Classroom. Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace.

What is the input to the bind process? How to convert non-db2 files into db2 format for ex. Enrol Today. Synonyms get dropped automatically when we drop the table but alias of the table remains there.