Discussion
Home ‣ Interview ‣ Technology Comments
- Question
Difference between Embeded SQL and Dynamic SQL?
- Correct Answer
- Static (embedded) SQL: 1In static SQL how database will be accessed is predetermined in the embedded SQL statement 2It is more swift and efficient 3SQL statements are compiled at compile time 4Parsing, validation, optimization, and generation of application plan are done at compile time 5It is generally used for situations where data is distributed uniformly 6EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used 7 It is less flexible Dynamic (interactive) SQL: 1In dynamic SQL, how database will be accessed is determined at run time 2It is less swift and efficient 3SQL statements are compiled at run time 4Parsing, validation, optimization, and generation of application plan are done at run time 5It is generally used for situations where data is distributed non-uniformly 6EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used 7It is more flexible
- 1. How do you display last 5 records in DB2? Discuss
- 2. What is NOTCAT2? Discuss
- 3. Name and explain the type of locks? Discuss
- 4. What is sqlcode -811? Discuss
- 5. What is REORG? When it is used? Discuss
- 6. What is DBRM? What it contains? When it will be created? Discuss
- 7. How does DB2 use multiple table indexes? Discuss
- 8. What is SPUFI? Discuss
- 9. What is Mainframe Testing? Discuss
- 10. What is SQLCA? Discuss
Technology problems
Search Results
Correct Answer: SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;
Correct Answer: It is an MVS message that indicates the presence of a duplicate catalogue in the database This problem can be fixed by removing one of the entries and then adding a new one
Correct Answer: There are three types of lock, namely: Shared ? This type of lock permits two or more programs to read from the locked space but does not allow them to change it Update ? This lock is more lenient It permits the program to read and change the locked space Exclusive ? This lock restricts all users from accessing the locked space
Correct Answer: SELECT statement has resulted in retrieval of more than one row
Correct Answer: 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
Correct Answer: - DBRM stands for Database Request Module - The output of pre-compile process is represented as DBRM - The SQL statements are extracted from the host language by the pre-compiler
Correct Answer: DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR
Correct Answer: SPUFI stands for SQL processing using file input It is the DB2 interactive menu-driven tool used by developers to create database objects
Correct Answer: Mainframe Testing is similar to client-server applications testing, but you have to know how to operate basic TSO and ISPF commands and menus, view mainframe files, look at and use SDSF or other output tool, log on CICS and transactions, use FTP or another transfer protocol, submit the batch job - it's for QA testing of mainframe applications
Correct Answer: - SQLCA stands for SQL Communication Area - SQLCA is a structure of variables which are updated after every SQL statement?s execution - Exactly only one SQLCA need to be provided to an application that contains executable SQL statements - SQLCA is not applicable to JAVA application - More than one SQLCA need to be provided for FORTRAN application
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.