Prepare Interview with Confidence
What is the physical storage length of TIME data type? The physical storage length of TIME data type is 3 bytes. Which component is used to execute the SQL statements? Database Services component is used to execute the SQL statement. It also manages buffer pool. On which levels locks can be applied? Locking can be … Read more
What is CHECK constraint in DB2? Check constraint is a database rule that checks data integrity. Thus, only values from the domain for the attribute or column are allowed. What is the use of predicate? Predicates are used to enhance the performance of query. What is the use of DB2 Optimizer? DB2 Optimizer is used … Read more
What is RCT? Resource Control Table (RCT) is controller that directs the CICS DB2 interface. Using DSNCRCT, RCT can produce a micro table. What is SPUFI? SPUFI stands for SQL Processor Using File Input. Give the name of some fields form SQLCA. The following three are the fields from SQLCA: SQLCODE SQLERRM SQLERRD What is … Read more
What is the physical storage length of TIMESTAMP data type? TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD: HH: MM:SS-NNNNNN What is SQLCA? SQLCA stands for Server Query Language Communication Area. Basically, it is a collection of variables that may be updated after the execution of every SQL statement. A program having SQL … Read more
What is the physical storage length of DATE data type? The physical storage length of TIME data type is 4 bytes. How many types of page locks can be held in DB2? Three types of page locks can be held in DB2: Exclusive Update Share What is DBRM? DBRM stands for Database Request Module. It … Read more
DB2 Interview Questions – Set 05 DB2 Interview Questions – Set 04 DB2 Interview Questions – Set 03 DB2 Interview Questions – Set 02 DB2 Interview Questions – Set 01
If you are looking for Self Assessment Technical Mock Test to prepare you Interview, you are at right place. We are offering Self Assessment Technical Interview Mock Test Series. Contact us in chat box, we will call you back.
If you are looking for Corporate Assessment Test for Interview Screening the Candidates who applied for job vacancies, you are at right place. We are offering Corporate Assessment Test for Interview Screening. Contact us in chat box, we will call you back.
Eklavya Online is Free Study Portal for NewBies and Experienced Guys who wanna upgrade their knowledge in their respective industry and strive to learn more.